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.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Affects Version/s | 10.2 [ 14601 ] |
Fix Version/s | 10.1.15 [ 22018 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 76184 ] | MariaDB v4 [ 150551 ] |