[MDEV-17418] Inconsitent results for TIME(8395960) and TIME('839:59:60') Created: 2018-10-10  Updated: 2018-11-26

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

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

Issue Links:
Relates
relates to MDEV-16991 Rounding vs truncation for TIME, DATE... Closed

 Description    

SELECT TIME(8395960), TIME('839:59:60');


+---------------+-------------------+
 
| TIME(8395960) | TIME('839:59:60') |
 
+---------------+-------------------+
 
| 838:59:59     | NULL              |
 
+---------------+-------------------+
 
1 row in set, 2 warnings (0.00 sec)

Looks wrong. Both columns should be NULL,
A value with a bad second value 60 should not adjust to the maximum time value.
Generated at Thu Feb 08 08:36:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.