[
https://issues.apache.org/jira/browse/IGNITE-15580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Mashenkov updated IGNITE-15580:
--------------------------------------
Labels: calcite calcite2-required ignite-3 (was: calcite calcite2-required
calcite3-required ignite-3)
> 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
> Assignee: Yury Gerzhedovich
> Priority: Major
> Labels: calcite, calcite2-required, ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {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.20.10#820010)
