cqiwencom opened a new issue #11755: URL: https://github.com/apache/shardingsphere/issues/11755
## Bug Report **For English only**, other languages will not accept. Before report a bug, make sure you have: - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues). - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview). Please pay attention on issues you submitted, because we maybe need more details. If no response anymore and we cannot reproduce it on current information, we will **close it**. Please answer these questions before submitting your issue. Thanks! ### Which version of ShardingSphere did you use? ShardingSphere-Proxy 5.0.0-beta ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. Before this operation, I have directly added the ntime column to the T2 table on the backend MySQL server. After ensuring that the operation is completed, I log in through proxy to query and find that the new column is not displayed: [root@DBR920 ~]# mysql -uroot -proot -P3307 -h127.0.0.1 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 32 Server version: 5.7.33-log-ShardingSphere-Proxy 5.0.0-beta Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> select * from testdb.t2; +----+--------+ | id | name | +----+--------+ | 1 | mm | | 2 | gg | | 3 | niuniu | | 4 | hhhh | +----+--------+ 4 rows in set (0.01 sec) MySQL [(none)]> use testdb Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MySQL [testdb]> select @@port; +--------+ | @@port | +--------+ | 3318 | +--------+ 1 row in set (0.01 sec) MySQL [testdb]> exit Bye Then I directly connect to the back-end MySQL server, whose port is the back-end server port 3318 just connected by proxy： [root@DBR920 ~]# mysql -uroot -proot -P3318 -h127.0.0.1 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 158 Server version: 5.7.33-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> select * from testdb.t2; +----+--------+---------------------+ | id | name | ntime | +----+--------+---------------------+ | 1 | mm | 2021-08-11 09:36:37 | | 2 | gg | 2021-08-11 09:36:37 | | 3 | niuniu | 2021-08-11 09:36:37 | | 4 | hhhh | 2021-08-11 09:36:37 | +----+--------+---------------------+ 4 rows in set (0.00 sec) MySQL [(none)]> This indicates that the ntime column exists on the back-end server. But why can't proxy query this column? -- 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]
