Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.0.10
-
Fix Version/s: 10.0.12
-
Component/s: None
-
Labels:
Description
This SQL script:
SET timestamp=UNIX_TIMESTAMP('2014-04-14 10:20:30');
|
SELECT CAST(TIME'10:20:30' AS DATETIME), TIME'10:20:30'=TIMESTAMP'2014-04-14 10:20:30' AS cmp;
|
demonstrates that conversion between TIME and DATETIME
does not add CURRENT_DATE to TIME.
+----------------------------------+-----+
|
| CAST(TIME'10:20:30' AS DATETIME) | cmp |
|
+----------------------------------+-----+
|
| 2014-04-14 10:20:30 | 0 |
|
+----------------------------------+-----+
|
MySQL-5.6 returns "1" in the "cmp" field in the same scenario.
Attachments
Issue Links
- blocks
-
MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision
-
- Stalled
-
- relates to
-
MDEV-16532 Equality checks between now() and time columns behaves unexpectedly
-
- Closed
-