[Libreoffice-bugs] [Bug 116965] EDITING: firebird: migration: Relationships lost when database converted to firebird

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116965

robert at familiegrosskopf.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |robert at familiegrosskopf.de
     Ever confirmed|0                           |1

--- Comment #1 from robert at familiegrosskopf.de ---
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 at 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.

-- 
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/20180412/8148fb64/attachment.html>