COALESCE(12345678900) makes a column of a wrong type and truncates the data

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 AS SELECT 12345678900 AS c1, COALESCE(12345678900) AS c2;

SELECT * FROM t1;

SHOW CREATE TABLE t1;

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

| c1          | c2         |

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

| 12345678900 | 2147483647 |

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

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

| Table | Create Table                                                                                                   |

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

| t1    | CREATE TABLE `t1` (

  `c1` bigint(11) NOT NULL,

  `c2` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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