CALL mtr.add_suppression(".*rename dictionary error*");
create table t1(id int auto_increment primary key, c1 int) engine=xengine;
insert into t1 values(1,1),(2,1),(3,1),(4,1),(5,1);
select count(*) from t1;
count(*)
5
set session debug = 'd+, ddl_log_inject_rollback_rename_process';
alter table t1 rename to t2;
ERROR HY000: Error on rename of './test/t1' to './test/t2' (errno: 122 - Internal (unspecified) error in handler)
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
show create table t2;
ERROR 42S02: Table 'test.t2' doesn't exist
select * from t1;
id	c1
1	1
2	1
3	1
4	1
5	1
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
drop table t1;
create table t1(id int primary key, c1 int) engine=xengine;
create table t2(id int primary key, c1 int) engine=xengine;
create table t3(id int primary key, c1 int) engine=xengine;
set session debug = 'd+, ddl_log_crash_delete_funcs';
drop table t1,t2,t3;;
Got one of the listed errors
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
show create table t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t2;
Table	Op	Msg_type	Msg_text
test.t2	check	status	OK
show create table t3;
Table	Create Table
t3	CREATE TABLE `t3` (
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t3;
Table	Op	Msg_type	Msg_text
test.t3	check	status	OK
drop table t1,t2,t3;
create table t1(id int primary key) engine=xengine;
insert into t1 values(1),(2);
create table t2(id int primary key, c1 int) engine=xengine;
insert into t2 values(1,1),(2,2),(3,3);
set session debug = 'd+, ddl_log_crash_rename_funcs';
rename table t1 to t1_tmp, t2 to t1, t1_tmp to t2;;
Got one of the listed errors
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
select * from t1;
id
1
2
show create table t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t2;
Table	Op	Msg_type	Msg_text
test.t2	check	status	OK
select * from t2;
id	c1
1	1
2	2
3	3
rename table t1 to t1_tmp, t2 to t1, t1_tmp to t2;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
select * from t1;
id	c1
1	1
2	2
3	3
show create table t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t2;
Table	Op	Msg_type	Msg_text
test.t2	check	status	OK
select * from t2;
id
1
2
drop table t1,t2;
create table t1(id int primary key, c1 int, c2 int) engine=xengine;
alter table t1 add index idx_c1(c1), add index idx_c2(c2);
set session debug = 'd+, ddl_log_crash_replay_funcs';
alter table t1 drop column c2, ALGORITHM=COPY;
Got one of the listed errors
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_c1` (`c1`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
select * from t1;
id	c1
drop table t1;
create table t1(id int primary key, c1 int, c2 int) engine=xengine;
insert into t1 values(1,1,1),(2,2,2),(3,3,3);
alter table t1 add index idx_c1(c1), add index idx_c2(c2);
alter table t1 drop column c2, ALGORITHM=INPLACE;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `c1` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_c1` (`c1`)
) ENGINE=XENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
select * from t1;
id	c1
1	1
2	2
3	3
drop table t1;