[FLINK-13401] Flink SQL sqlUpdate sql where complex conditional expressions do not take effect

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.6.3, 1.7.2
• Fix Version/s: 1.9.0
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: pingle wang
• Created: 24/Jul/19 09:00
• Updated: 25/Jul/19 04:59
• Resolved: 25/Jul/19 04:59

Description

flink execute sql :

 

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')

the result is 20, but in mysql and hive, this result is 17.

 

The key condition is :

 

and (event_type IS NULL OR event_type <> '2'AND event_type <> '10')

and event_type is varchar, flink is string data type.

 

mysql has the key condition sql result is:

mysql no the key condition sql result is: