[Libreoffice-bugs] [Bug 117298] Firebird: Migration hsqldb column type Time is changed to DateTime during migration , if data is in source table it generates an error during import

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to MM from comment #2)
> Confirmed on ubuntu 16.04 x64 with Version: 6.1.0.0.alpha1+
> Build ID: e9ac3a9c1ee7689c4d591a68250666c95632bd2a
> CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; 
> TinderBox: Linux-rpm_deb-x86_64 at 70-TDF, Branch:master, Time:
> 2018-04-27_00:59:01
> Locale: en-US (en_US.UTF-8); Calc:
> 
> You also might get the error:
> 
> firebird_sdbc error:
> *unsuccessful metadata update
> *CREATE TABLE tbl_time failed
> *Table tbl_time already exists
> caused by
> 'CREATE TABLE "tbl_time" ( "id" INTEGER GENERATED BY DEFAULT AS IDENTITY
> (START WITH -1) PRIMARY KEY, "tst_data" TIME)'

Ah - another one of those.

No this is different, what happens is that during the migration SOMETIMES when
you back out a copy of the firebird schema is left in the ODB, still configured
to use the HSQLdb sdbc, since the hsql data schema also still in the ODB
everythig seems fine till you try to auto migrate again and then you get that
table exists error.

A fix, is just to open the ODB as a zip file and remove the firebird schema in
the database directory. 

As for an issue in bugzilla, I just can't yet say how to make that happen for
on demand (set of steps).

-- 
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/39aadf38/attachment-0001.html>