[TAJO-997] Shifted columns after ALTER TABLE ADD COLUMN new_column

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 0.9.0

Environment

Tajo version: 0.9.0-SNAPSHOT
Compiled at 2014-07-27T17:32Z
Java version: 1.7.0_51

• Assignee: Hyunsik Choi
• Reporter: Christian Schwabe
• Due: 06/Aug/14
• Created: 06/Aug/14 10:57
• Updated: 15/Oct/15 04:17
• Resolved: 15/Oct/15 04:17

Description

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.

Issue Links

• relates to: TAJO-696 Implement ALTER TABLE ADD COLUMN