Debian Codegraph @

mysql-test/suite/innodb_undo/r/undo_tablespace_encrypt.result

raw
1 #
2 # Bug #29492911 : ENABLING UNDO-TABLESPACE ENCRYPTION DOESN'T MARK TABLESPACE ENCRYPTION FLAG
3 #
4 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
5 Variable_name Value
6 innodb_undo_log_encrypt OFF
7 ###############################################################################
8 # With keyring plugin and innodb_undo_log_encrypt=ON
9 ###############################################################################
10 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
11 Variable_name Value
12 innodb_undo_log_encrypt ON
13 # Create a new UNDO tablespace. Should be created as ENCRYPTED.
14 CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu';
15 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
16 NAME SPACE_TYPE ENCRYPTION STATE
17 innodb_undo_001 Undo Y active
18 innodb_undo_002 Undo Y active
19 undo_3 Undo Y active
20 SET GLOBAL innodb_undo_log_encrypt=OFF;
21 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
22 Variable_name Value
23 innodb_undo_log_encrypt OFF
24 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
25 NAME SPACE_TYPE ENCRYPTION STATE
26 innodb_undo_001 Undo N active
27 innodb_undo_002 Undo N active
28 undo_3 Undo N active
29 # Create a new UNDO tablespace. Should be created as UNENCRYPTED.
30 CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu';
31 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
32 NAME SPACE_TYPE ENCRYPTION STATE
33 innodb_undo_001 Undo N active
34 innodb_undo_002 Undo N active
35 undo_3 Undo N active
36 undo_4 Undo N active
37 SET GLOBAL innodb_undo_log_encrypt=ON;
38 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
39 Variable_name Value
40 innodb_undo_log_encrypt ON
41 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
42 NAME SPACE_TYPE ENCRYPTION STATE
43 innodb_undo_001 Undo Y active
44 innodb_undo_002 Undo Y active
45 undo_3 Undo Y active
46 undo_4 Undo Y active
47 ###############################################################################
48 # With keyring plugin and innodb_undo_log_encrypt=OFF
49 ###############################################################################
50 ALTER UNDO TABLESPACE undo_3 set INACTIVE;
51 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
52 NAME SPACE_TYPE ENCRYPTION STATE
53 innodb_undo_001 Undo N active
54 innodb_undo_002 Undo N active
55 undo_3 Undo N inactive
56 undo_4 Undo N active
57 DROP UNDO TABLESPACE undo_3;
58 ALTER UNDO TABLESPACE undo_4 set INACTIVE;
59 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
60 NAME SPACE_TYPE ENCRYPTION STATE
61 innodb_undo_001 Undo N active
62 innodb_undo_002 Undo N active
63 undo_4 Undo N inactive
64 DROP UNDO TABLESPACE undo_4;
65 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
66 NAME SPACE_TYPE ENCRYPTION STATE
67 innodb_undo_001 Undo N active
68 innodb_undo_002 Undo N active
69 # Reset to initial state
70 # restart: