[
https://issues.apache.org/jira/browse/IGNITE-19402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-19402:
----------------------------------------
Epic Link: IGNITE-22700
> 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: Iurii Gerzhedovich
> Priority: Major
> Labels: calcite2-required, ignite-3
>
> 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)
