Debian Codegraph @

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

raw
1 CREATE TABLE t1 (f1 INT, f2 VARCHAR(256))engine=innodb;
2 INSERT INTO t1 VALUES(1, 'MariaDB'), (2, 'Robot'), (3, 'Science');
3 INSERT INTO t1 SELECT * FROM t1;
4 CREATE TABLE t2(f1 INT, f2 VARCHAR(256))engine=innodb;
5 INSERT INTO t2 SELECT * FROM t1;
6 CREATE TABLE t3(f1 INT, f2 VARCHAR(256))engine=innodb encrypted=yes;
7 INSERT INTO t3 SELECT * FROM t1;
8 # Restart the server with encryption
9 # Wait until encryption threads have encrypted all tablespaces
10 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
11 NAME
12 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
13 NAME
14 innodb_system
15 mysql/innodb_index_stats
16 mysql/innodb_table_stats
17 mysql/transaction_registry
18 test/t1
19 test/t2
20 test/t3
21 # Restart the server with innodb_encryption_rotate_key_age= 0
22 create table t4 (f1 int not null)engine=innodb encrypted=NO;
23 # Wait until encryption threads have encrypted all tablespaces
24 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
25 NAME
26 test/t4
27 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
28 NAME
29 innodb_system
30 mysql/innodb_index_stats
31 mysql/innodb_table_stats
32 mysql/transaction_registry
33 test/t1
34 test/t2
35 test/t3
36 # Disable encryption when innodb_encryption_rotate_key_age is 0
37 set global innodb_encrypt_tables = OFF;
38 # Wait until encryption threads to decrypt all unencrypted tablespaces
39 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
40 NAME
41 innodb_system
42 mysql/innodb_index_stats
43 mysql/innodb_table_stats
44 mysql/transaction_registry
45 test/t1
46 test/t2
47 test/t4
48 # Display only encrypted create tables (t3)
49 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
50 NAME
51 test/t3
52 # Enable encryption when innodb_encryption_rotate_key_age is 0
53 set global innodb_encrypt_tables = ON;
54 # Wait until encryption threads to encrypt all unencrypted tablespaces
55 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
56 NAME
57 test/t4
58 # Display only unencrypted create tables (t4)
59 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
60 NAME
61 innodb_system
62 mysql/innodb_index_stats
63 mysql/innodb_table_stats
64 mysql/transaction_registry
65 test/t1
66 test/t2
67 test/t3
68 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
69 NAME
70 test/t4
71 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
72 NAME
73 innodb_system
74 mysql/innodb_index_stats
75 mysql/innodb_table_stats
76 mysql/transaction_registry
77 test/t1
78 test/t2
79 test/t3
80 DROP TABLE t4, t3, t2, t1;