[Libreoffice-bugs] [Bug 135239] New: FIREBIRD: Import of a specific table with a combined primary key fails

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 135239
           Summary: FIREBIRD: Import of a specific table with a combined
                    primary key fails
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

Created attachment 163701
  --> https://bugs.documentfoundation.org/attachment.cgi?id=163701&action=edit
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.

-- 
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/20200728/b33192d3/attachment.htm>