[Libreoffice-bugs] [Bug 123838] Issue on CAST() (FirebirdSQL)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |robert at familiegrosskopf.de

--- Comment #1 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to perie_gut from comment #0)
> error on the CAST 
> 
> 1. create a table 
> 2. create a query in SQL View. 
> 
> CAST(SUM(fieldname)) as numeric(10,2)

This is the wrong code. numeric(10,2) isn't a part of the CAST-function in the
code. Try
CAST(SUM("fieldname") as numeric(10,2))

Works here as expected with LO 6.1.5.2 on OpenSUSE 15 64bit rpm Linux.

-- 
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/20190305/0892eb51/attachment.html>