You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2014/06/05 23:36:01 UTC

[jira] [Resolved] (TAJO-863) Column order mismatched in the JOIN query with asterisk selection.

     [ https://issues.apache.org/jira/browse/TAJO-863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyunsik Choi resolved TAJO-863.
-------------------------------

       Resolution: Fixed
    Fix Version/s: 0.9.0

committed it to master branch. Thank you for your contribution!

> 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
>             Fix For: 0.9.0
>
>
> 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)