[
https://issues.apache.org/jira/browse/PHOENIX-3389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15588312#comment-15588312
]
felix edited comment on PHOENIX-3389 at 10/19/16 10:29 AM:
-----------------------------------------------------------
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 ]
Whether or not it's the same reason, thanks.
was (Author: felix_phoenix):
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)
