[ https://issues.apache.org/jira/browse/IGNITE-15566?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksey Plekhanov reassigned IGNITE-15566: ------------------------------------------ Assignee: Aleksey Plekhanov > 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 > > 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)