<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - SDBC-mismatch on alter field-properties in embedded Firebird database" href="https://bugs.documentfoundation.org/show_bug.cgi?id=112491#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - SDBC-mismatch on alter field-properties in embedded Firebird database" href="https://bugs.documentfoundation.org/show_bug.cgi?id=112491">bug 112491</a> from <a class="email" href="mailto:iplaw67@tuta.io" title="Alex Thurgood <iplaw67@tuta.io>"> Alex Thurgood</a> <pre>@mhonline : So your description is rather lacking in detailed information as you don't say how you created the table, or what additional attributes you have given to the different fields that one can see in the screenshot. I have tried to reproduce using the default behaviour of LibreOffice using the manual way to create a new table in the GUI (not using the table creation wizard). I took the defaults as suggested in the UI. For the INT column, I defined it as primary key with no auto(increment)value. Defined the remaining fields with the defaults provided by the LO UI, then saved. Closed the ODB file, then closed LibreOffice. Re-opened LibreOffice, then reloaded the ODB file, opened the table for editing and clicked on Autovalue = YES after selecting the priID field. When I attempt to resave the table, I get the following error message : "The column "priID" could not be changed. Should the column instead be deleted and the new format appended ?" Clicking on the "More" button shows the following error message: SQL Status: IM001 Changing autoincrement property of existing column is not supported If I then click on "Yes" in answer to the question to delete/new append, I see the following : Error while saving the table design firebird_sdbc error: *unsuccessful metadata update *ALTER TABLE testprimkey failed *SQL error code = -607 *Invalid command *Specified domain or source column SQL_LONG does not exist caused by ALTER TABLE "testprimkey" ADD "priID" SQL_LONG NOT NULL This isn't the same error message as you have posted in your screenshot. If you have done anything different than what I have described, please provide complete detailed step-by-step instructions here. Tested on Version: 5.4.1.2 Build ID: ea7cb86e6eeb2bf3a5af73a8f7777ac570321527 CPU threads: 4; OS: Mac OS X 10.12.6; UI render: default; Locale: fr-FR (fr_FR.UTF-8); Calc: group</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>