| 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 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.
Description: 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