Issue 122084 - Can't insert new field/column in Table Design BEFORE/AFTER existing one
Summary: Can't insert new field/column in Table Design BEFORE/AFTER existing one
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.1
Hardware: PC Windows 7
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-04-18 06:14 UTC by franzec
Modified: 2013-04-18 06:14 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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.