[ https://issues.apache.org/jira/browse/IGNITE-15574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Plekhanov updated IGNITE-15574: --------------------------------------- Labels: calcite calcite3-required ignite-3 (was: calcite calcite2-required calcite3-required ignite-3) > 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 > Assignee: Aleksey Plekhanov > Priority: Major > Labels: calcite, calcite3-required, ignite-3 > Fix For: 2.15 > > Time Spent: 20m > Remaining Estimate: 0h > > {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.20.10#820010)