-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.4
-
Fix Version/s: 10.4.0
-
Component/s: Data types, Temporal Types
-
Labels:None
CREATE OR REPLACE TABLE t1 (a YEAR); |
INSERT INTO t1 VALUES (NULL); |
SELECT COALESCE(a), DATE(COALESCE(a)) FROM t1; |
+-------------+-------------------+
|
| COALESCE(a) | DATE(COALESCE(a)) |
|
+-------------+-------------------+
|
| NULL | 0000-00-00 |
|
+-------------+-------------------+
|
The result for DATE(COALESCE(a)) is wrong. It should be NULL.
- relates to
-
MDEV-16926 CAST(COALESCE(year_field)) returns wrong value
-
- Closed
-