diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/truncate_inject.result')
-rw-r--r-- | mysql-test/suite/innodb/r/truncate_inject.result | 114 |
1 files changed, 0 insertions, 114 deletions
diff --git a/mysql-test/suite/innodb/r/truncate_inject.result b/mysql-test/suite/innodb/r/truncate_inject.result deleted file mode 100644 index f69013172cd..00000000000 --- a/mysql-test/suite/innodb/r/truncate_inject.result +++ /dev/null @@ -1,114 +0,0 @@ -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; |