https://bugs.documentfoundation.org/show_bug.cgi?id=130672
Robert Großkopf <rob...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1
CC| |rob...@familiegrosskopf.de
--- Comment #1 from Robert Großkopf <rob...@familiegrosskopf.de> ---
Could confirm the buggy behavior with the internal database HSQLDB. Seems the
parameter isn't set as Integer.
SELECT * FROM "table1" WHERE "aid" = CAST(:P1 AS INTEGER)
will work. Multiplication with '1' will do the same.
SELECT "aid", :P1 AS "T" FROM "table1" WHERE "aid" = :P1
will work also.
With internal Firebird the bug appears also, but there is no known workaround.
Tested with LO 6.4.0.3 on OpenSUSE 15.1 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