Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug14147491.result

raw
1 # Ensure that purge will not crash on the table after we corrupt it.
2 SET GLOBAL innodb_fast_shutdown=0;
3 # Create and populate the table to be corrupted
4 CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) ENGINE=InnoDB;
5 INSERT INTO t1 (b) VALUES ('corrupt me');
6 INSERT INTO t1 (b) VALUES ('corrupt me');
7 # Corrupt the table
8 Munged a string.
9 Munged a string.
10 # restart
11 # Now t1 is corrupted but we should not crash
12 SELECT * FROM t1;
13 Got one of the listed errors
14 INSERT INTO t1(b) VALUES('abcdef');
15 Got one of the listed errors
16 UPDATE t1 set b = 'deadbeef' where a = 1;
17 Got one of the listed errors
18 # Cleanup, this must be possible
19 DROP TABLE t1;