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/27 07:13:00 UTC

[jira] [Created] (IGNITE-15605) Calcite. Unexpected result with aggregate inside subquery.

Evgeny Stanilovsky created IGNITE-15605:
-------------------------------------------

             Summary: Calcite. Unexpected result with aggregate inside subquery.
                 Key: IGNITE-15605
                 URL: https://issues.apache.org/jira/browse/IGNITE-15605
             Project: Ignite
          Issue Type: Bug
          Components: sql
            Reporter: Evgeny Stanilovsky



{noformat}
statement ok
CREATE TABLE integers(i INTEGER)

statement ok
INSERT INTO integers VALUES (1), (2), (3), (NULL)

query R
SELECT (SELECT SUM(i1.i)) FROM integers i1;
----
6.000000
{noformat}


{noformat}
/subquery/scalar/test_correlated_aggregate_subquery.test_ignore
{noformat}





--
This message was sent by Atlassian Jira
(v8.3.4#803005)