SET @save_dbug = @@SESSION.debug_dbug;
call mtr.add_suppression("InnoDB: Flagged corruption of .* in table `test`\\.`t` in TRUNCATE TABLE");
# 1. Error in assigning undo logs for truncate action
CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), INDEX ck(c))
ENGINE = InnoDB;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
SET @@SESSION.debug_dbug = '+d,ib_err_trunc_assigning_undo_log';
truncate table t;
ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB
SET @@SESSION.debug_dbug = @save_dbug;
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
# 2. Error while preparing for truncate
SET @@SESSION.debug_dbug = '+d,ib_err_trunc_preparing_for_truncate';
truncate table t;
ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB
SET @@SESSION.debug_dbug = @save_dbug;
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
1	1.1	a
2	2.2	b
3	3.3	c
# 3. Error while dropping/creating indexes
SET @@SESSION.debug_dbug = '+d,ib_err_trunc_drop_index';
truncate table t;
ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB
SET @@SESSION.debug_dbug = @save_dbug;
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	Warning	InnoDB: Index PRIMARY is marked as corrupted
test.t	check	error	Corrupt
select * from t;
Got one of the listed errors
drop table t;
CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), INDEX ck(c))
ENGINE = InnoDB;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
SET @@SESSION.debug_dbug = '+d,ib_err_trunc_create_index';
truncate table t;
ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB
SET @@SESSION.debug_dbug = @save_dbug;
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	Warning	InnoDB: Index PRIMARY is marked as corrupted
test.t	check	error	Corrupt
select * from t;
Got one of the listed errors
drop table t;
CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), INDEX ck(c))
ENGINE = InnoDB;
insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
SET @@SESSION.debug_dbug = '+d,ib_err_trunc_temp_recreate_index';
truncate table t;
SET @@SESSION.debug_dbug = @save_dbug;
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
drop table t;
# 4. Error while completing truncate of table involving FTS
CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100),
FULLTEXT INDEX(c)) ENGINE = InnoDB;
insert into t values (1, 1.1, 'mysql is now oracle company'),
(2, 2.2, 'innodb is part of mysql'),
(3, 3.3, 'innodb is default storage engine of mysql');
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
SET @@SESSION.debug_dbug = '+d,ib_err_trunc_temp_recreate_index';
truncate table t;
SET @@SESSION.debug_dbug = @save_dbug;
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t;
i	f	c
drop table t;
# 5. Error while updating sys-tables
CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100),
FULLTEXT INDEX(c)) ENGINE = InnoDB;
insert into t values (1, 1.1, 'mysql is now oracle company'),
(2, 2.2, 'innodb is part of mysql'),
(3, 3.3, 'innodb is default storage engine of mysql');
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
SET @@SESSION.debug_dbug = '+d,ib_err_trunc_temp_recreate_index';
truncate table t;
SET @@SESSION.debug_dbug = @save_dbug;
check table t;
Table	Op	Msg_type	Msg_text
test.t	check	status	OK
select * from t order by i;
i	f	c
drop table t;