[
https://issues.apache.org/jira/browse/IGNITE-25077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich reassigned IGNITE-25077:
-------------------------------------------
Assignee: Iurii Gerzhedovich
> Sql. Introduced alias can not be referenced in GROUP BY and GROUPING SET
> clauses
> --------------------------------------------------------------------------------
>
> Key: IGNITE-25077
> URL: https://issues.apache.org/jira/browse/IGNITE-25077
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Assignee: Iurii Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> Prior to Calcite 1.39 the following queries worked:
> {noformat}
> # aliases can be referenced in group by <columns> clause.
> query II
> SELECT 1 AS k, SUM(i) FROM integers GROUP BY k+1 ORDER BY 2
> ----
> 1 6
> # aliases can be referenced in group by <grouping sets> clause.
> query II
> SELECT 1 AS k, SUM(i) FROM integers GROUP BY GROUPING SETS ((k+1)) ORDER BY 2
> ----
> 1 6
> {noformat}
> With calcite 1.39 they both result in an error:
> {noformat}
> Column 'K' not found in any table
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
