[
https://issues.apache.org/jira/browse/ASTERIXDB-2248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin updated ASTERIXDB-2248:
---------------------------------------
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. (was: Column aliases
introduced by SELECT clause (AS ...) are not variables and therefore should not
be referenceable from other clauses. )
> SQPP: Disallow the use of column aliases in GROUP BY/HAVING clauses
> --------------------------------------------------------------------
>
> Key: ASTERIXDB-2248
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2248
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: SQL - Translator SQL++
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Minor
>
> 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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
