> -----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 |
+-----------+

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.