You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2021/09/23 12:36:01 UTC
[jira] [Created] (IGNITE-15574) Calcite. JOIN with DISTINCT FROM
fails.
Evgeny Stanilovsky created IGNITE-15574:
-------------------------------------------
Summary: Calcite. JOIN with DISTINCT FROM fails.
Key: IGNITE-15574
URL: https://issues.apache.org/jira/browse/IGNITE-15574
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Evgeny Stanilovsky
{noformat}
statement ok
create table tbl_1 (a integer, b integer)
statement ok
insert into tbl_1 values (1,NULL),(2,3),(NULL,NULL)
statement ok
create table tbl_2 (b integer)
statement ok
insert into tbl_2 values (1),(2),(NULL)
query II
select a,tbl_2.b from tbl_1 inner join tbl_2 on (a IS NOT DISTINCT FROM tbl_2.b)
----
1 1
2 2
NULL NULL
{noformat}
failed with
{noformat}
java.lang.RuntimeException: cannot translate call IS NOT DISTINCT FROM($t0, $t1)
at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:980)
at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitCall(RexToLixTranslator.java:79)
at org.apache.calcite.rex.RexCall.accept(RexCall.java:189)
at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitLocalRef(RexToLixTranslator.java:886)
at org.apache.ignite.internal.processors.query.calcite.exec.exp.RexToLixTranslator.visitLocalRef(RexToLixTranslator.java:79)
{noformat}
{noformat}
/join/test_not_distinct_from.test[_ignore]
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)