| 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 |