Bug #34616 date() result bug
Submitted: 16 Feb 2008 5:00 Modified: 16 Feb 2008 6:27
Reporter: mauricio prado Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.027 OS:Windows (community log)
Assigned to: CPU Architecture:Any
Tags: date, IS NULL, null

[16 Feb 2008 5:00] mauricio prado
seems to be that the compare between date() result and is null operator doesnt work like supoused

How to repeat:
when i execute the query :
"select date(concat("2008","-","13","-","31"))"
the result is one row with a "NULL" value

but, when i execute
"select date(concat("2008","-","13","-","31")) is null"
the result is one row with a "0" value

Suggested fix:
return a "1" when NULL is NULL would be ok
[16 Feb 2008 6:27] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior with latest versions, although bug is repeatable in version 5.0.27.