strongduanmu commented on issue #7547:
URL: https://github.com/apache/shardingsphere/issues/7547#issuecomment-696517409
@huangguojun00 @kimmking I have tested similar SQL on the master branch and
found that sql with parentheses have also been routed to all tables.
I think the single route result with parentheses may be a bug of version
`4.0.0-RC1`, because the `(a.bill_code = #{billCode} or 1=1)` condition is
always true, which means that the sharding column routing may be invalid, so
sql should be routed to all tables to execute.
----------------------------------------------------------------
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]
