[Libreoffice-bugs] [Bug 116980] FIREBIRD: Migration: No migration possible with data in tables and declared realtionship

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 141469
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141469&action=edit
screen shot of migrated database showing persons records.

Looks like it could be a sequencing issue now.

Using the latest Linux 64 build.

Downloaded the second attachment, TwoTablesRelated

Tried to migrate the database, it failed with a constraint violation during a
record insert.

Closed without saving.

Made a copy of the original. (TwoTablesRelated_mig)

Opened the copy in hsqldb mode and deleted all the records in the persons
table. Did not delete the records in sports table.

Saved and closed the file.

Opened the copy (as firebird)  and the original (as hsqldb).

Moved the persons table, via drag drop, from the original (source) to copy
(target) and the data goes in without an error.

The file is fully migrated with fk relationship and data. Screen shot attached.

-- 
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/20180418/33c259e5/attachment.html>