https://bugs.freedesktop.org/show_bug.cgi?id=59464
rob...@familiegrosskopf.de changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |DUPLICATE
--- Comment #1 from rob...@familiegrosskopf.de ---
It's an old problem since the beginning of LO. I have reported this at
https://bugs.freedesktop.org/show_bug.cgi?id=45947
The SQL-Code, which is produced by LO, is wrong, when you set the right code to
Edit → Database → Advanced Settings → Generated Values
The auto-increment statement must be
GENERATED BY DEFAULT AS IDENTITY(START WITH 0)
but LO will produce "NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 0)"
and fails.
You could only add a automatic generated field by changing the table you have
created without increment value:
Tools → SQL:
ALTER TABLE "table" ALTER COLUMN "ID" INT GENERATED BY DEFAULT AS
IDENTITY(START WITH 0)
I set this report as duplicate of the elder report.
*** This bug has been marked as a duplicate of bug 45947 ***
--
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
