You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/04/12 08:17:07 UTC

[GitHub] [shardingsphere] RaigorJiang opened a new issue, #16762: Query result of `SHOW TABLES` is abnormal.

RaigorJiang opened a new issue, #16762:
URL: https://github.com/apache/shardingsphere/issues/16762

   ## Bug Report
   ### Which version of ShardingSphere did you use?
   ShardingSphere-Proxy ([#2b53353e](https://github.com/apache/shardingsphere/commit/2b53353ef4179ffeb5e6a36ca8b44858f7773a97))
   
   ### Background
   I hava a logic table `t_order`:
   ```sql
   mysql> show tables;
   +-----------------------+------------+
   | Tables_in_sharding_db | Table_type |
   +-----------------------+------------+
   | t_order               | BASE TABLE |
   ```
   
   ### Expected behavior
   ```sql
   mysql> show tables like 't_order';
   +-----------------------+------------+
   | Tables_in_sharding_db | Table_type |
   +-----------------------+------------+
   | t_order               | BASE TABLE |
   +-----------------------+------------+
   
   mysql> show tables like 'T_ORDER';
   +-----------------------+------------+
   | Tables_in_sharding_db | Table_type |
   +-----------------------+------------+
   | t_order               | BASE TABLE |
   +-----------------------+------------+
   ```
   
   ### Actual behavior
   ```sql
   mysql> show tables like 't_order';
   +-----------------------+------------+
   | Tables_in_sharding_db | Table_type |
   +-----------------------+------------+
   | t_order               | BASE TABLE |
   +-----------------------+------------+
   
   mysql> show tables like 'T_ORDER';
   Empty set (0.00 sec)
   ```
   
   ### Reason analyze (If you can)
   The filter conditions of show tables are not case-insensitive
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu closed issue #16762: Query result of `SHOW TABLES` is abnormal.

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #16762: Query result of `SHOW TABLES`  is abnormal.
URL: https://github.com/apache/shardingsphere/issues/16762


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org