[
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)
