Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Cannot Reproduce
-
None
-
None
-
None
Description
The following query should return L_RECEIPTDATE column from lineitem table, but return O_ORDERKEY from orders table.
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