[Libreoffice-bugs] [Bug 119962] New: FireBird: Auto-Increase after copy table: Error inserting new data item.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119962

            Bug ID: 119962
           Summary: FireBird: Auto-Increase after copy table: Error
                    inserting new data item.
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Privat at eigilwiwe.dk

Created attachment 144991
  --> https://bugs.documentfoundation.org/attachment.cgi?id=144991&action=edit
Database table to demonstrate the error

FireBird: Auto-Increase after copy table: Error inserting new data item. 

firebird_sdbc error:
*violation of PRIMARY or UNIQUE KEY constraint "INTEG_9" on table "Letters"
*Problematic key value is ("ID" = 2)
caused by
'isc_dsql_execute'

I have prepared the table "Letter" by copying it from another table. There are
4 lines in the table and I tried to register a fifth line. But ("ID" = 2) The
ID value counts up from 1 and increases by 1 at each new attempt.
After the table was copied, the reset value is zero. Therefore, the first
entries fail because the key value is not allowed. But the restart value is
incremented at each new attempt so that the value insertion succeeds when ID =
5

I have attached the file: Autoincrument error. Use it to see who the error
behaves.

Do the following: '

Copy "Letters" to Letters4. (Definition and data)
Open Letter4 and try adding a new letter. It gives the above error message.
Repeat the experiment until fifth succession succeeds.
Delete the fifth line again.
Delete Letters4

Kopier "Letters" til Letters4. (Definition og data)
Kopier "Letters2" til letters4 (tilknyt kun data).
Open Letters4 and try to insert a new letter. It gives the above error message.
Repeat the experiment until it succeeds in the ninth time. 

The error can be corrected with: 
go to Tools> SQL and type in alter table TABLE_NAME change FIELD_NAME restart
with 8; 
“alter table "Letters4" alter "ID" restart with 8;”
However, I think updating should work immediately after copying. 



Delete Letters4 and Repeat.
Copy "Letters" to Letters4. (Definition and data)
Copy "Letters3" to letters4 (attach only data).
Try to insert a new letter X, for example. It provides the above error message.
Repeat the experiment until the thirteenth time succeeds. It only succeeded
when an "X" comes in the letter field.
The table now shows 5 times ID = 12. The one ID-12 is right the four others are
wrong. I can not figure out why This view does not reflect the true table.
Therefore close the table and open it again.
The four fake 12's are now filled with the correct ID key figures. Those who
were not already filled in. 

We could have removed the error in the same way as in the previous example, but
this reveals another error or maybe the actual error. 

Regarding the 12 numbers. In the update we show that an entry is attempted to
insert a line with ID = 12, There must be a variable that sets the correct
number for (12 + 1) and this variable Must be inserted in ID that is the
primary key. But the variable will not be set. It is only increased by 1 in
relation to its previous value.

-- 
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/20180918/ce6b5065/attachment-0001.html>