[jira] [Created] (IGNITE-19402) Sql. Incorrect validation for query contains aggregates by outer query

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

Yury Gerzhedovich created IGNITE-19402:
------------------------------------------

             Summary: Sql. Incorrect validation for query contains aggregates by outer query
                 Key: IGNITE-19402
                 URL: https://issues.apache.org/jira/browse/IGNITE-19402
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Yury Gerzhedovich


Sql engine consider incorrect queries which have aggregate function for outer query in WHERE  clause. For example few queries in sql/subquery/any_all/test_correlated_any_all.test are fails:

{code:java}
SELECT (SELECT SUM(i)+SUM(i1.i) FROM integers)>ANY(SELECT i FROM integers WHERE i>MIN(i1.i)) FROM integers i1;

SELECT SUM(i)>ANY(SELECT i FROM integers WHERE i>MIN(i1.i)) FROM integers i1;

SELECT MIN(i)>ANY(SELECT i FROM integers WHERE i>MIN(i1.i)) FROM integers i1;{code}
Validation error looks as
{noformat}
 Aggregate expression is illegal in WHERE clause{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)