[FLINK-13509] Forbidden `IS NOT DISTINCT FROM `(or an expanded version) in LookupJoin

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.9.0
• Component/s: Table SQL / Planner
• Assignee: Jing Zhang
• Reporter: Jing Zhang
• Created: 31/Jul/19 10:10
• Updated: 27/Jan/22 17:43
• Resolved: 08/Aug/19 09:04

Description

Example1:

`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)`

Example2:

"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"

In 1.9 version, we can simply throw exception in compile phase for the above sql and add proper support in FLINK-13648.

Issue Links

• is related to: FLINK-13648 Support "IS NOT DISTINCT FROM" operator in lookup join