List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 17 2000 5:23pm
Subject:Re: NULL bug in 3.23.25-beta
View as plain text  
In the last episode (Oct 17), Stephan Skusa said:
> Am Tue, 17 Oct 2000 schrieb Pete Harlan:
> > select * from nulltest where x != 0;
> > +------+
> > | x    |
> > +------+
> > | NULL |
> > +------+
> > 1 row in set (0.00 sec)
> > 
> > There should be no rows returned where x != 0.
>
> Why that ... 0 is a different value than NULL !!

Correct, but any comparison to NULL must always fail.  See the mysql
manual section titled "Working with `NULL' values".

> > 3.23.25-beta, on Linux.

I see this on 3.32.25 on FreeBSD too.  Maybe mysql needs a validation
testsuite that gets run before a version gets released?

-- 
	Dan Nelson
	dnelson@stripped
Thread
NULL bug in 3.23.25-betaPete Harlan17 Oct
  • Re: NULL bug in 3.23.25-betaStephan Skusa17 Oct
    • Re: NULL bug in 3.23.25-betaDan Nelson17 Oct
      • Re: NULL bug in 3.23.25-betaStephan Skusa17 Oct
      • RE: NULL bug in 3.23.25-betaindrek siitan17 Oct
        • Re: NULL bug in 3.23.25-betaBenjamin Pflugmann19 Oct
      • Re: NULL bug in 3.23.25-betaBenjamin Pflugmann19 Oct