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

["pingle wang (JIRA)" <ji...@apache.org>]

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)