3 messages in com.mysql.lists.bugsRe: Nulls appear not be respected
FromSent OnAttachments
Mark Stosberg05 Jun 2001 12:13 
Mark Stosberg05 Jun 2001 13:40 
Michael Widenius06 Jun 2001 02:08 
Subject:Re: Nulls appear not be respected
From:Mark Stosberg (ma@summersault.com)
Date:06/05/2001 01:40:11 PM
List:com.mysql.lists.bugs

Try: last_visit IS NULL or: last_visit IS NOT NULL

Nulls are not numbers, therefore they cannot have equality (=).

Thanks Robert, your suggestion allows a work around for me. I still consider this a bug in MySQL though. It seems that MySQL should:

A.) Be forgiving about my syntax or B.) Throw an error that my syntax is invalid

Instead, it returns an answer that appears wrong.

I checked Postgres, which handles this by allowing "=" as a synonym for "IS" in this case.

-mark

http://mark.stosberg.com/