Debian Codegraph @

mysql-test/suite/component_keyring_file/r/log_encrypt_3.result

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating local configuration file for keyring component: component_keyring_file
4 # Creating manifest file for current MySQL server instance
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # Kill the server
8 CREATE DATABASE tde_db;
9 USE tde_db;
10 # Kill the server
11 SELECT @@global.innodb_redo_log_encrypt ;
12 @@global.innodb_redo_log_encrypt
13 1
14 SET GLOBAL innodb_redo_log_encrypt = 1;
15 SELECT @@global.innodb_redo_log_encrypt ;
16 @@global.innodb_redo_log_encrypt
17 1
18 CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
19 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
20 SELECT a,LEFT(b,10) FROM tde_db.t1;
21 a LEFT(b,10)
22 1 aaaaaaaaaa
23 CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
24 ENCRYPTION='Y' ENGINE=InnoDB;
25 INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
26 SELECT a,LEFT(b,10) FROM tde_db.t2;
27 a LEFT(b,10)
28 1 aaaaaaaaaa
29 SET GLOBAL innodb_redo_log_encrypt = 0;
30 SELECT @@global.innodb_redo_log_encrypt ;
31 @@global.innodb_redo_log_encrypt
32 0
33 CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
34 INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
35 SELECT a,LEFT(b,10) FROM tde_db.t3;
36 a LEFT(b,10)
37 1 aaaaaaaaaa
38 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
39 ENCRYPTION='Y' ENGINE=InnoDB;
40 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
41 SELECT a,LEFT(b,10) FROM tde_db.t4;
42 a LEFT(b,10)
43 1 aaaaaaaaaa
44 FLUSH LOGS;
45 # Kill the server
46 SELECT a,LEFT(b,10) FROM tde_db.t1;
47 a LEFT(b,10)
48 1 aaaaaaaaaa
49 SELECT a,LEFT(b,10) FROM tde_db.t2;
50 a LEFT(b,10)
51 1 aaaaaaaaaa
52 SELECT a,LEFT(b,10) FROM tde_db.t3;
53 a LEFT(b,10)
54 1 aaaaaaaaaa
55 SELECT a,LEFT(b,10) FROM tde_db.t4;
56 a LEFT(b,10)
57 1 aaaaaaaaaa
58 DROP TABLE tde_db.t1,tde_db.t2,tde_db.t3,tde_db.t4;
59 SELECT @@global.innodb_redo_log_encrypt ;
60 @@global.innodb_redo_log_encrypt
61 1
62 CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
63 CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
64 ENCRYPTION='Y' ENGINE=InnoDB;
65 START TRANSACTION;
66 SET GLOBAL innodb_redo_log_encrypt = 1;
67 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
68 INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
69 SELECT a,LEFT(b,10) FROM tde_db.t1;
70 a LEFT(b,10)
71 1 aaaaaaaaaa
72 SELECT a,LEFT(b,10) FROM tde_db.t2;
73 a LEFT(b,10)
74 1 aaaaaaaaaa
75 ROLLBACK;
76 START TRANSACTION;
77 INSERT INTO t1 (a, b) VALUES (2, REPEAT('a', 6*512*512));
78 INSERT INTO t2 (a, b) VALUES (2, REPEAT('a', 6*512*512));
79 SELECT a,LEFT(b,10) FROM tde_db.t1;
80 a LEFT(b,10)
81 2 aaaaaaaaaa
82 SELECT a,LEFT(b,10) FROM tde_db.t2;
83 a LEFT(b,10)
84 2 aaaaaaaaaa
85 COMMIT;
86 CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
87 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
88 ENCRYPTION='Y' ENGINE=InnoDB;
89 START TRANSACTION;
90 SET GLOBAL innodb_redo_log_encrypt = 0;
91 SELECT @@global.innodb_redo_log_encrypt ;
92 @@global.innodb_redo_log_encrypt
93 0
94 INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
95 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
96 SELECT a,LEFT(b,10) FROM tde_db.t3;
97 a LEFT(b,10)
98 1 aaaaaaaaaa
99 SELECT a,LEFT(b,10) FROM tde_db.t4;
100 a LEFT(b,10)
101 1 aaaaaaaaaa
102 ROLLBACK;
103 START TRANSACTION;
104 INSERT INTO t3 (a, b) VALUES (2, REPEAT('a', 6*512*512));
105 INSERT INTO t4 (a, b) VALUES (2, REPEAT('a', 6*512*512));
106 SELECT a,LEFT(b,10) FROM tde_db.t3;
107 a LEFT(b,10)
108 2 aaaaaaaaaa
109 SELECT a,LEFT(b,10) FROM tde_db.t4;
110 a LEFT(b,10)
111 2 aaaaaaaaaa
112 COMMIT;
113 # Kill the server
114 SELECT a,LEFT(b,10) FROM tde_db.t1;
115 a LEFT(b,10)
116 2 aaaaaaaaaa
117 SELECT a,LEFT(b,10) FROM tde_db.t2;
118 a LEFT(b,10)
119 2 aaaaaaaaaa
120 SELECT a,LEFT(b,10) FROM tde_db.t3;
121 a LEFT(b,10)
122 2 aaaaaaaaaa
123 SELECT a,LEFT(b,10) FROM tde_db.t4;
124 a LEFT(b,10)
125 2 aaaaaaaaaa
126 SET GLOBAL innodb_redo_log_encrypt = 0;
127 SELECT @@global.innodb_redo_log_encrypt ;
128 @@global.innodb_redo_log_encrypt
129 0
130 ALTER INSTANCE ROTATE INNODB MASTER KEY;
131 SELECT a,LEFT(b,10) FROM tde_db.t1;
132 a LEFT(b,10)
133 2 aaaaaaaaaa
134 SELECT a,LEFT(b,10) FROM tde_db.t2;
135 a LEFT(b,10)
136 2 aaaaaaaaaa
137 SELECT a,LEFT(b,10) FROM tde_db.t3;
138 a LEFT(b,10)
139 2 aaaaaaaaaa
140 SELECT a,LEFT(b,10) FROM tde_db.t4;
141 a LEFT(b,10)
142 2 aaaaaaaaaa
143 SET GLOBAL innodb_redo_log_encrypt = 1;
144 SELECT @@global.innodb_redo_log_encrypt ;
145 @@global.innodb_redo_log_encrypt
146 1
147 ALTER INSTANCE ROTATE INNODB MASTER KEY;
148 SELECT a,LEFT(b,10) FROM tde_db.t1;
149 a LEFT(b,10)
150 2 aaaaaaaaaa
151 SELECT a,LEFT(b,10) FROM tde_db.t2;
152 a LEFT(b,10)
153 2 aaaaaaaaaa
154 SELECT a,LEFT(b,10) FROM tde_db.t3;
155 a LEFT(b,10)
156 2 aaaaaaaaaa
157 SELECT a,LEFT(b,10) FROM tde_db.t4;
158 a LEFT(b,10)
159 2 aaaaaaaaaa
160 CREATE USER encryptnonprivuser@localhost IDENTIFIED BY 'noauth';
161 GRANT SELECT ON *.* to encryptnonprivuser@localhost;
162 FLUSH PRIVILEGES;
163 # In connection 1 - with encryptnonprivuser
164 SELECT @@global.innodb_redo_log_encrypt ;
165 @@global.innodb_redo_log_encrypt
166 1
167 SET GLOBAL innodb_redo_log_encrypt = 0;
168 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
169 SELECT @@global.innodb_redo_log_encrypt ;
170 @@global.innodb_redo_log_encrypt
171 1
172 SET GLOBAL innodb_undo_log_encrypt = 0;
173 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
174 SELECT @@global.innodb_undo_log_encrypt ;
175 @@global.innodb_undo_log_encrypt
176 0
177 SET GLOBAL innodb_redo_log_encrypt = 1;
178 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
179 SELECT @@global.innodb_redo_log_encrypt ;
180 @@global.innodb_redo_log_encrypt
181 1
182 SET GLOBAL innodb_undo_log_encrypt = 1;
183 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
184 SELECT @@global.innodb_undo_log_encrypt ;
185 @@global.innodb_undo_log_encrypt
186 0
187 # In connection default
188 DROP TABLE tde_db.t1,tde_db.t2,tde_db.t3,tde_db.t4;
189 # ----------------------------------------------------------------------
190 # Teardown
191 # Removing manifest file for current MySQL server instance
192 # Removing local keyring file for keyring component: component_keyring_file
193 # Removing local configuration file for keyring component: component_keyring_file
194 # Restarting server without the manifest file
195 # ----------------------------------------------------------------------