lafaso commented on issue #8326: URL: https://github.com/apache/shardingsphere/issues/8326#issuecomment-733520397
> @lafaso The SQL also is illegal, i have run it on `MySQL 5.7` , the sql doesn't work. @jingshanglu ` SELECT COUNT(*) FROM asset WHERE 1=1 and yn = 1 AND (service_duration="" OR ISNULL(use_date) OR ISNULL(service_duration))` this is the correct sql，there is a little problem previous sql. and it works on `MySQL 5.7` ---------------------------------------------------------------- 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]
