Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
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.
Attachments
Issue Links
- relates to
-
-
- Open
-