cheese8 commented on issue #13017: URL: https://github.com/apache/shardingsphere/issues/13017#issuecomment-942032123
Yes, as the actual SQL shows that the predicate column would not be rewrited when the predicate right value null or not null. You can change this column into not null and try `select * from user where mobile_cipher='XXX' and idcard='';` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
