<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116982">116982</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>iplaw67@tuta.io
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>