[PHOENIX-3712] Column alias can't be resolved in GROUP BY clause

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Wei Xue
• Created: 04/Mar/17 00:17
• Updated: 10/May/17 08:58
• Resolved: 10/May/17 08:58

Description

There are quite a few test cases written like:
select v1 - 1 as v, sum(v2) from t group by v in Phoenix test suite, and calcite does not allow using aliases defined in SELECT list to be referred by GROUP BY clause (ok for ORDER BY though), shall we change those test cases? FYI, julianhyde, jamestaylor, rajeshbabu, kliew

Issue Links

• depends upon: CALCITE-1306 Allow GROUP BY and HAVING to reference SELECT expressions by ordinal and alias