Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0.10
-
None
Description
Hybrid functions IF, IFNULL,CASE,COALESCE do not add
CURRENT_TIME when converting TIME to DATETIME:
mysql> SELECT IF(1,TIME'10:10:10',DATE'2001-01-01');
|
+---------------------------------------+
|
| IF(1,TIME'10:10:10',DATE'2001-01-01') |
|
+---------------------------------------+
|
| 0000-00-00 10:10:10 |
|
+---------------------------------------+
|
1 row in set (0.01 sec)
|
MySQL-5.6 correctly adds CURRENT_DATE:
+---------------------------------------+
|
| IF(1,TIME'10:10:10',DATE'2001-01-01') |
|
+---------------------------------------+
|
| 2014-04-15 10:10:10 |
|
+---------------------------------------+
|
1 row in set (0.00 sec)
|
Attachments
Issue Links
- blocks
-
MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision
-
- Stalled
-