List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:January 23 2008 2:32pm
Subject:RE: Did NOT condition on VARCHAR change with 5.0.45?
View as plain text  
> -----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 |
+-----------+



Thread
Did NOT condition on VARCHAR change with 5.0.45?Mont McAdam15 Jan
  • Re: Did NOT condition on VARCHAR change with 5.0.45?Martijn Tonies15 Jan
    • Re: Did NOT condition on VARCHAR change with 5.0.45?Moon's Father16 Jan
Re: Did NOT condition on VARCHAR change with 5.0.45?Mont McAdam23 Jan
  • RE: Did NOT condition on VARCHAR change with 5.0.45?Jerry Schwartz23 Jan
  • Re: Did NOT condition on VARCHAR change with 5.0.45?Perrin Harkins23 Jan
    • executing query from the command line -- need help Charles Brown23 Jan
      • RE: executing query from the command line -- need help Jay Blanchard23 Jan
      • RE: executing query from the command line -- need help Jay Blanchard23 Jan
RE: executing query from the command line -- need help Jay Blanchard23 Jan
  • Re: executing query from the command line -- need helpobed24 Jan
    • RE: executing query from the command line -- need helpCharles Brown24 Jan