[Libreoffice-bugs] [Bug 117253] FIREBIRD: Migration: Migration routine does not import HSQL TEXT TABLES.

[bugzilla-daemon at bugs.documentfoundation.org]

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

robert at familiegrosskopf.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |robert at familiegrosskopf.de
           Assignee|libreoffice-bugs at lists.free |robert at familiegrosskopf.de
                   |desktop.org                 |
     Ever confirmed|0                           |1

--- Comment #3 from robert at familiegrosskopf.de ---
Created attachment 141666
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141666&action=edit
Extract the *.zip-file. Open the database. HSQLDB could read table, Migration
doesen't work

I could confirm the buggy behavior.
Extract the attached *.zip-file.
Make a copy of the database in the same folder - the original database is
unusable afterwords ...
Open the database.
Press "Yes" to migrate.
This error appears:

firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Adressen failed
*SQL error code = -607
*Invalid command
*Table Adressen does not exist
caused by
'ALTER TABLE "Adressen" ALTER COLUMN "ID" RESTART WITH 4'

Table "Adressen" hasn't been migrated.

-- 
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/20180427/e9f7d7df/attachment.html>