[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

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |serval2412 at yahoo.fr

--- Comment #17 from Julien Nabet <serval2412 at yahoo.fr> ---
I think it's not LO related but more Firebird related.

After having removed "ID" column + refresh tables, I tried these on SQL:
ALTER TABLE "EmployeesTasks" ADD "ID" INTEGER NOT NULL
or
ALTER TABLE "EmployeesTasks" ADD "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY
both indicated on console:
warn:connectivity.firebird:63575:63575:connectivity/source/drivers/firebird/Util.cxx:57:
firebird_sdbc error:
*unsuccessful metadata update
*Cannot make field ID of table EmployeesTasks NOT NULL because there are NULLs
present


https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html
indicates:
"Identity columns are implicitly NOT NULL (non-nullable)."


http://tracker.firebirdsql.org/browse/CORE-5019 indicates

Dmitry Yemanov added a comment - 17/Nov/15 10:52 AM
"... Adding NOT NULL columns over a populated table is not allowed anymore,
because such operations violate the NOT NULL constraint..."

Dmitry Yemanov is one of the author of Firebird (see
https://firebirdsql.org/en/news/interview-with-dmitry-yemanov-firebird-core-developer/)

-- 
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/20201101/9b58a909/attachment.htm>