总结:
mysql 默认表名区分大小写,但是分区表中子分区名不区分大小;
mysql> create table t1 (val int)
-> partition by list(val)(-> partition my values in (1,2,3),
-> partition MY values in (4,5,6)
-> );
ERROR 1517 (HY000): Duplicate partition name MY
mysql> create table T1 (val int)
-> partition by list(val)(
-> partition my values in (1,2,3),
-> partition MY1 values in (4,5,6)
-> );
Query OK, 0 rows affected (0.98 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| T1 |
| tblist |
| test0 |
| test11_lixoara |
| test111 |
| tint |
| tint1 |
| lixora |
+----------------+
8 rows in set (0.00 sec)