|
SET sql_mode='';
|
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.
|