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

Tue, 31 Oct 2023 07:59:05 -0700 

LakeShen created CALCITE-6082:
---------------------------------

             Summary: 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


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)

Reply via email to