You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Stamatis Zampetakis (Jira)" <ji...@apache.org> on 2026/05/28 12:11: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 ]

Stamatis Zampetakis updated CALCITE-6082:
-----------------------------------------
    Fix Version/s: 1.39.0

> 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
>             Fix For: 1.39.0
>
>         Attachments: image-2023-10-31-23-00-16-465.png, image-2023-11-01-12-16-51-057.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 exception stack is :
> {code:java}
> org.apache.calcite.runtime.CalciteContextException: From line 1, column 18 to line 1, column 25: Aggregate expression is illegal in GROUP BY clause
> 	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)	at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)	at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:945)	at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:930)	at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:5435)	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateGroupClause(SqlValidatorImpl.java:4436)	at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3765)	at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:61)	at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:88) {code}
> The postgresql could execute success with above sql.
> !image-2023-10-31-23-00-16-465.png|width=651,height=164!
>  



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