[#MDEV-28117] Multiple conflicting table COLLATE clauses are not rejected

The problem described in ~~MDEV-28067~~ is also repeatable on the table level:

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 |

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

The expected behaviour would be to return a "conflicting declarations" error.

The problem is also repeatable on the database level:

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)

[MDEV-28117] Multiple conflicting table COLLATE clauses are not rejected Created: 2022-03-18 Updated: 2022-06-15 Resolved: 2022-06-03
Status:	Closed
Project:	MariaDB Server
Component/s:	Character Sets
Affects Version/s:	10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
Fix Version/s:	10.9.2