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

Robert Großkopf <rob...@familiegrosskopf.de> changed:

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

--- Comment #1 from Robert Großkopf <rob...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to