[IGNITE-15583] Calcite. Column not found error with correlated sub query.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: calcite calcite2-required
• Epic Link: Improve SQL quality in AI3. Part1
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 24/Sep/21 06:45
• Updated: 10/Jul/24 06:21

Description

statement ok
CREATE TABLE integers(i INTEGER)

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

query IR
SELECT (SELECT MAX(i) FROM integers) AS k, SUM(i) FROM integers GROUP BY k;
----
3	6.000000

org.apache.calcite.runtime.CalciteContextException: At line 1, column 74: Column 'K' not found in any table

	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:506)
	at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:917)
	at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:902)

/subquery/any_all/test_uncorrelated_all_subquery.test[_ignore]

Issue Links

• is part of: IGNITE-12248 Apache Calcite based query execution engine
• is related to: IGNITE-14885 Calcite engine. Allow grouping by alias or ordinal
• relates to: IGNITE-18212 GROUP BY with alias causes column not found in any table error