[Libreoffice-bugs] [Bug 117298] New: 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

            Bug ID: 117298
           Summary: Firebird: Migration hsqldb column type Time is changed
                    to DateTime during migration, if data is in source
                    table it generates an error during import
           Product: LibreOffice
           Version: 6.1.0.0.alpha1+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: drewjensen.inbox at gmail.com

Description:
The ebmedded firebird engine is configured for the TIME data type (Dialect 3
for dates) but during migration a type of DATETIME.

Steps to Reproduce:
1. Download and open attched odb file
2. select Tables and when prompted to migrate select yes.
3. The migration function generates an error 'set var type fails' during data
move.


Actual Results:  
LibO displayes error message: Incorrect type for setValue 

Expected Results:
table and data migrate.


Reproducible: Always


User Profile Reset: No



Additional Info:
do not save the file.
Open it in hsql mode.
delete the single record in the table.
close and reopen, click on tables.
Answer yes for migration and it runs to completion
check the table structure, column type changed to DateTime.


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Ubuntu Chromium/65.0.3325.181 Chrome/65.0.3325.181 Safari/537.36

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