[MDEV-13508] ALTER TABLE that renames columns and CHECK constraints - Jira

XML

Word

Printable

If a column is renamed, CHECK constraint isn't changed to use the new column name. But UNIQUE constraint is.

create table t1 (a int, b int, check(a>b));

alter table t1 change column a b int, change column b a int;

show create table t1;

Compare with

create table t1 (a int, b int, unique(a,b));

alter table t1 change column a b int, change column b a int;

show create table t1;

is duplicated by

MDEV-16161 Syntax error reserverd keyword

relates to

MDEV-11114 Cannot drop column referenced by CHECK constraint

MDEV-22881 Unexpected errors, corrupt output, Valgrind / ASAN errors in Item_ident::print or append_identifier

Estimated:

Not Specified

Remaining:

Logged:

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