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/26 06:49:58 UTC

[GitHub] [shardingsphere] 5661954 opened a new issue #12728: parse sql error

5661954 opened a new issue #12728:
URL: https://github.com/apache/shardingsphere/issues/12728


   ## Bug Report
   
   the  version of ShardingSphere 4.1.1
   ShardingSphere-JDBC
   parse sql error,  run sql in mysql console is right ,but use mybatis, there throw exception like next:
   '''
   ### Error querying database.  Cause: java.lang.ClassCastException: class 
   org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment cannot be cast to class org.apache.shardingsphere.sql.parser.sql.segment.dml.column.ColumnSegment (org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment and org.apache.shardingsphere.sql.parser.sql.segment.dml.column.ColumnSegment are in unnamed module of loader 'app')
   ### The error may involve defaultParameterMap
   ### The error occurred while setting parameters
   ### SQL: select           id, asset_ins_id, product_ins_id,  create_time, update_time         from relation            where (product_ins_id,asset_ins_id) in        (  (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) , (?,?) )
   '''
   
   
   


-- 
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] terrymanu commented on issue #12728: parse sql error

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


   The version is pretty old, cloud you test `master` branch again? 


-- 
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 #12728: parse sql error

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


   @5661954 I checked this sql in master, it is supported now. 


-- 
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 #12728: parse sql error

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


   This sql has been supported in master branch, you can try the latest version `5.0.0-beta`.


-- 
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 #12728: parse sql error

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


   


-- 
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 #12728: parse sql error

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


   @tuichenchuxin Can you help check this sql parse on master branch?


-- 
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 #12728: parse sql error

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


   @strongduanmu  ok, I'll check later.


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