Re: Did NOT condition on VARCHAR change with 5.0.45?

[Perrin Harkins]

On Jan 22, 2008 7:18 PM, Mont McAdam <mont@stripped> wrote:
> In my opinion it should return every record from the table where `method` is
> equal to NULL, ZERO or EMPTY STRING, as this table doesn't allow null, and
> the field type is varchar, this would be EMPTY STRING's only.

Although it doesn't matter here because of the NOT NULL, this will
never match NULL values.  NULL values are neither true nor untrue, so
they have to be checked with IS NULL.  This is standard, not a MySQL
thing.

- Perrin