[MDEV-10277] Redundant NOTE when inserting '0.00001 ' into a DECIMAL(2,1) column Created: 2016-06-23  Updated: 2016-06-27  Resolved: 2016-06-27

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.1
Fix Version/s: 10.1.15

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


 Description    

DROP TABLE IF EXISTS t1;
 
CREATE TABLE t1 (a DECIMAL(2,1));
 
INSERT INTO t1 VALUES ('0.00001 ');
 
SHOW WARNINGS;


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

The first note is generated because fractional digits do not fit.
The second note is generated because of the trailing space.

One note should be enough.
Generated at Thu Feb 08 07:40:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.