[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #4182: Sharding-proxy 4.0.0 can query columns for table

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

KomachiSion commented on issue #4182: Sharding-proxy 4.0.0 can query columns for table
URL: https://github.com/apache/incubator-shardingsphere/issues/4182#issuecomment-582779991
 
 
   ```
   [INFO ] 15:27:04.980 [ShardingSphere-Command-4] ShardingSphere-SQL - Rule Type: sharding
   [INFO ] 15:27:04.981 [ShardingSphere-Command-4] ShardingSphere-SQL - Logic SQL: SHOW FULL TABLES FROM `sharding_db` LIKE 't_order'
   [INFO ] 15:27:04.981 [ShardingSphere-Command-4] ShardingSphere-SQL - SQLStatement: CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dal.dialect.mysql.ShowTablesStatement@7d8a9fd6, tablesContext=TablesContext(tables=[Table(name=t_order, alias=Optional.absent())], schema=Optional.absent()))
   [INFO ] 15:27:04.981 [ShardingSphere-Command-4] ShardingSphere-SQL - Actual SQL: ds_0 ::: SHOW FULL TABLES  LIKE 't_order_0'
   [ERROR] 15:27:04.993 [ShardingSphere-Command-5] o.a.s.s.f.c.CommandExecutorTask - Exception occur: 
   org.apache.shardingsphere.core.config.ShardingConfigurationException: Cannot find table rule and default data source with logic table: '%'
   	at org.apache.shardingsphere.core.rule.ShardingRule.getTableRule(ShardingRule.java:191)
   	at org.apache.shardingsphere.core.route.type.unicast.UnicastRoutingEngine.route(UnicastRoutingEngine.java:78)
   	at org.apache.shardingsphere.core.route.router.sharding.ShardingRouter.route(ShardingRouter.java:113)
   	at org.apache.shardingsphere.core.route.StatementRoutingEngine.route(StatementRoutingEngine.java:54)
   	at org.apache.shardingsphere.core.SimpleQueryShardingEngine.route(SimpleQueryShardingEngine.java:58)
   	at org.apache.shardingsphere.core.BaseShardingEngine.executeRoute(BaseShardingEngine.java:85)
   	at org.apache.shardingsphere.core.BaseShardingEngine.shard(BaseShardingEngine.java:68)
   	at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.wrapper.StatementExecutorWrapper.doShardingRoute(StatementExecutorWrapper.java:79)
   	at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.wrapper.StatementExecutorWrapper.route(StatementExecutorWrapper.java:65)
   	at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:83)
   	at org.apache.shardingsphere.shardingproxy.backend.text.admin.UnicastBackendHandler.execute(UnicastBackendHandler.java:57)
   	at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:73)
   	at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:92)
   	at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   	at java.lang.Thread.run(Thread.java:748)
   ```

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


With regards,
Apache Git Services