https://bugs.documentfoundation.org/show_bug.cgi?id=105240
--- Comment #3 from [email protected] ---
(In reply to Gerhard Schaber from comment #2)
> Inserting NULL does not set the value to NULL in this case. Inserting NULL
> into an auto-value field makes the value increment automatically. At least
> it is like this with HSQLDB, and I think other database systems as well.
HSQLDB supports this, MariaDB also - but are you shure Firebird will support it
also?
http://www.firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html#rnfb30-ddl-identity
:
"An identity column is a column associated with an internal sequence generator.
Its value is set automatically when the column is omitted in an INSERT
statement."
You haven't omitted "ID". You have send NULL with your command - and this isn't
allowed. So an error of Firebird appears. This couldn't be our bug but an ask
for an enhancement of Firebird.
Could be my English isn't well enough for the release-notes of Firebird 3.0. So
let us wait for other statements here.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
