[jira] [Assigned] (IGNITE-18670) Sql. It is possible to reference aliases in GROUP BY clause.

["Maksim Zhuravkov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-18670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maksim Zhuravkov reassigned IGNITE-18670:
-----------------------------------------

    Assignee: Maksim Zhuravkov

> Sql. It is possible to reference aliases in GROUP BY clause.
> ------------------------------------------------------------
>
>                 Key: IGNITE-18670
>                 URL: https://issues.apache.org/jira/browse/IGNITE-18670
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Maksim Zhuravkov
>            Assignee: Maksim Zhuravkov
>            Priority: Minor
>              Labels: calcite2-required, calcite3-required, ignite-3
>             Fix For: 3.0.0-beta2
>
>
> Currently we expect the query bellow to fail
> {code:java}
> SELECT 1 AS k, SUM(i) FROM integers GROUP BY k+1 ORDER BY 2;
> {code}
> But in https://issues.apache.org/jira/browse/IGNITE-18212 we decided that ignite's dialect of the SQL supports this behaviour.
> Update test_group_by.test and mark the query as OK.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)