[MDEV-27690] Crash on `CHARACTER SET csname COLLATE DEFAULT` in column definition - 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)
Fix Version/s: 10.7.4, 10.2.44, 10.3.35, 10.5.16, 10.6.8, 10.8.3
Component/s: Character Sets
Labels:
None

These statements crash the server:

CREATE OR REPLACE TABLE t1 (a CHAR(10) CHARACTER SET latin1 COLLATE DEFAULT);

CREATE OR REPLACE TABLE t1 (a CHAR(10) CHARACTER SET utf8mb4 COLLATE DEFAULT);

Note, this statements do not:

CREATE OR REPLACE TABLE t1 (a CHAR(10)) CHARACTER SET utf8mb4 COLLATE DEFAULT;

CREATE OR REPLACE TABLE t1 (a CHAR(10)) CHARACTER SET latin1 COLLATE DEFAULT;

But they can produce a wrong table. See ~~MDEV-27782~~.

relates to

MDEV-27009 Add UCA-14.0.0 collations

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

MDEV-27743 Remove Lex::charset

MDEV-27853 Wrong data type on column `COLLATE DEFAULT` and table `COLLATE some_non_default_collation`

MDEV-28067 Multiple conflicting column COLLATE clauses are not rejected

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