Jing Zhang created FLINK-13509: ---------------------------------- Summary: Support `is not distinct from ` and similar syntax in LookupJoin Key: FLINK-13509 URL: https://issues.apache.org/jira/browse/FLINK-13509 Project: Flink Issue Type: Task Components: Table SQL / Planner Affects Versions: 1.10.0 Reporter: 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 error.Because LookupJoin does not handle the case correctly. Here is plan: In 1.9 version, simply throw exception in compile phase for the above sql. Support the feature in 1.10 version. -- This message was sent by Atlassian JIRA (v7.6.14#76016)