You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "LakeShen (Jira)" <ji...@apache.org> on 2023/10/31 14:59:00 UTC

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

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)