[
https://issues.apache.org/jira/browse/IGNITE-16701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17508088#comment-17508088
]
Aleksey Plekhanov commented on IGNITE-16701:
--------------------------------------------
[~tledkov-gridgain], thanks for the review! Merged to sql-calcite branch.
> Calcite engine. Merge join incorrectly works when there are more then two
> matched rows on the right side
> --------------------------------------------------------------------------------------------------------
>
> Key: IGNITE-16701
> URL: https://issues.apache.org/jira/browse/IGNITE-16701
> Project: Ignite
> Issue Type: Bug
> Reporter: Aleksey Plekhanov
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Reproducer:
> {code:java}
> executeSql("CREATE TABLE t1(i INT)");
> executeSql("CREATE INDEX t1_i ON t1(i)");
> executeSql("INSERT INTO t1 VALUES (0)");
> executeSql("CREATE TABLE t2(i INT)");
> executeSql("CREATE INDEX t2_i ON t2(i)");
> executeSql("INSERT INTO t2 VALUES (0), (0), (0)");
> assertQuery("SELECT /*+ DISABLE_RULE('CorrelatedNestedLoopJoin',
> 'NestedLoopJoinConverter') */ t1.i FROM t1 LEFT JOIN t2 ON t1.i =
> t2.i").returns(0).returns(0).returns(0).check();
> {code}
> Should return [0, 0, 0], but returns [0, 0].
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
