[
https://issues.apache.org/jira/browse/FLINK-13509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu resolved FLINK-13509.
-----------------------------
Resolution: Fixed
[table-planner-blink] Forbidden `IS NOT DISTINCT FROM `(or an expanded version)
in LookupJoin.
- master: 78d1e68ab120e2fecb931e6d9ea1ee8bef247cde
- 1.9: 7838436fc3b3aa653ecb33fc965116110b1f835e
> Forbidden `IS NOT DISTINCT FROM `(or an expanded version) 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
> Assignee: Jing Zhang
> Priority: Minor
> Fix For: 1.9.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}
> In 1.9 version, we can simply throw exception in compile phase for the above
> sql and add proper support in FLINK-13648.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
