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)