https://bugs.documentfoundation.org/show_bug.cgi?id=163996
Bug ID: 163996
Summary: FIREBIRD: Parameter query with :parameter IS NULL
doesn't work (Integer, Date)
Product: LibreOffice
Version: 24.8.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 197727
--> https://bugs.documentfoundation.org/attachment.cgi?id=197727&action=edit
Open the database and test the queries. Input values for date, integer or
string in parameter.
Open the attached database.
Execute the queries.
There is one query for a date parameter, one for a integer parameter and one
for a string parameter:
SELECT * FROM "tbl_Test" WHERE "Datum" <= :qDate OR :qDate IS NULL
and the same for another Integer or Varchar field.
If you won't fill any content in parameter it will work. All four rows of the
table will be shown.
If you fill with a parameter, query for date and integer will throw
SQL-Status: HY004
Incorrect type for setValue
Only string would work well without any problem. This has been solved in
bug130595
--
You are receiving this mail because:
You are the assignee for the bug.
