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

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.9.2
Component/s: Character Sets
Labels:
None

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)

relates to

MDEV-27743 Remove Lex::charset

MDEV-27782 Wrong columns when using table level `CHARACTER SET utf8mb4 COLLATE DEFAULT`

MDEV-28067 Multiple conflicting column COLLATE clauses are not rejected

MDEV-28644 Unexpected error on ALTER TABLE t1 CONVERT TO CHARACTER SET utf8mb3, DEFAULT CHARACTER SET utf8mb4

MDEV-27906 CREATE TABLE/DATABASE .. CHARSET .. COLLATE is not consistent on errors

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.