[Libreoffice-bugs] [Bug 130596] FIREBIRD (internal): Parameter doesn't work with COALESCE and numeric fieldtypes

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Robert Großkopf <robert at familiegrosskopf.de> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200212/a6c72932/attachment.htm>