[Libreoffice-bugs] [Bug 126281] Data corruption of firebird numeric and decimal fields.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
                 CC|                            |robert at familiegrosskopf.de

--- Comment #1 from Robert Großkopf <robert at familiegrosskopf.de> ---
Could confirm the buggy behaviour with 
Version: 6.3.0.0.beta2
Build-ID: 6c6edded7133daf2d8d0b2ea7ae25b8109c5c064
on OpenSUSE 15 64bit rpm Linux

Note: 
If you set NUMERIC(15, 4) it will be all 0.0001
If you set NUMERIC(15, 5) it will be all 0.00001
... and the same behaviour for DECIMAL. 

Could be this is the reason:
-------------
NUMERIC(4) stored as      SMALLINT (exact data)
NUMERIC(4,2)              SMALLINT (data * 10^2)
NUMERIC(10,4) (Dialect 1) DOUBLE PRECISION
              (Dialect 3) BIGINT (data * 10^4 )
-------------
See Firebird 2.5 Language Reference

-- 
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/20190708/6ec74ca8/attachment.html>