| 1 |
--source include/have_innodb.inc |
| 2 |
--source include/have_example_key_management_plugin.inc |
| 3 |
|
| 4 |
call mtr.add_suppression("InnoDB: .*: Page 0 at offset 0 looks corrupted"); |
| 5 |
call mtr.add_suppression("Index for table 'dst' is corrupt; try to repair it"); |
| 6 |
call mtr.add_suppression("Page for tablespace .* is index page with id .* but that index is not found from configuration file"); |
| 7 |
|
| 8 |
let MYSQLD_DATADIR = `SELECT @@datadir`; |
| 9 |
|
| 10 |
|
| 11 |
CREATE TABLE src (pk INT PRIMARY KEY, value INT) ENGINE=INNODB; |
| 12 |
INSERT INTO src VALUES (1, 1), (2, 2), (3, 3); |
| 13 |
|
| 14 |
FLUSH TABLES src FOR EXPORT; |
| 15 |
|
| 16 |
--copy_file $MYSQLD_DATADIR/test/src.ibd $MYSQLD_DATADIR/test/tmp.ibd |
| 17 |
--copy_file $MYSQLD_DATADIR/test/src.cfg $MYSQLD_DATADIR/test/tmp.cfg |
| 18 |
|
| 19 |
perl; |
| 20 |
use strict; |
| 21 |
die unless open(FILE, "+<$ENV{MYSQLD_DATADIR}/test/tmp.ibd"); |
| 22 |
binmode FILE; |
| 23 |
die unless seek(FILE, 3 * 16384 + 26, 0); |
| 24 |
print FILE pack("N", 0x00000000); |
| 25 |
close(FILE); |
| 26 |
EOF |
| 27 |
|
| 28 |
UNLOCK TABLES; |
| 29 |
|
| 30 |
DROP TABLE src; |
| 31 |
|
| 32 |
CREATE TABLE dst (pk INT PRIMARY KEY, value INT) ENGINE=INNODB; |
| 33 |
ALTER TABLE dst DISCARD TABLESPACE; |
| 34 |
|
| 35 |
--copy_file $MYSQLD_DATADIR/test/tmp.ibd $MYSQLD_DATADIR/test/dst.ibd |
| 36 |
--copy_file $MYSQLD_DATADIR/test/tmp.cfg $MYSQLD_DATADIR/test/dst.cfg |
| 37 |
|
| 38 |
--error ER_NOT_KEYFILE |
| 39 |
ALTER TABLE dst IMPORT TABLESPACE; |
| 40 |
|
| 41 |
DROP TABLE dst; |
| 42 |
|
| 43 |
--remove_file $MYSQLD_DATADIR/test/tmp.ibd |
| 44 |
--remove_file $MYSQLD_DATADIR/test/tmp.cfg |