Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2 --let $MYSQLD_DATADIR=`select @@datadir`
3 --let $DB = `SELECT DATABASE()`
4
5 select @@binlog_encryption;
6 select @@innodb_redo_log_encrypt;
7 select @@innodb_undo_log_encrypt;
8
9 create table t1 (f1 int, f2 blob) ENCRYPTION='Y';
10
11 show create table t1;
12
13 START TRANSACTION;
14
15 INSERT INTO t1 VALUES(1, repeat('#',12));
16 INSERT INTO t1 VALUES(2, repeat('+',12));
17 INSERT INTO t1 VALUES(3, repeat('/',12));
18 INSERT INTO t1 VALUES(4, repeat('-',12));
19 INSERT INTO t1 VALUES(5, repeat('.',12));
20
21 COMMIT WORK;
22
23 --echo # Ensure that dirty pages of table t1 is flushed.
24 FLUSH TABLES t1 FOR EXPORT;
25 UNLOCK TABLES;
26
27 --source include/kill_and_restart_mysqld.inc
28
29 select 2;
30
31 SET SESSION innodb_interpreter = 'init';
32 SET SESSION innodb_interpreter = 'print_dblwr_has_encrypted_pages';
33 SET SESSION innodb_interpreter = 'destroy';
34
35 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
36 let SEARCH_PATTERN= Double write file has encrypted pages;
37 --source include/search_pattern.inc
38
39 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
40 let SEARCH_PATTERN= \\[Note\\] \\[MY-\\d+\\] \\[InnoDB\\] Recovered page \\[page id: space=\\d+, page number=\\d+\\] from the doublewrite buffer;
41 --source include/search_pattern.inc
42
43
44 DROP TABLE t1;
45 --echo # Test End