[
https://issues.apache.org/jira/browse/CALCITE-6082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhen Chen resolved CALCITE-6082.
--------------------------------
Resolution: Fixed
Fixed via CALCITE-4512
> 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,
> 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)
