-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.4
-
Fix Version/s: 10.4.0
-
Component/s: Temporal Types
-
Labels:None
10.4
SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t; |
+------+------+------+
|
| ts | d | t |
|
+------+------+------+
|
| 1 | 1 | NULL |
|
+------+------+------+
|
10.3
SELECT TIMESTAMP(0)=TIMESTAMP('z') AS ts, DATE(0)=DATE('z') AS d, TIME(0)=TIME('z') AS t; |
+------+------+------+
|
| ts | d | t |
|
+------+------+------+
|
| 1 | 1 | 1 |
|
+------+------+------+
|
- relates to
-
MDEV-17563 Different results using table or view when comparing values of time type
-
- Closed
-
-
MDEV-17625 Different warnings when comparing a garbage to DATETIME vs TIME
-
- Closed
-
-
MDEV-17632 Inconsistent behavior of conversion to DATETIME for comparison
-
- Open
-