Debian Codegraph @

mysql-test/suite/encryption/t/encryption_key_corruption.test

raw
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