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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
