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)
