[Libreoffice-bugs] [Bug 119628] New: EDITING: Firebird Embedded: error message when resetting auto increment a second time

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: kam3don at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180831/05341c83/attachment.html>