[ https://issues.apache.org/jira/browse/FLINK-13401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16892364#comment-16892364 ]
Kurt Young commented on FLINK-13401: ------------------------------------ Could you try 1.9.0 and see if the result still not match with mysql? > 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.6.3, 1.7.2 > Reporter: pingle wang > Priority: Major > 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)