Evgeny Stanilovsky created IGNITE-15580:
-------------------------------------------
Summary: Calcite. Correlated ANY/ALL subqueries fails.
Key: IGNITE-15580
URL: https://issues.apache.org/jira/browse/IGNITE-15580
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Evgeny Stanilovsky
{noformat}
statement ok
CREATE TABLE integers(i INTEGER)
statement ok
INSERT INTO integers VALUES (1), (2), (3), (NULL)
# correlated ANY/ALL
query T
SELECT i=ANY(SELECT i FROM integers WHERE i=i1.i) FROM integers i1 ORDER BY i;
----
0
1
1
1
{noformat}
returns erroneous result.
{noformat}
/subquery/any_all/test_correlated_any_all.test{_ignore}
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
