[
https://issues.apache.org/jira/browse/HIVE-11235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14627822#comment-14627822
]
Ryu Kobayashi commented on HIVE-11235:
--------------------------------------
[~ychena] Thank you for confirm. Certainly it was no problem in the master
branch. Do you know this fix ticket?
> If the real table name and the CTE is the same, we can not see the CTE
> ----------------------------------------------------------------------
>
> Key: HIVE-11235
> URL: https://issues.apache.org/jira/browse/HIVE-11235
> Project: Hive
> Issue Type: Bug
> Reporter: Ryu Kobayashi
>
> If the real table name and the CTE is the same, we can not see the CTE.
> {code}
> create table foo(id int);
> insert into foo values(1);
> hive> with foo as (
> > select 10 as id)
> > select id from foo;
> OK
> 1
> {code}
> In the case of PostgreSQL, 10 is returned.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
