To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=89335
User atjensen changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu May 15 03:15:28 +0000
2008 -------
I am setting this issue to 'worksforme' for the following reason.
First - the action described is the query designer functioning as designed.
Second - the design does follow proper SQL standards.
In the query designer, in the criteria text box you can enter the strings "IS
NULL" or "IS EMPTY" to return all records where the field's value is NULL.
You can also enter just the strings "EMPTY" or "NULL" in which case the query
parser generates correct SQL of "Column" = NULL.
The SQL 92 standard states 'if one of the operands is NULL, the result of the
comparison is "UNKNOWN".'. In other words the result set would be zero records,
which is exactly what Base returns. Not often what you actually wanted, but it
is valid SQL none the less.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
