[Libreoffice-bugs] [Bug 116982] New: FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon at bugs.documentfoundation.org]

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