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 2021/09/22 10:52:11 UTC

[GitHub] [shardingsphere] daodefengshang opened a new issue #12624: Throw an exception when parsing sql

daodefengshang opened a new issue #12624:
URL: https://github.com/apache/shardingsphere/issues/12624


   
   ### Which version of ShardingSphere did you use?
   4.1.1
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-JDBC
   ### Expected behavior
   send the sql to mysql
   ### Actual behavior
   Throw an exception
   Cause: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.LiteralExpressionSegment
   ### Reason analyze (If you can)
   ShardingSphere-JDBC cannot correctly identify the parameters in the select statement
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   select ? as id
   ### 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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] strongduanmu commented on issue #12624: Throw an exception when parsing sql

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


   This sql has been supported in the master branch, you can try it.


-- 
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] strongduanmu commented on issue #12624: Throw an exception when parsing sql

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


   Hi @daodefengshang, can you try the latest version? It has a better support for sql parse.


-- 
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 #12624: Throw an exception when parsing sql

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


   @daodefengshang I had checked it on master branch, it's already supported.


-- 
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] strongduanmu closed issue #12624: Throw an exception when parsing sql

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #12624:
URL: https://github.com/apache/shardingsphere/issues/12624


   


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