Apache OpenOffice (AOO) Bugzilla – Issue 122084
Can't insert new field/column in Table Design BEFORE/AFTER existing one
Last modified: 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.