At 11:41 +0200 10/25/02, Harald Fuchs wrote:
In article 000701c27193$1bf2bfa0$aa3fe7cb@jsheo,
Heo, Jungsu [EMAIL PROTECTED] writes:
Hello, every one.
I Found a bug about CASE .. WHEN .. THEN..
mysql SELECT VERSION() ;
++
| VERSION() |
++
| 4.0.3-beta |
;
-Original Message-
From: Harald Fuchs [mailto:lists-mysql;news.protecting.net]
Sent: Friday, October 25, 2002 5:42 AM
To: [EMAIL PROTECTED]
Subject: Re: Strange behavior of CASE .. WHEN ... THEN
In article 000701c27193$1bf2bfa0$aa3fe7cb@jsheo,
Heo, Jungsu [EMAIL PROTECTED] writes
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 |