RE: Did NOT condition on VARCHAR change with 5.0.45?

[Jerry Schwartz]

> -----Original Message-----
> From: Mont McAdam [mailto:mont@stripped]
> Sent: Tuesday, January 22, 2008 7:18 PM
> To: mysql@stripped
> Subject: Re: Did NOT condition on VARCHAR change with 5.0.45?
>
> `method` is the name of the column in the table.
>
> 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.
>
> This has always worked in the past. However now EVERY row is returned
> regardless of the contents of `method`.
[JS] I'm running 4.1.22:

mysql> select "" = true;
+-----------+
| "" = true |
+-----------+
|         0 |
+-----------+