[Bug]: error when executed "create table t1 (a varchar(1)) partition by key (a) as select 'a';"

### Is there an existing issue for the same bug?

- [X] I have checked the existing issues.

### Branch Name

main

### Commit ID

b2d8e4aefb0d7b3b3d7deb19a772c6bbfa973a9f

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

mo:
mysql> create table t1 (a varchar(1)) partition by key (a) as select 'a';
ERROR 1064 (HY000): SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 54 near " as select 'a'";

mysql:
mysql> create table t1 (a varchar(1))
-> partition by key (a)
-> as select 'a';
Query OK, 1 row affected (0.02 sec)
Records: 1 Duplicates: 0 Warnings: 0

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
create table t1 (a varchar(1)) partition by key (a) as select 'a';
```

### Additional information

_No response_