[jira] [Created] (TAJO-997) Shifted columns after ALTER TABLE ADD COLUMN new_column

["Christian Schwabe (JIRA)" <ji...@apache.org>]

Christian Schwabe created TAJO-997:
--------------------------------------

             Summary: Shifted columns after ALTER TABLE ADD COLUMN new_column
                 Key: TAJO-997
                 URL: https://issues.apache.org/jira/browse/TAJO-997
             Project: Tajo
          Issue Type: Bug
    Affects Versions: 0.9.0
         Environment: Tajo version: 0.9.0-SNAPSHOT
Compiled at 2014-07-27T17:32Z
Java version: 1.7.0_51
            Reporter: Christian Schwabe
            Assignee: Hyunsik Choi


As a source for sample data sets serve me in this case, the following source: http://tajo.apache.org/docs/0.8.0/getting_started/first_query.html#first-query-execution

Below i describe my steps to reprodduce:

>>First Step (original data set):<<
default> SELECT * FROM table1;
id,  name,  score,  type
-------------------------------
1,  abc,  1.1,  a
2,  def,  2.3,  b
3,  ghi,  3.4,  c
4,  jkl,  4.5,  d
5,  mno,  5.6,  e
(5 rows, 0.665 sec, 59 B selected)

>>Second step (ALTER TABLE):<<
default> ALTER TABLE table1 ADD COLUMN new_column text;
OK

>>Third step (show new structure):<<
default> SELECT * FROM table1;
id,  new_column,  name,  score,  type
-------------------------------
1,  abc,  1.1,  ,  
2,  def,  2.3,  ,  
3,  ghi,  3.4,  ,  
4,  jkl,  4.5,  ,  
5,  mno,  5.6,  ,  
(5 rows, 0.042 sec, 59 B selected)

Logs:
014-08-06 12:43:57,129 INFO org.apache.tajo.master.GlobalEngine: Query: ALTER TABLE table1 ADD COLUMN new_column text
2014-08-06 12:43:57,139 INFO org.apache.tajo.master.GlobalEngine: Non Optimized Query: 

-----------------------------
Query Block Graph
-----------------------------
|-#ROOT
-----------------------------
Optimization Log:
-----------------------------

No Exception was thrown.

Kind regards,
Chris.


P.S.: Sorry for that. It's my first time to report an issue. I hope I have made all the necessary information and have forgotten nothing.



--
This message was sent by Atlassian JIRA
(v6.2#6252)