Debian Codegraph @

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

raw
1 call mtr.add_suppression("Table `test`.`t2` should have 2 indexes but the tablespace has 1 indexes");
2 call mtr.add_suppression("Index for table 't2' is corrupt; try to repair it");
3 call mtr.add_suppression("Trying to read .* bytes at .* outside the bounds of the file: \\..test.t2\\.ibd");
4 call mtr.add_suppression("InnoDB: File '.*test/t2\\.ibd' is corrupted");
5 CREATE TABLE t1 (
6 id INT AUTO_INCREMENT PRIMARY KEY,
7 not_id INT,
8 data CHAR(255),
9 data2 BLOB
10 ) ENGINE=INNODB;
11 ALTER TABLE t1 MODIFY not_id INT UNIQUE KEY;
12 connect purge_control,localhost,root,,;
13 START TRANSACTION WITH CONSISTENT SNAPSHOT;
14 connection default;
15 DELETE FROM t1 WHERE id % 2 = 1;
16 FLUSH TABLES t1 FOR EXPORT;
17 UNLOCK TABLES;
18 connection purge_control;
19 COMMIT;
20 connection default;
21 DROP TABLE t1;
22 CREATE TABLE t2 (
23 id INT AUTO_INCREMENT PRIMARY KEY,
24 not_id INT UNIQUE KEY,
25 data CHAR(255),
26 data2 BLOB
27 ) ENGINE=INNODB;
28 ALTER TABLE t2 DISCARD TABLESPACE;
29 ALTER TABLE t2 IMPORT TABLESPACE;
30 ERROR HY000: Index for table 't2' is corrupt; try to repair it
31 DROP TABLE t2;