Details
Major
Description
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES ('1e-1000000000000');
SHOW WARNINGS;
SELECT * FROM t1;
returns
+---------+------+--------------------------------------------+ | Level | Code | Message | +---------+------+--------------------------------------------+ | Warning | 1264 | Out of range value for column 'a' at row 1 | +---------+------+--------------------------------------------+ 1 row in set (0.00 sec) +------------+ | a | +------------+ | 2147483647 | +------------+ 1 row in set (0.00 sec)
This is wrong. The expected result is 0.
The warning also does not look correct.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions