[GitHub] [shardingsphere] tristaZero opened a new issue #9240: No schema checking when execute a `select * from` SQL

[GitBox <gi...@apache.org>]

tristaZero opened a new issue #9240:
URL: https://github.com/apache/shardingsphere/issues/9240


   ### Version
   Master branch
   
   ### Test process
   
   ```sql
   ▶ ./mysql -uroot -P3307 -h127.0.0.1 -proot
   mysql: [Warning] Using a password on the command line interface can be insecure.
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 2
   Server version: 8.0.20-ShardingSphere-Proxy 5.0.0-beta MySQL Community Server - GPL
   
   Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
   
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   mysql> select * from t_order;
   +----------+---------+--------+
   | order_id | user_id | status |
   +----------+---------+--------+
   |        1 |       1 | NULL   |
   |        1 |       2 | NULL   |
   |        2 |       2 | NULL   |
   |        2 |       1 | NULL   |
   +----------+---------+--------+
   4 rows in set (1.84 sec)
   
   mysql> use sharding_db
   Database changed
   ```
   ### Issue point
   There is no checking for `schema` when executing this query.
   
   ### Expected result
   An exception is thrown up when a `select` query is executed ahead of `use db`;


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

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

[GitHub] [shardingsphere] menghaoranss closed issue #9240: No schema checking when execute a `select * from` SQL

[GitBox <gi...@apache.org>]

menghaoranss closed issue #9240:
URL: https://github.com/apache/shardingsphere/issues/9240


   


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

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

[GitHub] [shardingsphere] menghaoranss closed issue #9240: No schema checking when execute a `select * from` SQL

[GitBox <gi...@apache.org>]

menghaoranss closed issue #9240:
URL: https://github.com/apache/shardingsphere/issues/9240


   


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

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