[jira] [Commented] (TAJO-1556) "insert into select" with reordered column list does not work.

["Tajo QA (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14530022#comment-14530022 ] 

Tajo QA commented on TAJO-1556:
-------------------------------

{color:green}*+1 overall.*{color}  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12730726/TAJO-1556_add_test.patch
  against master revision release-0.9.0-rc0-281-gb6b9d46.

    {color:green}+1 @author.{color}  The patch does not contain any @author tags.

    {color:green}+1 tests included.{color}  The patch appears to include 5 new or modified test files.

    {color:green}+1 javac.{color}  The applied patch does not increase the total number of javac compiler warnings.

    {color:green}+1 javadoc.{color}  The applied patch does not increase the total number of javadoc warnings.

    {color:green}+1 checkstyle.{color}  The patch generated 0 code style errors.

    {color:green}+1 findbugs.{color}  The patch does not introduce any new Findbugs (version 2.0.3) warnings.

    {color:green}+1 release audit.{color}  The applied patch does not increase the total number of release audit warnings.

    {color:green}+1 core tests.{color}  The patch passed unit tests in tajo-catalog/tajo-catalog-common tajo-core tajo-plan.

Test results: https://builds.apache.org/job/PreCommit-TAJO-Build/770//testReport/
Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/770//console

This message is automatically generated.

> "insert into select" with reordered column list does not work.
> --------------------------------------------------------------
>
>                 Key: TAJO-1556
>                 URL: https://issues.apache.org/jira/browse/TAJO-1556
>             Project: Tajo
>          Issue Type: Bug
>          Components: compilation
>            Reporter: Yongjin Choi
>            Assignee: Yongjin Choi
>            Priority: Minor
>             Fix For: 0.11.0, 0.10.1
>
>         Attachments: TAJO-1556.patch, TAJO-1556_add_test.patch
>
>
> Using "insert into table1 (colums, ...) select " statement, users can fill part of table and tajo already had this feature.
> If columns are given in the same order as table definition, it seems to work well.
> Otherwise, the results are reversed.
> This bug can be reproduced easily as shown below (table1 is same as in http://tajo.apache.org/docs/0.8.0/getting_started/first_query.html).
> {code:sql}
> create table t1 (id int, name text, score float, type text);
> insert into t1 (type, name) select type, name from table1;
> default> select * from t1;
> id,  name,  score,  type
> -------------------------------
> ,  a,  ,  abc
> ,  b,  ,  def
> {code}
> But, the expected result is as follows.
> {code:sql}
> default> select * from t1;
> id,  name,  score,  type
> -------------------------------
> ,  abc,  ,  a
> ,  def,  ,  b
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)