You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2021/09/23 16:37:00 UTC
[jira] [Created] (IGNITE-15580) Calcite. Correlated ANY/ALL
subqueries fails.
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)