Debian Codegraph @

mysql-test/suite/innodb/r/dblwr_disable.result

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