Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
5.5, 10.1, 10.2, 10.3, 10.4
-
Any
Description
DATE(IFNULL(XXX, 0)) is not returning same result with different XXX
mysql> SELECT DATE(0), DATE(IFNULL(NULL, 0)), DATE(IFNULL(DATE(NULL), 0)), DATE(NULL);
|
+------------+-----------------------+-----------------------------+------------+
|
| DATE(0) | DATE(IFNULL(NULL, 0)) | DATE(IFNULL(DATE(NULL), 0)) | DATE(NULL) |
|
+------------+-----------------------+-----------------------------+------------+
|
| 0000-00-00 | 0000-00-00 | NULL | NULL |
|
+------------+-----------------------+-----------------------------+------------+
|
3rd column DATE(IFNULL(DATE(NULL), 0)) expected to be 0000-00-00
Attachments
Issue Links
- relates to
-
MDEV-17736 Inconsistency between DATE('0') and TIME('0')
- Open