https://bugs.freedesktop.org/show_bug.cgi?id=55703

--- Comment #5 from Andrew <[email protected]> ---
Hi all,

Lionel may be strictly correct that the default operator is being used, but I
think in this case the default is inappropriate.

The query design view is there to help people who don't know SQL, or not well.
It appears to understand what you want to do but then generates SQL code which
is not what you want, probably leaving many a user baffled about why the query
is not returning any records.

The difference between = NULL and IS NULL is a bit subtle for a lot of people.
It's a feature of SQL but, in my humble opinion, the design view should be
giving them what they want i.e. all records where the given field is empty.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to