You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "young138120 (via GitHub)" <gi...@apache.org> on 2023/04/20 01:04:07 UTC
[GitHub] [shardingsphere] young138120 opened a new issue, #25247: when i login to proxy server and execute 'use database' ,always 'SHOW COLUMNS FROM table'
young138120 opened a new issue, #25247:
URL: https://github.com/apache/shardingsphere/issues/25247
I deploy the proxy server with 5.3.2 version and I defind database with many of datasource
start the proxy server successful
but，when i login proxy server by mysql client and execute comand 'use database'
it will log like this：
`
[INFO ] 2023-04-20 08:56:55.693 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Logic SQL: SHOW COLUMNS FROM sy_fanwei FROM jn_proxy_db
[INFO ] 2023-04-20 08:56:55.693 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_now ::: SHOW COLUMNS FROM sy_fanwei
[INFO ] 2023-04-20 08:56:55.744 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Logic SQL: SHOW COLUMNS FROM or_rescue_order_201909 FROM jn_proxy_db
[INFO ] 2023-04-20 08:56:55.744 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_now ::: SHOW COLUMNS FROM or_rescue_order_201909
[INFO ] 2023-04-20 08:57:02.670 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Logic SQL: SHOW COLUMNS FROM sy_user_info FROM jn_proxy_db
[INFO ] 2023-04-20 08:57:02.670 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_now ::: SHOW COLUMNS FROM sy_user_info
[INFO ] 2023-04-20 08:57:02.762 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Logic SQL: SHOW COLUMNS FROM or_pay_record FROM jn_proxy_db
[INFO ] 2023-04-20 08:57:02.762 [Connection-5-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_now ::: SHOW COLUMNS FROM or_pay_record
`
show columns all of table in the database，why is it do that？
--
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 commented on issue #25247: when i login to proxy server and execute 'use database' ,always 'SHOW COLUMNS FROM table'
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #25247:
URL: https://github.com/apache/shardingsphere/issues/25247#issuecomment-1515597235
This sql is sent by mysql client, you can use ` mysql -u root -h 127.0.0.1 -P 3307 -proot -c -A` to login Proxy.
--
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
[GitHub] [shardingsphere] young138120 closed issue #25247: when i login to proxy server and execute 'use database' ,always 'SHOW COLUMNS FROM table'
Posted by "young138120 (via GitHub)" <gi...@apache.org>.
young138120 closed issue #25247: when i login to proxy server and execute 'use database' ,always 'SHOW COLUMNS FROM table'
URL: https://github.com/apache/shardingsphere/issues/25247
--
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
[GitHub] [shardingsphere] young138120 commented on issue #25247: when i login to proxy server and execute 'use database' ,always 'SHOW COLUMNS FROM table'
Posted by "young138120 (via GitHub)" <gi...@apache.org>.
young138120 commented on issue #25247:
URL: https://github.com/apache/shardingsphere/issues/25247#issuecomment-1515604152
3Q for everybody
it is work for me，close the issue
by the way ，shardingsphere has any weixin chat group to communicate ？
i have some of question about how to correct use the shardingsphere proxy，such as ，how to design sharding，and how to config the default datasource ， why is it not work that sharding datasource table join single table and so on。。
--
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
[GitHub] [shardingsphere] tuichenchuxin commented on issue #25247: when i login to proxy server and execute 'use database' ,always 'SHOW COLUMNS FROM table'
Posted by "tuichenchuxin (via GitHub)" <gi...@apache.org>.
tuichenchuxin commented on issue #25247:
URL: https://github.com/apache/shardingsphere/issues/25247#issuecomment-1515597636
I think these statements are sent by the client.
--
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
[GitHub] [shardingsphere] TeslaCN commented on issue #25247: when i login to proxy server and execute 'use database' ,always 'SHOW COLUMNS FROM table'
Posted by "TeslaCN (via GitHub)" <gi...@apache.org>.
TeslaCN commented on issue #25247:
URL: https://github.com/apache/shardingsphere/issues/25247#issuecomment-1515599745
Try using `mysql` with `-A` option.
--
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