[MDEV-6287] Bad warning level when inserting a DATETIME value into a TIME column Created: 2014-06-02  Updated: 2014-06-02  Resolved: 2014-06-02

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.3.12, 5.5.37, 10.0.11
Fix Version/s: 10.0.12

Type: Bug Priority: Minor
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   

This SQL script:

drop table if exists t1;
 
create table t1 (a time);
 
insert into t1 values (1.0e+10);
 
show warnings;

displays a "Warning":

+---------+------+----------------------------------------+
 
| Level   | Code | Message                                |
 
+---------+------+----------------------------------------+
 
| Warning | 1265 | Data truncated for column 'a' at row 1 |
 
+---------+------+----------------------------------------+

It should be a NOTE instead.

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

Fixing in 5.3 and 5.5 would need to much code to be back-ported from 10.0.
Changing "Fix version" to 10.0 only.

Comment by Alexander Barkov [ 2014-06-02 ]

Pushed into 10.0.

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