https://bugs.documentfoundation.org/show_bug.cgi?id=119628
Bug ID: 119628
Summary: EDITING: Firebird Embedded: error message when
resetting auto increment a second time
Product: LibreOffice
Version: 6.0.6.2 release
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kam3...@gmail.com
Created attachment 144590
--> https://bugs.documentfoundation.org/attachment.cgi?id=144590&action=edit
A simple database for testing
macOS High Sierra 10.13.6
Example: I have a table with records 1-30 with the primary key AutoValue set to
Yes. I delete records 16-30. I don't want the next record I add to have a
primary key of 31.
To reset this, I go to Tools > SQL and type in alter table TABLE_NAM alter
FIELD_NAME restart with 15;
All is well, and I am able to add new records without a gap in the primary key
sequence.
However, if I again delete some records and try to execute this SQL statement
again, I receive the following error message:
1: firebird_sdbc error: *violation of PRIMARY or UNIQUE KEY constraint
"INTEG_1" on table "TABLE_NAM" caused by 'alter table "TABLE_NAM" alter
"FIELD_NAME" restart with NNNN;'
(NNNN being whatever number I input in my second attempt at restarting the
sequence.)
The funny thing is, despite the error message, Base will do as I directed and
restart the sequence once again.
Attached is the database I was using.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
