shardingsphere-proxy版本5.1.0
SQL:
mysql> SHOW FULL TABLES FROM `test` LIKE 'act_id_property';
+-----------------+------------+
| Tables_in_test | Table_type |
+-----------------+------------+
| act_id_property | BASE TABLE |
+-----------------+------------+
1 row in set (0.00 sec)
mysql> SHOW FULL TABLES FROM `test` LIKE 'ACT_ID_PROPERTY';
Empty set (0.00 sec)
mysql> select * from ACT_ID_PROPERTY;
+----------------+---------+------+
| NAME_ | VALUE_ | REV_ |
+----------------+---------+------+
| schema.version | 6.5.0.6 | 1 |
+----------------+---------+------+
1 row in set (0.01 sec)
MySQL设置了大小写不敏感,大写查询没有结果,小写查询有结果。
为什么会出现这种情况?