[Libreoffice-bugs] [Bug 130596] New: 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

            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: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200211/f59ec354/attachment.htm>