|
If I specify mutiple conflicting COLLATE clauses on the column level, no error is raised:
CREATE OR REPLACE TABLE t1 (a CHAR(10) COLLATE latin1_swedish_ci NOT NULL COLLATE latin1_bin);
|
SHOW CREATE TABLE t1;
|
+-------+----------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` char(10) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------+
|
Notice, the first COLLATE was ignored, the last COLLATE was used.
The same problem is repeatable on the table level. See MDEV-28117.
|