[MDEV-17625] Different warnings when comparing a garbage to DATETIME vs TIME Created: 2018-11-06  Updated: 2018-11-08  Resolved: 2018-11-08

Status: Closed
Project: MariaDB Server
Component/s: Temporal Types
Affects Version/s: 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s: 10.4.0

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-4912 Data type plugin API version 1 Closed
Relates
relates to MDEV-17634 Regression: TIME(0)=TIME('z') returns... Closed
relates to MDEV-17563 Different results using table or view... Closed
relates to MDEV-17632 Inconsistent behavior of conversion t... Open

 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.

 Comments   
Comment by Alexander Barkov [ 2018-11-08 ]

Fixed as a part of a join patch for MDEV-17563 and MDEV-17625

Generated at Thu Feb 08 08:37:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.