[Libreoffice-bugs] [Bug 118043] New: Firebird: Migration Data loss when moving decimal datatype defined in HSQL schema with precision values higher than those allowed in Firebird

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118043
           Summary: Firebird: Migration Data loss when moving decimal
                    datatype defined in HSQL schema with precision values
                    higher than those allowed in Firebird
           Product: LibreOffice
           Version: 6.1.0.0.beta1+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: drewjensen.inbox at gmail.com

Description:
Both HSQL and Firebird define DECIMAL data types with user supplied precision
setting.

HSQL supports a larger precision setting than does Firebird. 
Firebird limit is 18 and HSQL supports values up to 100.

The attached example with HSQL decimal(20, 2) [precision 20, 2 decimal places])
and a range of values displayed as Euros. 



Steps to Reproduce:
1. download the attached file and make a copy of it
2. open the copy and click on tables, say yes to start migration assistant
3. when it finishes open the data table
4. open the original file you download, open the same data table


Actual Results:  
the values do not match in every row
check out the attached screen shot for highlighted rows.

Expected Results:
the values stored properly in a decimal(18,2) column in the new schema. 


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Ubuntu Chromium/66.0.3359.181 Chrome/66.0.3359.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/20180606/706de776/attachment.html>