Debian Codegraph @

mysql-test/suite/encryption/r/debug_key_management.result

raw
1 call mtr.add_suppression("InnoDB: Encrypted page \\[page id: space=[1-9][0-9]*, page number=[0-9]*\\] in file");
2 create table t1(a serial) engine=innoDB;
3 set global innodb_encrypt_tables=ON;
4 show variables like 'innodb_encrypt%';
5 Variable_name Value
6 innodb_encrypt_log ON
7 innodb_encrypt_tables ON
8 innodb_encrypt_temporary_tables OFF
9 innodb_encryption_rotate_key_age 2
10 innodb_encryption_rotation_iops 100
11 innodb_encryption_threads 4
12 select count(*) from information_schema.innodb_tablespaces_encryption where current_key_version <> 1;
13 count(*)
14 0
15 set global debug_key_management_version=10;
16 select count(*) from information_schema.innodb_tablespaces_encryption where current_key_version <> 10;
17 count(*)
18 0
19 SET GLOBAL innodb_log_checkpoint_now = 1;
20 SET GLOBAL innodb_flush_log_at_trx_commit = 1;
21 INSERT INTO t1 VALUES(NULL);
22 # restart
23 set global innodb_encrypt_tables=OFF;
24 set global debug_key_management_version=1;
25 select * from t1;
26 a
27 1
28 drop table t1;