CREATE TABLE t1 (<defs>) SELECT... does not preserve new CHECK constraint

DROP TABLE IF EXISTS t1,t2;

CREATE TABLE t1 (a INT CHECK(a=1));

CREATE TABLE t2 (a INT CHECK(a=2)) AS SELECT * FROM t1;

SHOW CREATE TABLE t2;

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

| Table | Create Table                                                                                          |

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

| t2    | CREATE TABLE `t2` (

  `a` int(11) DEFAULT NULL CHECK (`a` = 1)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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