[
https://issues.apache.org/jira/browse/CALCITE-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viggo Chen updated CALCITE-5732:
--------------------------------
Description:
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 = b.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.
Whats more hash join result with condition a.deptno = b.deptno and a.commission
= b.commission is same as merge join. And if there is just one condition
a.commission = b.commission, the result do not include empid = 150.
was:
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.
> 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
> Priority: Major
> 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 = b.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.
> Whats more hash join result with condition a.deptno = b.deptno and
> a.commission = b.commission is same as merge join. And if there is just one
> condition a.commission = b.commission, the result do not include empid = 150.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
