[
https://issues.apache.org/jira/browse/TAJO-863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14016364#comment-14016364
]
ASF GitHub Bot commented on TAJO-863:
-------------------------------------
GitHub user babokim opened a pull request:
https://github.com/apache/tajo/pull/31
TAJO-863: Column order mismatched in the JOIN query with asterisk selection
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/babokim/tajo TAJO-863
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/31.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #31
----
commit 3faa5db3623aa37ca5a56537df5ec8817cab3cc8
Author: 김형준 <[email protected]>
Date: 2014-06-03T10:09:47Z
TAJO-863: Column order mismatched in the JOIN query with asterisk selection.
----
> 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)
