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)
