Storing '1e-1000000000000' into an INT column produces a wrong result

SET sql_mode='';

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a INT);

INSERT INTO t1 VALUES ('1e-1000000000000');

SHOW WARNINGS;

SELECT * FROM t1;

+---------+------+--------------------------------------------+

| 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)