<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: Multiplication in a query with decimal or numeric values gives result without decimal separator"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121528">bug 121528</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;">Summary</td>
<td>FIREBIRD: Multiplication in a query with decimal-values gives result without decimal separator
</td>
<td>FIREBIRD: Multiplication in a query with decimal or numeric values gives result without decimal separator
</td>
</tr></table>
<p>
<div>
<b><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="https://bugs.documentfoundation.org/show_bug.cgi?id=121528#c3">Comment # 3</a>
on <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="https://bugs.documentfoundation.org/show_bug.cgi?id=121528">bug 121528</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>Using Ubuntu 18.04.1 and LO 6.2Beta1
Using the attached file created 3 new tables, copies of the original, but with
the datatype changed during the copy from decimal to double, numeric and float.
NOTE - in the current Base GUI (import and table designer) double and float
only allow one decimal place, while the decimal values used 2.
Using the same query against each of the tables:
double and float run as expected.
numeric has the exact problem decimal does
updated the summary to reflect.</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>