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
-
Activity
| Fix Version/s | 10.0.11 [ 15200 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.0.12 [ 15201 ] | |
| Fix Version/s | 10.0.11 [ 15200 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | defaullt [ 38916 ] | MariaDB v2 [ 43283 ] |
| Workflow | MariaDB v2 [ 43283 ] | MariaDB v3 [ 62371 ] |
| Workflow | MariaDB v3 [ 62371 ] | MariaDB v4 [ 147794 ] |