matrixorigin / matrixorigin/matrixone

[Bug]: error when creating partition table whch partition name is the same letter but different case

Open
#18,715 21 comments 0 reactions 1 assignee Claimed by @ck89119 View on GitHub
area/partition deferred kind/bug
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

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

- [X] I have checked the existing issues.

### Branch Name

main

### Commit ID

5e94fb14723c62dfce190dc3f31fcce844f947ac

### Other Environment Information

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

### Actual Behavior

MO:
mysql> create table t1 (s1 int)
-> partition by list (s1)
-> (partition c values in (1),
-> partition Ç values in (3));
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 4 column 17 near " Ç values in (3))";

mysql:
mysql> create table t1 (s1 int)
-> partition by list (s1)
-> (partition c values in (1),
-> partition Ç values in (3));
ERROR 1517 (HY000): Duplicate partition name Ç

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
create table t1 (s1 int)
partition by list (s1)
(partition c values in (1),
partition Ç values in (3));
```

### Additional information

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.