Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1
-
Fix Version/s: 10.1.15
-
Component/s: OTHER
-
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.