Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 --echo #
4 --echo # WL#13775: InnoDB: Encrypt DBLWR files
5 --echo #
6
7 create table t1 (f1 int primary key, f2 blob) ENCRYPTION='Y';
8
9 START TRANSACTION;
10 INSERT INTO t1 VALUES(1, repeat('#',12));
11 INSERT INTO t1 VALUES(2, repeat('+',12));
12 INSERT INTO t1 VALUES(3, repeat('/',12));
13 INSERT INTO t1 VALUES(4, repeat('-',12));
14 INSERT INTO t1 VALUES(5, repeat('.',12));
15 COMMIT WORK;
16
17 --echo # Ensure that dirty pages of table t1 is flushed.
18 FLUSH TABLES t1 FOR EXPORT;
19 UNLOCK TABLES;
20
21 SET SESSION innodb_interpreter = 'init';
22 SET SESSION innodb_interpreter = 'open_table test/t1';
23
24 --echo # Identify the space_id of the given table.
25 SET SESSION innodb_interpreter = 'find_space_id test/t1';
26 SELECT @@session.innodb_interpreter_output INTO @space_id;
27
28 --echo # Find the root page number of the given table.
29 SET SESSION innodb_interpreter = 'find_root_page_no test/t1';
30 SELECT @@session.innodb_interpreter_output INTO @page_no;
31
32 --echo # Find the on-disk page type of the given page.
33 SET @cmd = CONCAT('find_ondisk_page_type ', @space_id, ' ', @page_no);
34 SET SESSION innodb_interpreter = @cmd;
35 SELECT @@session.innodb_interpreter_output INTO @page_type;
36 SELECT @page_type;
37
38 set global innodb_interpreter = 'destroy';
39
40 drop table t1;