MariaDB 10.2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE g (b bigint)
  AS 
SELECT 2147483699 AS b UNION ALL
SELECT '2147483699' ;
SELECT *
FROM g ;

b

2147483699

2147483699

show create table g ;

Table
Create Table

g
CREATE TABLE `g` (
  `b` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

select @@version ;

@@version

10.2.12-MariaDB-10.2.12+maria~jessie-log