Multiple conflicting table COLLATE clauses are not rejected

CREATE OR REPLACE TABLE t1 (a CHAR(10)) COLLATE latin1_swedish_ci COLLATE latin1_bin;

SHOW CREATE TABLE t1;

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

| Table | Create Table                                                                                                                 |

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

| t1    | CREATE TABLE `t1` (

  `a` char(10) COLLATE latin1_bin DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin |

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

CREATE OR REPLACE database db1 COLLATE latin1_swedish_ci COLLATE latin1_bin;

SHOW CREATE DATABASE db1;

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

| Database | Create Database                                                                   |

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

| db1      | CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_bin */ |

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

1 row in set (0.001 sec)