https://bugs.documentfoundation.org/show_bug.cgi?id=130596
Bug ID: 130596
Summary: FIREBIRD (internal): Parameter doesn't work with
COALESCE and numeric fieldtypes
Product: LibreOffice
Version: 6.1.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Open the database attached here:
https://bugs.documentfoundation.org/attachment.cgi?id=157803
Open the query
Query_parameter_Coalesce_String
Input a value for paramter "name", for example 'Rob'.
No error appears.
Refresh the query and input nothing for the parameter.
All content appears.
Now open
Query_parameter_Coalesce_Integer (or ...Decimal)
Input a number like 1.
An error appears:
SQL Status: HY004
Incorrect type for setString
Here is the query:
SELECT * FROM "Table1" WHERE "Integer" = COALESCE ( :testInt, "Integer" )
This query works well with the internal HSQLDB.
All tests made with OpenSUSE 15.1 64bit rpm Linux. Fails with LO 6.1.5.2, also
with LO 6.4.0.3
--
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
