<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FIREBIRD (internal): Parameter query with :parameter IS NULL doesn't work"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130595">130595</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FIREBIRD (internal): Parameter query with :parameter IS NULL doesn't work
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>robert@familiegrosskopf.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=157803" name="attach_157803" title="Open the query "Query_parameter_IS_NULL" and input a character for parameter">attachment 157803</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=157803&action=edit" title="Open the query "Query_parameter_IS_NULL" and input a character for parameter">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>