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:
[email protected]


Reply via email to