Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0, 10.1, 10.2, 10.3, 10.4
-
Fix Version/s: 10.4.0
-
Component/s: Temporal Types
-
Labels:None
Description
SELECT TIMESTAMP(0)='z', TIME(0)='z'; |
SHOW WARNINGS;
|
+---------+------+-------------------------------------+
|
| Level | Code | Message |
|
+---------+------+-------------------------------------+
|
| Warning | 1292 | Incorrect datetime value: 'z' |
|
| Warning | 1292 | Truncated incorrect time value: 'z' |
|
+---------+------+-------------------------------------+
|
Perhaps the same warning should be displayed.
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
-
- Closed
-
- relates to
-
MDEV-17634 Regression: TIME(0)=TIME('z') returns NULL vs 1
-
- Closed
-
-
MDEV-17563 Different results using table or view when comparing values of time type
-
- Closed
-
-
MDEV-17632 Inconsistent behavior of conversion to DATETIME for comparison
-
- Open
-