Re: NULLIF() didn't work in where clause Temp.sol.

Hi Remo.

On Saturday 28 May 2005 07:17, Remo Tex wrote:
> I think its because of.. ENUM : Manual says valid entires are (in your
> case) 'Y','N', and undefined but still there: NULL, ''
> it enumerates elements in set in some manner and assigns them ?integer?
> values (position in set) and then does search by int so...
> ''=not valid ot not found in set element and it probably get assigned
> some INT val by which search is done That's why ''=N <> '' empty string
> so seems that is correct behavior in *your* case where .. IS NULL :-)
> but not in mine WHERE ... <=> NULL :(

This sounds right but I wonder why the same happens to a char-value!

> Would some guru shed some light here please...

Yes, that would be great.

Bye, René


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]