[IGNITE-18666] Sql. Subqueries with invalid aggregates in subqueries are not rejected

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: calcite2-required calcite3-required ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Maksim Zhuravkov
• Created: 30/Jan/23 12:16
• Updated: 30/Jan/23 12:16

Description

The following queries are expected to fail but they return some results:

# this will fail, because "i" is not an aggregate but the SUM(i1.i) turns this query into an aggregate
skipif ignite3
statement error
SELECT i, (SELECT SUM(i1.i)) FROM integers i1;

# PG: ERROR:  column "i1.i" must appear in the GROUP BY clause or be used in an aggregate function
skipif ignite3
statement error
SELECT i+1, (SELECT SUM(i1.i)) FROM integers i1;