[Libreoffice-bugs] [Bug 121528] FIREBIRD: Multiplication in a query with decimal or numeric values gives result without decimal separator

[bugzilla-daemon at bugs.documentfoundation.org]

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

Drew Jensen <drewjensen.inbox at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|FIREBIRD: Multiplication in |FIREBIRD: Multiplication in
                   |a query with decimal-values |a query with decimal or
                   |gives result without        |numeric values gives result
                   |decimal separator           |without decimal separator

--- Comment #3 from Drew Jensen <drewjensen.inbox at gmail.com> ---
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.

-- 
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/20181208/dc9c1700/attachment.html>