https://bugs.freedesktop.org/show_bug.cgi?id=45947
Bug #: 45947
Summary: EDITING: Autoincrement in external HSQLDB could not be
created in GUI - wrong SQL-Code
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: rob...@familiegrosskopf.de
When creating autoincrement-values in external HSQLDB you have to add
"GENERATED BY DEFAULT AS IDENTITY(START WITH 0)" in the advanced features of the
database.
When creating the table with autoincrement the GUI produces the Code "CREATE
TABLE "table" (ID (INTEGER NOT NULL GENERATED ....)). "NOT NULL" is the wrong
code
in this command.
In earlier versions of OpenOffice (3.1.1) you could solve the by disabling the
primary key in the GUI. Now disabling the primary key disables also the
autoincrement-value, which normally is OK. But with the wrong code in the GUI
its a problem ...
You could only create a table with autoincrement-value by creating a table with
primarykey and without autoincrement in the GUI and then changing it in SQL
directly with
ALTER TABLE "Tabelle" ALTER COLUMN "ID" INT GENERATED BY DEFAULT AS
IDENTITY(START WITH 0)
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
