<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Data corruption of firebird numeric and decimal fields."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126281">bug 126281</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>robert@familiegrosskopf.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Data corruption of firebird numeric and decimal fields."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126281#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Data corruption of firebird numeric and decimal fields."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126281">bug 126281</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span></b>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>