Search for NULL value seemignly not possible from simple search and not obvious from advanced search

[Elgon]

In the release notes for QGIS 1.5.0 it says "Support NULL values in search strings". However, a search for NULL,"", ,"NULL" in the "Look for" box does not yield any results. It is possible to search for NULL in advanced search with the syntax Field IS NULL. This however is also not obvious as "IS" does not seem to be an optional operator within the Search Query Builder.

AS the NULL value can occur often in data and can be seen in the attribute table but cannot be searched for in an easy way like all other values, I plead for a an equal treatment of NULL in this respect.

Suggestions: 1. Enable the search for NULL in the simple search. 2. Enable search with the syntax "Field = NULL" in the Advanced search. (I believe introducing "IS" as a new operator does not make much sense as it is logically the same as "=".)

[wonder]

I disagree with the second suggestion: allowing the syntax "Field = NULL" would not be correct. We are trying to keep the functionality as close to SQL standard as possible. SQL uses three-valued logic (true, false, unknown) and all predicates like "x = NULL" return unknown. Select command returns only rows where predicate evaluates to true. Therefore "select * from Table WHERE x = NULL" will always return zero rows. Test for NULL can be done only by using "x IS NULL".

If the user wants to search for NULL rows, we could allow him to enter "NULL" as a search text and generate the query as "x IS NULL".

[jef]

Replying to wonder:

I disagree with the second suggestion

Thanks, I would have posted almost exactly the same, you just were a bit quicker ;)

BTW the string NULL is also the representation for undefined string attributes in the attribute editor. Searching for (or editing to) a literal string "NULL" will(/is) currently impossible - maybe there should be a way to set the NULL representing value in options.

[sunilkcube]

fixed in r15056c by Jurgen