Hi, i hit a weird behavior:

select date(null); #result is null
select if(date(null) is null, 1, 2); #result is 2 (not null)
select if(date(null) is not null, 1, 2); #result is 1

I use mysql version 5.0.32-Debian_7etch1-log.

Is this a bug and if not, can anyone explain why?

Thanks,

Daniel


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to