RaigorJiang opened a new issue #14090: URL: https://github.com/apache/shardingsphere/issues/14090
### Which version of ShardingSphere did you use? 5.0.1-SNAPSHOT, master branch ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy ### Expected behavior single table can be the same as sharding table, case insensitive ### Actual behavior single table is case sensitive sharding table is case insensitive ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. 1. Prepare tables - `t_order` is a sharding table - `t_single` is a single table: ```sql mysql> show tables; +-----------------------+------------+ | Tables_in_sharding_db | Table_type | +-----------------------+------------+ | t_order | BASE TABLE | | t_single | BASE TABLE | +-----------------------+------------+ 2 rows in set (0.01 sec) ``` 2. Query with uppercase table name ```sql mysql> select * from T_ORDER; Empty set (0.01 sec) mysql> select * from T_SINGLE; ERROR 1997 (C1997): Runtime exception: [`T_SINGLE` single table does not exist.] mysql> ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
