[Libreoffice-bugs] [Bug 119625] New: Firebird: Migration: "value exceeds range for a valid time"

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119625
           Summary: Firebird: Migration: "value exceeds range for a valid
                    time"
           Product: LibreOffice
           Version: 6.2.0.0.alpha0+ Master
          Hardware: x86 (IA32)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: lo_bugs at iseries-guru.com

This bug report arises from my poking into bug 117732.

These observations are collected from daily Linux dbgutil bibisect
repository version 2018-07-01 running on debian-buster.  From
2018-07-06 on, the conversion fails silently and the .odb retains the
HSQL database.


STR
---
Once only:

(1) Preparation:
    (1.1) Download date_time_test.zip
          <https://bugs.documentfoundation.org/attachment.cgi?id=142236>
          attached to tdf#117732 "Firebird: Migration: Time values are
          being changed during migration process (data type TIME and
          DATETIME)"
    (1.2) extract moreTime_hsql.odb
    (1.3) rename moreTime_hsql.odb to moreTime_hsql.odb_received

Per test:

(2) Copy moreTime_hsql.odb_received to moreTime_sql.odb

(3) Open moreTime_hsql.odb.  Program presents database window.

(4) In Database pane, click <Tables>.  Program presents dialog Confirm
    Migration.

(5) In Confirm Migration prompt, click <Yes>.

    Expected:  Database window.  Table tst_data has 7 rows.

    Observed:  Message
                   firebird_sdbc error:
                   *value exceeds the range for a valid time
                   caused by
                   'isc_dsql_execute'

(6) Click <OK>.  Program presents database window.

    Expected:  Table tst_data contains 7 rows.

    Observed:  Table tst_data has only 1 row.

-- 
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/20180831/e3224c48/attachment.html>