[IGNITE-15580] Calcite. Correlated ANY/ALL subqueries fails.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite calcite2-required ignite-3
• Assignee: Iurii Gerzhedovich
• Reporter: Evgeny Stanilovsky
• Created: 23/Sep/21 16:36
• Updated: 04/Sep/24 16:19
• Resolved: 03/May/23 07:38

Description

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

returns erroneous result.

/subquery/any_all/test_correlated_any_all.test{_ignore}

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• links to: GitHub Pull Request #2012
• links to: PR #2012