<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124420">bug 124420</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;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Possible wrong result in query
</td>
<td>FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>drewjensen.inbox@gmail.com
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124420#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124420">bug 124420</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>Verified with Ubuntu 18.04 and LO 6.2.2
Also I duplicated this with decimal data types with the exact same error.
Numeric and Decimal being the two fixed point data types in FB and both
continue to cause problems. Along with failing in math equations it is still
impossible to import a firbird table with either data type from one firebird
sdbc base file into another firebird sdbc Base file ( forget about migrating
from HSQL ).
Exporting into Calc seems to work properly at least. Anyway I digress for this
issue.
Also there is another issue
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FIREBIRD: Multiplication in a query with decimal or numeric values gives result without decimal separator"
href="show_bug.cgi?id=121528">https://bugs.documentfoundation.org/show_bug.cgi?id=121528</a> but I think the two
are different.</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>