And
SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL:
returns what?
"P.Peti" wrote:
>
> Hello,
>
> I have updated my mysql server from version 3.22.25 to
> 3.23.33. I've noticed that the same query's output I've run
> in the old version differs from the new version's.
>
> Eg.
>
> I've got a film database:
>
> SELECT COUNT(*) FROM FILM;
>
> returns me a number of 53.
>
> The same select with a WHERE COMMENT="deleted" clause
> returns 5.
>
> With "WHERE COMMENT!="deleted" " it returns 18.
>
> Normally, one would assume that #"deleted"+#"!deleted"
> makes 53 but it doesn't. I've seen that there were some
> modifications in 3.23.26 affecting mysql's behavior
> concerning NULL value. My question is that this new
> behavior is the the desired or the old one?
>
> Please CC me, i'm not on the list. sorry.
>
> Bye:
> PP.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
