Hello, every one. I Found a bug about CASE .. WHEN .. THEN..
mysql> SELECT VERSION() ; +------------+ | VERSION() | +------------+ | 4.0.3-beta | +------------+ 1 row in set (0.00 sec) mysql> select CASE NULL WHEN NULL THEN 0 ELSE 1 END AS RESULT ; +--------+ | RESULT | +--------+ | 1 | +--------+ 1 row in set (0.00 sec) I think RESULT should be '0'. Am I wrong? IF() works finely. mysql> SELECT IF( NULL IS NULL, 0 , 1 ) AS RESULT ; +--------+ | RESULT | +--------+ | 0 | +--------+ 1 row in set (0.00 sec) Is this a bug or a mistake of mine? Thanks! sql. ########################## Heo, Jungsu Mr. SimpleX Internet. http://www.simplexi.com --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
