[jira] [Updated] (FLINK-13648) Support "IS NOT DISTINCT FROM" operator in lookup join

["Jark Wu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-13648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jark Wu updated FLINK-13648:
----------------------------
    Fix Version/s:     (was: 1.10.0)

> Support "IS NOT DISTINCT FROM" operator in lookup join
> ------------------------------------------------------
>
>                 Key: FLINK-13648
>                 URL: https://issues.apache.org/jira/browse/FLINK-13648
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table SQL / Planner
>            Reporter: Jark Wu
>            Assignee: Jing Zhang
>            Priority: Major
>
> Example1:
> {code:java}
> `SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id = D.id OR (T.id is null and D.id is null)`
> {code}
> Example2:
> {code:java}
> "SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id IS NOT  DISTINCT FROM  D.id"
> {code}
> Now run the above sql in Blink planner, the results are not expected.Because LookupJoin does not handle the case correctly.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)