https://bugs.documentfoundation.org/show_bug.cgi?id=116982
Bug ID: 116982
Summary: FIREBIRD : Migration : import of table with
autoincrement leads to integrity violation when
attempting to add new record
Product: LibreOffice
Version: 6.1.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: ipla...@tuta.io
Description:
The enclosed test ODB file has two tables, each with an autoincrement ID
primary key.
When opening the file in master, the silent conversion to firebird creates the
tables, but no data entry is possible. When attempting to add a new record
(ading a name to the name to the fname field of table fname, I get the
following error :
Error inserting the new record:
firebird_sdbc error:
*violation of PRIMARY or UNIQUE KEY constraint "INTEG_1" on table "fname"
*Problematic key value is ("id" = 0)
caused by
'isc_dsql_execute'
Steps to Reproduce:
1. Open the ODB file in master/daily build.
2. Open table FNAME
3. Try adding a new name to the fname field.
Actual Results:
Failure to insert new record:
Error code: 1
firebird_sdbc error:
*violation of PRIMARY or UNIQUE KEY constraint "INTEG_1" on table "fname"
*Problematic key value is ("id" = 1)
caused by
'isc_dsql_execute'
Expected Results:
The new record should be created correctly and the ID counter increased by 1
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:59.0)
Gecko/20100101 Firefox/59.0
--
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
