[ https://issues.apache.org/jira/browse/IGNITE-15583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17448582#comment-17448582 ]
Aleksey Plekhanov commented on IGNITE-15583: -------------------------------------------- Looks like it's not related to correlated queries, but related to grouping by aliases (see IGNITE-14885) > Calcite. Column not found error with correlated sub query. > ---------------------------------------------------------- > > Key: IGNITE-15583 > URL: https://issues.apache.org/jira/browse/IGNITE-15583 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Evgeny Stanilovsky > Priority: Major > Labels: calcite, calcite2-required, calcite3-required, ignite-3 > > {noformat} > 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 > {noformat} > {noformat} > 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) > {noformat} > {noformat} > /subquery/any_all/test_uncorrelated_all_subquery.test[_ignore] > {noformat} -- This message was sent by Atlassian Jira (v8.20.1#820001)