[
https://issues.apache.org/jira/browse/FLINK-10847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17337070#comment-17337070
]
Leonard Xu edited comment on FLINK-10847 at 4/30/21, 4:39 AM:
--------------------------------------------------------------
{noformat}
Flink SQL> select 1 IS NOT DISTINCT FROM 2;
+----+--------+
| op | EXPR$0 |
+----+--------+
| +I | false |
+----+--------+
Received a total of 1 row
Flink SQL> select 1 IS NOT DISTINCT FROM 1;
+----+--------+
| op | EXPR$0 |
+----+--------+
| +I | true |
+----+--------+
Received a total of 1 row
{noformat}
was (Author: leonard xu):
{noformat}
Flink SQL> select 1 IS DISTINCT FROM 2;
+----+--------+
| op | EXPR$0 |
+----+--------+
| +I | true |
+----+--------+
Received a total of 1 row
Flink SQL> select 1 IS NOT DISTINCT FROM 2;
+----+--------+
| op | EXPR$0 |
+----+--------+
| +I | false |
+----+--------+
Received a total of 1 row{noformat}
> Add support for IS NOT DISTINCT FROM in code generator
> ------------------------------------------------------
>
> Key: FLINK-10847
> URL: https://issues.apache.org/jira/browse/FLINK-10847
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Timo Walther
> Priority: Major
> Labels: auto-unassigned
>
> It seems that sometimes {{IS NOT DISTINCT FROM}} is not rewritten by Calcite,
> thus we should have built-in support for it and add more tests. It is already
> officially documented.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
