https://bugs.documentfoundation.org/show_bug.cgi?id=153004
Bug ID: 153004
Summary: Copying content to a table without an auto value
primary key gives an error but copies the whole
content
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Take this database file:
https://bugs.documentfoundation.org/attachment.cgi?id=184626
Copy the query and paste it as new table. See description
https://bugs.documentfoundation.org/show_bug.cgi?id=153003
If you try this with LO 7.2.0.4 (and up to LO 7.4.3.2) you will get an error:
This operation is not supported in statement [ALTER TABLE "tbl_Auto1" ALTER
"ID" RESTART WITH 3]
/home/buildslave/source/libo-core/connectivity/source/drivers/jdbc/Object.cxx:175
This error appears when inserting content into a table, which has been created
with a primary key without Auto Value. Wizard tries to set the start for an
auto value to the new value, but it couldn't, because a normal INTEGER doesn't
support this.
You won't get this error with LO 7.4.4.2, because the import fails before this
message would appear. See bug 153003.
Bug appears in OpenSUSE 15.3 64bit rpm Linux.
--
You are receiving this mail because:
You are the assignee for the bug.
