Debian Codegraph @

mysql-test/suite/encryption/r/innodb-encryption-disable.result

raw
1 call mtr.add_suppression("Table `test`\\.`t[15]` (has an unreadable root page|is corrupted)");
2 call mtr.add_suppression("InnoDB: The page \\[page id: space=[1-9][0-9]*, page number=[1-9][0-9]*\\] in file '.*test.t[15]\\.ibd' cannot be decrypted\\.");
3 call mtr.add_suppression("InnoDB: Recovery failed to read page");
4 call mtr.add_suppression("InnoDB: Encrypted page \\[page id: space=[1-9][0-9]*, page number=3\\] in file .*test.t[15].ibd looks corrupted; key_version=1");
5 call mtr.add_suppression("InnoDB: Failed to read page 3 from file '.*test/t[15]\\.ibd'");
6 call mtr.add_suppression("InnoDB: File '.*test/t[15]\\.ibd' is corrupted");
7 call mtr.add_suppression("Couldn't load plugins from 'file_key_management");
8 # restart: --innodb-encrypt-tables=ON --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt
9 create table t5 (
10 `intcol1` int(32) DEFAULT NULL,
11 `intcol2` int(32) DEFAULT NULL,
12 `charcol1` varchar(128) DEFAULT NULL,
13 `charcol2` varchar(128) DEFAULT NULL,
14 `charcol3` varchar(128) DEFAULT NULL
15 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16 insert into t5 values (1,2,'maria','db','encryption');
17 CREATE TABLE `t1` (
18 `intcol1` int(32) DEFAULT NULL,
19 `intcol2` int(32) DEFAULT NULL,
20 `charcol1` varchar(128) DEFAULT NULL,
21 `charcol2` varchar(128) DEFAULT NULL,
22 `charcol3` varchar(128) DEFAULT NULL
23 ) ENGINE=InnoDB;
24 insert into t1 values (1,2,'maria','db','encryption');
25 alter table t1 encrypted='yes' `encryption_key_id`=1;
26 # restart: --innodb-encrypt-tables=OFF
27 select * from t1;
28 ERROR HY000: Table `test`.`t1` is corrupted. Please drop the table and recreate.
29 select * from t5;
30 ERROR HY000: Table `test`.`t5` is corrupted. Please drop the table and recreate.
31 # restart: --innodb-encrypt-tables=ON --plugin-load-add=file_key_management --file-key-management --file-key-management-filename=MYSQL_TEST_DIR/std_data/keys2.txt
32 drop table t1;
33 drop table t5;