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:
[email protected]
