https://bugs.documentfoundation.org/show_bug.cgi?id=130596
--- Comment #2 from Robert Großkopf <[email protected]> ---
Have tested this a little bit more.
SELECT * FROM "Table1" WHERE "Integer" = COALESCE ( :testInt, "Integer" )
gives
SQL Status: HY004
Incorrect type for setString
SELECT * FROM "Table1" WHERE CAST( "Integer" AS VARCHAR ( 10 ) ) = COALESCE (
:testInt, CAST( "Integer" AS VARCHAR ( 10 ) ) )
works.
There is something going wrong with the datatypes. I have set all INTEGER to
strings and it will work.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
