Hyoungjun Kim created TAJO-863:
----------------------------------
Summary: Column order mismatched in the JOIN query with asterisk
selection.
Key: TAJO-863
URL: https://issues.apache.org/jira/browse/TAJO-863
Project: Tajo
Issue Type: Bug
Reporter: Hyoungjun Kim
Assignee: Hyoungjun Kim
Priority: Minor
In the case of the following query, Columns of a nation table should be
preceded, but customer is preceded.
{code:sql}
select *
from nation b
join customer a on b.n_nationkey = a.c_nationkey
{code}
Query's result is
{noformat}
c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment,n_nationkey,n_name,n_regionkey,n_comment
-------------------------------
3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE,
deposits eat slyly ironic, even instructions. express foxes detect slyly.
blithely even accounts abov,1,ARGENTINA,1,al foxes promise slyly according to
the regular accounts. bold requests alon
5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n
accounts will have to unwind. foxes cajole accor,3,CANADA,1,eas hang ironic,
silent packages. slyly regular packages are furiously over the tithes. fluffily
bold
4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests.
final, regular ideas sleep final accou,4,EGYPT,4,y above the carefully unusual
theodolites. final dugouts are quickly across the furiously regular d
{noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
