Debian Codegraph @

mysql-test/suite/innodb/t/import_tablespace_page_corrupt.test

raw
1 #
2 #Bug #29454828 ASSERTION ON IMPORT VIA TRANSPORTABLE TABLESPACE
3 #
4 --source include/have_debug.inc
5 --let $MYSQLD_DATADIR=`select @@datadir`
6 --let $DB = `SELECT DATABASE()`
7
8 CREATE TABLE t1(f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INT, f3 CHAR, f4 TEXT)
9 ENGINE=InnoDB;
10 --let $inserts= 2000
11 --disable_query_log
12 while ($inserts)
13 {
14 INSERT INTO t1(f2,f3,f4) VALUES(mod(floor(rand() * 100000),99969),
15 char(65 + mod(floor(rand() * 27),26)),
16 repeat(char(65 + mod(floor(rand() * 27),26)),
17 mod(floor(rand() * 200),+100) + 1));
18 --dec $inserts
19 }
20 --enable_query_log
21
22 DELETE FROM t1 WHERE f1%2=0;
23
24 FLUSH TABLES t1 FOR EXPORT;
25 --copy_file $MYSQLD_DATADIR/$DB/t1.ibd $MYSQL_TMP_DIR/t1.ibd
26 --copy_file $MYSQLD_DATADIR/$DB/t1.cfg $MYSQL_TMP_DIR/t1.cfg
27
28 UNLOCK TABLES;
29 DROP TABLE t1;
30 CREATE TABLE t1(f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INT, f3 CHAR, f4 TEXT)
31 ENGINE=InnoDB;
32 ALTER TABLE t1 DISCARD TABLESPACE;
33 --move_file $MYSQL_TMP_DIR/t1.ibd $MYSQLD_DATADIR/$DB/t1.ibd
34 --move_file $MYSQL_TMP_DIR/t1.cfg $MYSQLD_DATADIR/$DB/t1.cfg
35
36 SET SESSION debug="+d,ib_import_page_corrupt";
37 --error ER_TABLE_CORRUPT
38 ALTER TABLE t1 IMPORT TABLESPACE;
39 SET SESSION debug="-d,ib_import_page_corrupt";
40 DROP TABLE t1;
41 --remove_file $MYSQLD_DATADIR/$DB/t1.ibd