[
https://issues.apache.org/jira/browse/PHOENIX-3389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15588312#comment-15588312
]
felix commented on PHOENIX-3389:
--------------------------------
1) The following sql can work on phoenix:
[ select col from (select col as "dimCode" from dual) t ]
2) The following sql can also work on phoenix, but get "COL" column name:
[ select "dimCode" from (select col as "dimCode" from dual) t ]
Wether or not it's the same reason, thanks.
> column label error when sql having subquery
> -------------------------------------------
>
> Key: PHOENIX-3389
> URL: https://issues.apache.org/jira/browse/PHOENIX-3389
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.1
> Reporter: felix
>
> The sql [ select col as "dimCode" from dual ] can get correct metadata of
> resultset, but when having subquery like [ select col as "dimCode" from
> (select * from dual) t ] get the upper column name "DIMCODE"，not "dimCode".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
