Issue 122084

Summary: Can't insert new field/column in Table Design BEFORE/AFTER existing one
Product: Base Reporter: franzec <franz.eckl>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Major    
Priority: P3 CC: alex.thurgood, arielch, issues
Version: 3.4.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description franzec 2013-04-18 06:14:03 UTC
+++ This bug was initially created as a clone of Bug #43528 +++

- Base internal DB -

Open db document ODB. Click on the Tables button. Select the table in the table
tree view. RMB click and choose Edit Table.

Try to insert a new field into the table, of tinyint type, between the first
field (int, autoincrement) and second field (varchar), using the RMB click on
the leftmost column of the edit table view, where you can also delete and set
the primary key and delete the field.

The new field is systematically added to the end of the field list, and will
also appear at that position when the table is opened for editing of the data.

This means that the command "AFTER", "FIRST", or "LAST" in the SQL ALTER TABLE
syntax are either not included in the function or are dropped on execution or
are ignored. 

Reproducible every time.