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

["Rajeshbabu Chintaguntla (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajeshbabu Chintaguntla updated PHOENIX-3712:
---------------------------------------------
    Attachment: PHOENIX-3712.patch

Now CALCITE-1306 is committed in calcite so making related changes in Phoenix support aliases in Phoenix. Going to commit it.

> Column alias can't be resolved in GROUP BY clause
> -------------------------------------------------
>
>                 Key: PHOENIX-3712
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3712
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Maryann Xue
>            Assignee: Maryann Xue
>              Labels: calcite
>         Attachments: PHOENIX-3712.patch
>
>
> 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]



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)