Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Not repeatable in mysql-5.1
DAY(NULL) is NULL and COALESCE(NULL) is NULL, so DAY(COALESCE(NULL)) should also be NULL. However, 5.1-micro returns 0 instead.
MySQL [test]> select DAY(COALESCE(NULL));
---------------------
| DAY(COALESCE(NULL)) |
---------------------
| 0 |
---------------------
1 row in set (0.00 sec)