[Libreoffice-bugs] [Bug 126401] New: Base: Data corruption in Firebird migration

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126401
           Summary: Base: Data corruption in Firebird migration
           Product: LibreOffice
           Version: 6.3.0.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lajo at rn.dk

Description:
Testing out LO 6.3.0.1 on attachment 135786 (originally created for bug
112023), I am asked if I want to migrate embedded HSQL data to Firebird. If
answering yes, the file opens, but the data are corrupted. No warning or other
indication is given.

The original file contains these data:

    MyTimestamp            MyDouble
    01-01-2015 00:00:01    1.2345
    01-01-2015 00:00:15    3.1415

which in standard viewing is shown as (correctly, just shown in lower
precision):

    MyTimestamp       MyDouble
    01-01-15 00:00    1.23
    01-01-15 00:00    3.14

However, after migration to Firebird, the view is

    MyTimestamp       MyDouble
    31-12-14 23:00    0
    31-12-14 23:00    1.10E+227

I.e., the timestamp has lost one hour (thereby moving just past midnight 2015
to one hour before midnight 2014), while the numerical data are completely
corrupted.

Steps to Reproduce:
1. Open the attachment in LO 6.3.0.1
2. Click on tables and answer "Later" to migration
3. Open Table1 and note results
4. Close file
5. Re-open, answer "Yes" to migration
6. Open Table1 and note results

Actual Results:
Data are corrupted after migration.

Expected Results:
Data should be unchanged after migration.


Reproducible: Always


User Profile Reset: No



Additional Info:
Problem found in:

Version: 6.3.0.1 (x64)
Build ID: 41ac97386aba908b6db860cfb4cfe2da871886ae
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: da-DK (da_DK); UI-Language: en-GB
Calc: threaded

Current "fresh" version does not suggest migration and opens the file without
problems::

Version: 6.2.5.2 (x64)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: da-DK (da_DK); UI-Language: en-GB
Calc: threaded

-- 
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/20190715/f4a5a48b/attachment.html>