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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
