pingle wang created FLINK-13401: ----------------------------------- Summary: Flink SQL sqlUpdate sql where complex conditional expressions do not take effect Key: FLINK-13401 URL: https://issues.apache.org/jira/browse/FLINK-13401 Project: Flink Issue Type: Improvement Components: Table SQL / API Affects Versions: 1.7.2, 1.6.3 Reporter: pingle wang Fix For: 1.9.0 Attachments: image-2019-07-24-16-40-36-070.png, image-2019-07-24-16-45-20-682.png, image-2019-07-24-17-00-36-079.png
flink execute sql : {code:java} select count(ad_action) as cnt from ad_sdk_android where ad_position_id = '100055' and ad_action = 'click' and (event_type IS NULL OR event_type <> '2'AND event_type <> '10') {code} the result is 20, but in mysql and hive, this result is 17. !image-2019-07-24-17-00-36-079.png! The key condition is : {code:java} and (event_type IS NULL OR event_type <> '2'AND event_type <> '10'){code} and event_type is varchar, flink is string data type. mysql has the key condition sql result is: !image-2019-07-24-16-40-36-070.png! mysql no the key condition sql result is: !image-2019-07-24-16-45-20-682.png! -- This message was sent by Atlassian JIRA (v7.6.14#76016)