You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/07/29 07:40:58 UTC

[GitHub] [shardingsphere] lwtdev opened a new issue #6482: Unsupported SQL of sctl:explain

lwtdev opened a new issue #6482:
URL: https://github.com/apache/shardingsphere/issues/6482


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.0.0-RC1-SNAPSHOT
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   ### Expected behavior
   ```
   mysql> sctl:explain select 1;
   +-----------------+----------+
   | datasource_name | sql      |
   +-----------------+----------+
   | ds_0            | select 1 |
   +-----------------+----------+
   ```
   ### Actual behavior
   ```
   mysql>  sctl:explain select 1;
   ERROR 10002 (C1000): 2Unknown exception: [Unsupported SQL of `sctl:explain select 1`]
   ```
   ### Reason analyze (If you can)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   ```sql
   sctl:explain select 1;
   ```
   ### Example codes for reproduce this issue (such as a github link).
   


----------------------------------------------------------------
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] lwtdev commented on issue #6482: Unsupported SQL of sctl:explain

Posted by GitBox <gi...@apache.org>.
lwtdev commented on issue #6482:
URL: https://github.com/apache/shardingsphere/issues/6482#issuecomment-664790921






----------------------------------------------------------------
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] lwtdev edited a comment on issue #6482: Unsupported SQL of sctl:explain

Posted by GitBox <gi...@apache.org>.
lwtdev edited a comment on issue #6482:
URL: https://github.com/apache/shardingsphere/issues/6482#issuecomment-664790921






----------------------------------------------------------------
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] kimmking commented on issue #6482: Unsupported SQL of sctl:explain

Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #6482:
URL: https://github.com/apache/shardingsphere/issues/6482#issuecomment-665451396


   ```
   mysql> sctl:explain select * from test;
   +-----------------+----------------------+
   | datasource_name | sql                  |
   +-----------------+----------------------+
   | test            | select * from test00 |
   | test            | select * from test01 |
   | test            | select * from test02 |
   | test            | select * from test03 |
   +-----------------+----------------------+
   4 rows in set (0.01 sec)
   
   mysql> sctl:explain select 1;
   +-----------------+----------+
   | datasource_name | sql      |
   +-----------------+----------+
   | test            | select 1 |
   +-----------------+----------+
   1 row in set (0.01 sec)
   
   ```


----------------------------------------------------------------
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] jingshanglu commented on issue #6482: Unsupported SQL of sctl:explain

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6482:
URL: https://github.com/apache/shardingsphere/issues/6482#issuecomment-664777331






----------------------------------------------------------------
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] tristaZero commented on issue #6482: Unsupported SQL of sctl:explain

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6482:
URL: https://github.com/apache/shardingsphere/issues/6482#issuecomment-664859417


   @lwtdev Hi thanks for your feedback.
   @jingshanglu is working on the test for your SQL.
   @cherrylzhao Could you give it a look as well?


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