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

Posted to dev@calcite.apache.org by "Toni Mueller (Jira)" <ji...@apache.org> on 2021/08/18 12:03:00 UTC

[jira] [Created] (CALCITE-4746) Pivots with pivotAgg without alias fail

Toni Mueller created CALCITE-4746:
-------------------------------------

             Summary: Pivots with pivotAgg without alias fail
                 Key: CALCITE-4746
                 URL: https://issues.apache.org/jira/browse/CALCITE-4746
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.27.0
            Reporter: Toni Mueller


The following works:

{code:sql}
SELECT * FROM STUDENTS PIVOT(SUM(AGE) AS sum_age FOR PROFESSION IN ('BIOLOGY', 'CHEMISTRY'))
{code}

The following doesn't work:
{code:sql}
SELECT * FROM STUDENTS PIVOT(SUM(AGE) FOR PROFESSION IN ('BIOLOGY', 'CHEMISTRY'))
{code}
 
According to the Language Definition both should work:
https://calcite.apache.org/docs/reference.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)