[
https://issues.apache.org/jira/browse/TAJO-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14502557#comment-14502557
]
Tajo QA commented on TAJO-1556:
-------------------------------
{color:red}*-1 overall.*{color} Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12726492/TAJO-1556.patch
against master revision release-0.9.0-rc0-268-g044fd49.
{color:green}+1 @author.{color} The patch does not contain any @author
tags.
{color:green}+1 tests included.{color} The patch appears to include 1 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:red}-1 findbugs.{color} The patch appears to introduce 18 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/750//testReport/
Findbugs warnings:
https://builds.apache.org/job/PreCommit-TAJO-Build/750//artifact/incubator-tajo/patchprocess/newPatchFindbugsWarningstajo-core.html
Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/750//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
> Attachments: TAJO-1556.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)
