[Libreoffice-bugs] [Bug 126408] Base: HSQL to Firebird migration corrupts data

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Lars Jødal <lajo at rn.dk> ---
(In reply to Xisco Faulí from comment #1)
> MyDouble column problem is a duplicate of bug 126268

The problem with DOUBLE seem to be different from the problem with DECIMAL.
Testing with build dated 2019-07-17:

Version: 6.4.0.0.alpha0+ (x86)
Build ID: c738be4de6886a0c96b7d10df7e78c8b2964c135
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: da-DK (da_DK); UI-Language: en-US
Calc: CL

In this version, the DECIMAL problem appears to be fixed (tested with
attachment 152620), while the DOUBLE problem remains (tested with attachment
135786).

Regarding time shift, the link
https://wiki.documentfoundation.org/Documentation/HowTo/MigrateFromHSQLDB
describes it like this:

"The Migration Wizard does not manage to correctly migrate date fields, time
fields, and date / time fields. This is because the HSQLDB works with local
time zones. During the date-time migration, this suddenly turns into summer
time values ​​that are 2 hours earlier, but only one hour in winter time."

I.e., the bug is known, and the link also gives a workaround, but not something
that is part of automated migration.

-- 
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/20190717/b356b2ac/attachment.html>