[
https://issues.apache.org/jira/browse/IGNITE-15566?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17481116#comment-17481116
]
Aleksey Plekhanov commented on IGNITE-15566:
--------------------------------------------
[~zstan], [~korlov] thanks for the review! Merged to sql-calcite branch.
> Calcite. Join with correlated subqueries returns wrong result.
> --------------------------------------------------------------
>
> Key: IGNITE-15566
> URL: https://issues.apache.org/jira/browse/IGNITE-15566
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Evgeny Stanilovsky
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required, ignite-3
> Time Spent: 40m
> Remaining Estimate: 0h
>
> Example from ScriptRunner :
> {noformat}
> query IIT
> SELECT * FROM test WHERE EXISTS(SELECT * FROM test2 WHERE test.a=test2.a AND
> test.b<>test2.c) AND NOT EXISTS(SELECT * FROM test2 WHERE test.a=test2.a AND
> test.b<test2.c);
> ----
> 12 2 b
> query IIT
> SELECT * FROM test WHERE NOT EXISTS(SELECT * FROM test2 WHERE test.a=test2.a
> AND test.b<test2.c AND test2.a=12) AND NOT EXISTS(SELECT * FROM test2 WHERE
> test.a=test2.a AND test.b>test2.c AND test2.a=12) ORDER BY a;
> ----
> 11 1 a
> 13 3 c
> {noformat}
> {noformat}
> /join/inner/test_eq_ineq_join.test[_ignore]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
