Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL)
-
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.