[jira] [Assigned] (IGNITE-15566) Calcite. Join with correlated subqueries returns wrong result.

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

     [ 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)