Details
Major
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions