Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
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).
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
But, the expected result is as follows.
default> select * from t1; id, name, score, type ------------------------------- , abc, , a , def, , b