You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Viggo Chen (Jira)" <ji...@apache.org> on 2023/05/30 10:03:00 UTC
[jira] [Created] (CALCITE-5732) EnemerableJoin should not return rows match condition null = null
Viggo Chen created CALCITE-5732:
-----------------------------------
Summary: EnemerableJoin should not return rows match condition null = null
Key: CALCITE-5732
URL: https://issues.apache.org/jira/browse/CALCITE-5732
Project: Calcite
Issue Type: Bug
Components: linq4j
Reporter: Viggo Chen
Fix For: 1.35.0
In `EnumerableJoinTest#testMergeJoinWithCompositeKeyAndNullValues`, the query is like
{code:java}
select
emps.empid
from
emps a join emps b
on a.deptno = b.deptno
and a.commission = commission;{code}
and the data is like
{code:java}
INSERT INTO "emps" VALUES (100, 10, 'Bill', 10000, 1000);
INSERT INTO "emps" VALUES (200, 20, 'Eric', 8000, 500);
INSERT INTO "emps" VALUES (150, 10, 'Sebastian', 7000, null);
INSERT INTO "emps" VALUES (110, 10, 'Theodore', 11500, 250); {code}
And row with empid = 150 is in expected result. Is this the expected result of join with null condition.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)