[MDEV-39776] SHOW CREATE TABLE corrupts `-quoted table options - Jira

XML

Word

Printable

e.g.

set sql_mode='ignore_bad_table_options';

create table t1 (a int) opt=`two words`;

show create table t1;

drop table t1;

the value of the option is a string "two words", but it's shown as

CREATE TABLE `t1` (

  `a` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci `opt`=two words

The second, related, problem is with embedded comment markers.

set sql_mode='ignore_bad_table_options';

create table t1 (a int) opt='foo*/bar';

set sql_mode='';

show create table t1;

drop table t1;

gets printed as

CREATE TABLE `t1` (

  `a` int(11) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci /* `opt`='foo*/bar' */

relates to

MDEV-40159 single quote in DATA DIRECTORY breaks SHOW CREATE TABLE

MDEV-39818 backtick in FK names breaks SHOW CREATE TABLE

links to

CVE-2026-86047

Estimated:

7.9h

Remaining:

Logged:

1d 0.5h

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