<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="robert@familiegrosskopf.de">robert@familiegrosskopf.de</a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: firebird: migration: Relationships lost when database converted to firebird"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116965">bug 116965</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>robert@familiegrosskopf.de
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: firebird: migration: Relationships lost when database converted to firebird"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116965#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: firebird: migration: Relationships lost when database converted to firebird"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116965">bug 116965</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="robert@familiegrosskopf.de">robert@familiegrosskopf.de</a>
</span></b>
<pre>Could confirm the buggy behavior.
When starting the database under
Version: 6.1.0.0.alpha0+
Build-ID: dc823f5fa4a5d2eca56297b9045e5962536c00f9
CPU-Threads: 4; BS: Linux 4.4; UI-Render: Standard; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2018-04-10_23:32:35
I get this error:
firebird_sdbc error:
*unsuccessful metadata update
*CREATE TABLE Products failed
*Table Products already exists
caused by
'CREATE TABLE "Products" ( "LeadTime" VARCHAR(50), "ProductID" INTEGER NOT NULL
PRIMARY KEY, "UnitPrice" DECIMAL(17), "CategoryID" INTEGER, "SupplierID"
INTEGER, "ProductName" VARCHAR(50), "Discontinued" BOOLEAN, "ReorderLevel"
INTEGER, "Serialnumber" VARCHAR(50), "UnitsInStock" INTEGER, "UnitsOnOrder"
INTEGER, "ProductDescription" VARCHAR(250))'
... but the tables appear, when switching to the "Tables"-section.
Then I opened the relationship and see two tables without any connection. Seems
the GUI has recognized there are two tables for the relationship, but doesn't
know the relation. Created the relation, saved and closed the database -
reopened and the relation has gone again. I have to close the database after
the migration and have to reopen it again. Then I could create the relation
without loosing it.</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>