|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Did NOT condition on VARCHAR change with 5.0.45?
From: Perrin Harkins (perrin
elem.com)
Date: Wed Jan 23 2008 - 09:50:13 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Jan 22, 2008 7:18 PM, Mont McAdam <montplatformnetworks.net> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]