https://bugs.documentfoundation.org/show_bug.cgi?id=112491
--- Comment #20 from Robert Großkopf <[email protected]> --- Firebird 3 will only allow to add a incremented field to a table without content. It couldn't change a field to an incremented field. « An identity column cannot be altered to become a regular column. The reverse is also true. Firebird 4 will introduce the option to alter an identity column to a regular column. Identity columns are implicitly NOT NULL (non-nullable).» See: https://firebirdsql.org/file/documentation/html/en/refdocs/fblangref30/firebird-30-language-reference.html#fblangref30-ddl-tbl-create ALTER TABLE "Table1" ADD "ID" INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY; This will add a field "ID" to "Table1" as autovalue, if "Table1" has no content. This is possible through Tools → SQL. This isn't possible in GUI. If I want to change a field in GUI to autovalue in a table without content I will get firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token unknown - line 1, column 48 *GENERATED caused by 'isc_dsql_prepare' /home/buildslave/source/libo-core/connectivity/source/drivers/firebird/Util.cxx:68 Seems the code isn't defined as a known code for Firebird in LO. Tested with LO 7.3.0.3 on OpenSUSE 15.3 64bit rpm Linux. -- You are receiving this mail because: You are the assignee for the bug.
