https://bugs.freedesktop.org/show_bug.cgi?id=55703
Priority: medium
Bug ID: 55703
Assignee: [email protected]
Summary: Query Design View incorrectly handles null
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: unspecified
Component: Database
Product: LibreOffice
In the design view, when "null" is entered as a selection criterion, it is
forced to "EMPTY". Similarly, "empty" is forced to uppercase "EMPTY".
So, you think the software has understood what you want.
However, this leads to generation of the SQL code "= NULL", which is
syntactically correct but logicially incorrect and returns no rows.
It should be "IS NULL".
When the corrected query is edited back in the design view, "IS EMPTY" is
displayed.
Conclusion : "null" and "empty" should be forced to "IS EMPTY".
All "" quotes are mine.
--
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
