You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "pingle wang (JIRA)" <ji...@apache.org> on 2019/07/25 05:00:00 UTC
[jira] [Closed] (FLINK-13401) Flink SQL sqlUpdate sql where complex
conditional expressions do not take effect
[ https://issues.apache.org/jira/browse/FLINK-13401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pingle wang closed FLINK-13401.
-------------------------------
Resolution: Not A Bug
> 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)