<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: Import of a specific table with a combined primary key fails"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135239">135239</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FIREBIRD: Import of a specific table with a combined primary key fails
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>robert@familiegrosskopf.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=163701" name="attach_163701" title="HSQLDB database. Copy the database before migrating! You will need the HSQLDB content.">attachment 163701</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=163701&action=edit" title="HSQLDB database. Copy the database before migrating! You will need the HSQLDB content.">[details]</a></span>
HSQLDB database. Copy the database before migrating! You will need the HSQLDB
content.
Copy the attached database for testing to import later ...
Set experimental functions to "yes".
Open the attached HSQLDB-database and switch to the tables.
Let the migration wizard for Firebird do his work.
An error appears: Table rel_Kasse_Kategorie does not exist (see second
attachment).
Ok - let us have a look:
The relations couldn't be completely created because the table hasn't be
imported.
Save the database, close it and set experimental functions to "no".
Now open the database with a new name, "Beispiel_Haushaltsbuch_Firebird.odb"
for example.
Open the copy of the database, which is HSQLDB.
Copy the table from Hsqldb to Firebird.
Only the structure of the table will be copied. Copying the content will fail.
No way to get the content copy directly from HSQLDB to Firebird for this table.
Copy the content from the table to Calc.
Mark the content and move it by pressing left mousebutton to Firebird.
You could insert the content to the table in Firebird.
Expected behavior: Minimum for a migration has to be: Copying and inserting of
tables has to run without problems.</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>