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

Posted to issues@calcite.apache.org by "LakeShen (Jira)" <ji...@apache.org> on 2023/10/31 15:01:00 UTC

[jira] [Updated] (CALCITE-6082) Aggregate expression is illegal in GROUP BY clause when column's alias is same as column name

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

LakeShen updated CALCITE-6082:
------------------------------
    Attachment: image-2023-10-31-23-00-16-465.png

> Aggregate expression is illegal in GROUP BY clause when column's alias is same as column name
> ---------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-6082
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6082
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: LakeShen
>            Priority: Major
>         Attachments: image-2023-10-31-23-00-16-465.png
>
>
> The sql is :
> {code:java}
> SELECT max(a+b), min(a+b) AS a FROM (values (1,2),(3,2),(1,5)) t(a,b) GROUP BY a ORDER BY max(t.a+t.b) {code}
> The postgresql could execute success with above sql.



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