You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Maksim Zhuravkov (Jira)" <ji...@apache.org> on 2023/01/30 12:48:00 UTC

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

Maksim Zhuravkov created IGNITE-18670:
-----------------------------------------

             Summary: 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
             Fix For: 3.0.0-beta2


The following query is considered invalid by some SQL frontends since they decided that it is not legal to reference aliases in GROUP BY clause. 
We should decide whether to reject such query or not as of now it works.

{code:java}
SELECT 1 AS k, SUM(i) FROM integers GROUP BY k+1 ORDER BY 2;
{code}




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