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/09/17 02:22:31 UTC

[GitHub] [shardingsphere] icesugar opened a new issue #7496: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment

icesugar opened a new issue #7496:
URL: https://github.com/apache/shardingsphere/issues/7496


   ## Bug Report
   
   version: ShardingSphere-JDBC 4.1.0
   
   tableStrategy  t_order
   
   
   `shardingRule: 
     tables:
       t_order: 
         actualDataNodes: ds0.t_order_2020,ds0.t_order_2021
         tableStrategy: 
           standard:
             shardingColumn: billdate 
             preciseAlgorithmClassName: com.demo.sharding.DateYearPreciseShardingAlgorithm
             rangeAlgorithmClassName: com.demo.sharding.DateYearRangeShardingAlgorithm
     bindingTables:
       - t_order
     defaultDataSourceName: ds0
     defaultTableStrategy:
       none:`
   
   e.g: update t_user set code='1' where id='1';update t_user set code='2' where id='2';
   
   ### Actual behavior
   Multiple update sql ,Error updating database
   `java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment`
   
   
   If t_order is updated in batches, an error should be reported.
   
   But batch update t_user should not report errors.
   
   


----------------------------------------------------------------
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] terrymanu commented on issue #7496: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment

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


   Closed because of no response anymore.


----------------------------------------------------------------
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 #7496: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment

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


   > e.g: update t_user set code='1' where id='1';update t_user set code='2' where id='2';
   
   Firstly, this type of multiple-update SQL is unsupported. Could you split them as a single one query and have a retest?


----------------------------------------------------------------
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] terrymanu commented on issue #7496: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment

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


   Closed because of no response anymore.


----------------------------------------------------------------
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] terrymanu closed issue #7496: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment

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


   


----------------------------------------------------------------
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] menghaoranss commented on issue #7496: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment

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


   @icesugar could you try with 4.1.1 version or the 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.

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

[GitHub] [shardingsphere] terrymanu closed issue #7496: java.lang.ClassCastException: org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.OrPredicateSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.ExpressionSegment

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


   


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