[Libreoffice-bugs] [Bug 130595] New: FIREBIRD (internal): Parameter query with :parameter IS NULL doesn't work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130595
           Summary: FIREBIRD (internal): Parameter query with :parameter
                    IS NULL doesn't work
           Product: LibreOffice
           Version: 6.4.0.3 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

Created attachment 157803
  --> https://bugs.documentfoundation.org/attachment.cgi?id=157803&action=edit
Open the query "Query_parameter_IS_NULL" and input a character for parameter

Open the attached database.
Open the query "Query_parameter_IS_NULL".
If you won't add any content to the parameter the query will work. It shows all
rows of the table.
If you write down 'Rob' (or something else, must not exist in the database)
there appears

SQL Status: HY004
Incorrect type for setString

... and no content will be shown.
This behavior only changes a little bit if the field isn't a VARCHAR-field.
When I change to INTEGER the error is

Incorrect type for setValue

Bug appears in LO 6.4.0.3, also LO 6.1.5.2 on OpenSUSE 15.1 64bit rpm Linux.

-- 
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/8941a3db/attachment.htm>