MingxingLAI opened a new pull request #14301:
URL: https://github.com/apache/shardingsphere/pull/14301


   Fixes #14101 .
   
   Changes proposed in this pull request:
   - show tables statement return correct result when mysql is case sensitive
   - add more unit test for ShowTablesExecutor
   
   expected result:
   
   ```bash
   mysql> show tables;
   +-----------------------+------------+
   | Tables_in_sharding_db | Table_type |
   +-----------------------+------------+
   | t_address             | BASE TABLE |
   | t_order_item          | BASE TABLE |
   | t_order               | BASE TABLE |
   | TEST                  | BASE TABLE |
   | t_account_0           | BASE TABLE |
   | t_account_1           | BASE TABLE |
   +-----------------------+------------+
   6 rows in set (0.00 sec)
   
   mysql>  SHOW TABLES LIKE 'test';
   Empty set (0.01 sec)
   
   mysql>  SHOW TABLES LIKE 'TEST';
   +-----------------------+------------+
   | Tables_in_sharding_db | Table_type |
   +-----------------------+------------+
   | TEST                  | BASE TABLE |
   +-----------------------+------------+
   1 row in set (0.01 sec)
   ```
   


-- 
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]


Reply via email to