[ASTERIXDB-2248] SQPP: Disallow the use of column aliases in GROUP BY/HAVING clauses

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Component/s: SQL - Translator SQL++
• Assignee: Dmitry Lychagin
• Reporter: Dmitry Lychagin
• Created: 16/Jan/18 20:36
• Updated: 19/Jan/18 22:22
• Resolved: 19/Jan/18 22:22

Description

Column aliases introduced by SELECT clause (AS ...) are not variables and therefore should not be referenceable from clauses that are logically processed before SELECT (such as GROUP BY and HAVING). We still allow column aliases to be referenced from ORDER BY clauses.