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)