Hyoungjun Kim created TAJO-831:
----------------------------------

             Summary: Project wrong column in the case of having same alias in 
subquery.
                 Key: TAJO-831
                 URL: https://issues.apache.org/jira/browse/TAJO-831
             Project: Tajo
          Issue Type: Bug
            Reporter: Hyoungjun Kim
            Priority: Minor


The following query should return L_RECEIPTDATE column from lineitem table, but 
return O_ORDERKEY from orders table.

{code:sql}
select
    a.L_RECEIPTDATE as col1
from
    (select * from lineitem) a
join
    (select O_ORDERKEY col1 from orders) b
on
    a.L_ORDERKEY = b.col1
{code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to