Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
None
Description
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a FLOAT);
|
INSERT INTO t1 VALUES ('1E1000');
|
SHOW WARNINGS;
|
returns two warnings:
+---------+------+--------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------+
|
| Warning | 1264 | Out of range value for column 'a' at row 1 |
|
| Warning | 1264 | Out of range value for column 'a' at row 1 |
|
+---------+------+--------------------------------------------+
|
One warning would be enough.
If I futher do:
UPDATE t1 SET a='1E1000';
|
it reports:
Rows matched: 1 Changed: 0 Warnings: 2
|
which makes an impression that truncation happened on two rows, while in fact only one row was affected.