https://bugs.documentfoundation.org/show_bug.cgi?id=123838
Robert Großkopf <rob...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rob...@familiegrosskopf.de
--- Comment #1 from Robert Großkopf <rob...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs