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)