[Libreoffice-bugs] [Bug 112491] SDBC-mismatch on alter field-properties in embedded Firebird database when editing primary key

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112491

--- Comment #9 from Drew Jensen <drewjensen.inbox at gmail.com> ---
How to reproduce the bug.

1 Download the attached ODB file.
2 Start Libreoffice if it is not running.
3 Open the file you downloaded in step 1
4 Go to the Tables section in the Base main window.
5 Select the table EmployeesTasks
6 Right click the mouse, on the table, and select edit.
7 When the table editor opens, select the primary key field 'ID'
8 Change the Auto Increment control from No to Yes
9 Click save changes
10 An error message informs you that the column must be dropped and added to
the end of the table. Answer yes.

What actually happens:
An error message box opens again, during the final step of the change (adding
the column to the end of the table) with a bad SQL statement. The command is
trying to use a string constant of a data type descriptor in place of the
actual data type name.
Clear the error message.
The table editor continues to show that a column ID exists, but it no longer
does in the actual Table in the schema. 
Close the table editor.
You are asked if you want to save the changes, if you say yes a new error
message is displayed with the word 'GENERATED' in it - this is because Base
used the table descriptor stored in Base, not from the schema, and is trying to
alter a column that no longer exists. 
Clear that and close the table editor again, this time do not save the saves
when prompted.
Open the table itself and you will see that the ID field is gone.
Close the file, but do not save it and it is ready to test all over again.

Expected results:
It works. The ID field is moved to the end of the table, type integer and Auto
Increment is true.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180525/adfd3154/attachment.html>