https://bugs.documentfoundation.org/show_bug.cgi?id=105240
Bug ID: 105240
Summary: Firebird: Insert NULL for auto value fails
Product: LibreOffice
Version: 5.3.0.0.beta2
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
The following sequence of SQL commands on a fresh FirebirdSQL file fails:
CREATE TABLE "Lehrgangsliste"("ID" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) PRIMARY KEY,"Tarifgruppe" INTEGER NOT
NULL,"Pruefungsgruppe" INTEGER,"MitgliedsID" VARCHAR(10),"DatumsID" DATE NOT
NULL,"Vorname" VARCHAR(50) NOT NULL,"Nachname" VARCHAR(50) NOT NULL,"Verein"
INTEGER NOT NULL,"Grad" INTEGER)
INSERT INTO "Lehrgangsliste" VALUES ( NULL, 3, NULL, 'YW045', '2016-10-15',
'First name', 'Last name', 701, 12 )
It returns the following error:
1: firebird_sdbc error:
*validation error for column "Lehrgangsliste"."ID", value "*** null ***"
caused by
'INSERT INTO "Lehrgangsliste" VALUES ( NULL, 3, NULL, 'YW045', '2016-10-15',
'First name', 'Last name', 701, 12 )'
This makes it impossible to insert rows into a table while having the ID column
being auto generated.
I consider this a very common use case.
See also bug #104942 for other migration issues to FirebirdSQL.
--
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
