Hi, On Dec 13, 2007 3:53 PM, Daniel Mikic <[EMAIL PROTECTED]> wrote: > 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?
Seems to be a bug, but I can't reproduce on 5.0.45-Debian_1ubuntu3-log, where it works correctly. What do you get from this? mysql> select date(null) is null; +--------------------+ | date(null) is null | +--------------------+ | 1 | +--------------------+ 1 row in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
