[MDEV-6100] No warning on CAST(9000000 AS TIME) Created: 2014-04-15  Updated: 2014-07-28  Resolved: 2014-06-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.3.12, 5.5.36, 10.0.10
Fix Version/s: 5.5.38, 10.0.12, 5.3.13

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

Issue Links:
Blocks
blocks MDEV-6001 Merge tests for MySQL WL#946 TIME/DAT... Stalled

 Description   

Conversion of an out-of-range number to TIME does not produce a warning:

mysql> SELECT CAST(9000000 AS TIME);
 
+-----------------------+
 
| CAST(9000000 AS TIME) |
 
+-----------------------+
 
| 838:59:59             |
 
+-----------------------+
 
1 row in set (0.00 sec)

MySQL-5.5 returns 838:59:59 with a warning, which looks correct.
MySQL-5.6 returns NULL with a warning, which looks wrong.

 Comments   
Comment by Alexander Barkov [ 2014-06-04 ]

Pushed into 5.3 and 5.5

Generated at Thu Feb 08 07:09:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.