You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2017/03/04 00:23:45 UTC

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

    [ https://issues.apache.org/jira/browse/PHOENIX-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15895305#comment-15895305 ] 

James Taylor commented on PHOENIX-3712:
---------------------------------------

Changing those test cases is fine IMHO.

> 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
>
> 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)