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

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

Jark Wu created FLINK-13648:
-------------------------------

             Summary: 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
             Fix For: 1.10.0


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
(v7.6.14#76016)