Debian Codegraph @

mysql-test/suite/x/r/log_encrypt_xplugin.result

raw
1 # Stop the MTR default DB server
2 # create bootstrap file
3 # Prepare new datadir
4 # Run the bootstrap command with keyring
5 # Starting server with keyring plugin
6 SELECT @@global.innodb_redo_log_encrypt;
7 @@global.innodb_redo_log_encrypt
8 0
9 SELECT @@global.innodb_undo_log_encrypt;
10 @@global.innodb_undo_log_encrypt
11 0
12 CREATE USER 'x_root'@'localhost' IDENTIFIED WITH 'mysql_native_password';
13 GRANT ALL ON *.* TO 'x_root'@'localhost' WITH GRANT OPTION;
14 RUN SELECT @@global.innodb_redo_log_encrypt
15 @@global.innodb_redo_log_encrypt
16 0
17 0 rows affected
18 RUN SET GLOBAL innodb_redo_log_encrypt = 1
19
20 0 rows affected
21 RUN SELECT @@global.innodb_redo_log_encrypt
22 @@global.innodb_redo_log_encrypt
23 1
24 0 rows affected
25 RUN SET GLOBAL innodb_undo_log_encrypt = 1
26
27 0 rows affected
28 RUN SELECT @@global.innodb_undo_log_encrypt
29 @@global.innodb_undo_log_encrypt
30 1
31 0 rows affected
32 RUN DROP DATABASE IF EXISTS tde_db
33
34 0 rows affected
35 RUN CREATE DATABASE tde_db
36
37 1 rows affected
38 RUN USE tde_db
39
40 0 rows affected
41 RUN CREATE TABLE tde_db.t_encrypt(c2 INT NOT NULL,c3 LONGBLOB) ENCRYPTION="Y" ENGINE = InnoDB
42
43 0 rows affected
44 RUN CREATE TABLE tde_db.t_non_encrypt(c2 INT NOT NULL,c3 LONGBLOB ) ENGINE = InnoDB
45
46 0 rows affected
47 RUN START TRANSACTION
48
49 0 rows affected
50 RUN INSERT INTO tde_db.t_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
51
52 1 rows affected
53 RUN INSERT INTO tde_db.t_encrypt SELECT c2,c3 FROM tde_db.t_encrypt
54
55 1 rows affected
56 Records: 1 Duplicates: 0 Warnings: 0
57 RUN INSERT INTO tde_db.t_encrypt SELECT c2,c3 FROM tde_db.t_encrypt
58
59 2 rows affected
60 Records: 2 Duplicates: 0 Warnings: 0
61 RUN INSERT INTO tde_db.t_non_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
62
63 1 rows affected
64 RUN INSERT INTO tde_db.t_non_encrypt SELECT c2,c3 FROM tde_db.t_non_encrypt
65
66 1 rows affected
67 Records: 1 Duplicates: 0 Warnings: 0
68 RUN INSERT INTO tde_db.t_non_encrypt SELECT c2,c3 FROM tde_db.t_non_encrypt
69
70 2 rows affected
71 Records: 2 Duplicates: 0 Warnings: 0
72 RUN COMMIT
73
74 0 rows affected
75 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_encrypt
76 c2 SUBSTRING(c3,1,10)
77 1 aaaaaaaaaa
78 1 aaaaaaaaaa
79 1 aaaaaaaaaa
80 1 aaaaaaaaaa
81 0 rows affected
82 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_non_encrypt
83 c2 SUBSTRING(c3,1,10)
84 1 aaaaaaaaaa
85 1 aaaaaaaaaa
86 1 aaaaaaaaaa
87 1 aaaaaaaaaa
88 0 rows affected
89 RUN START TRANSACTION
90
91 0 rows affected
92 RUN INSERT INTO tde_db.t_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
93
94 1 rows affected
95 RUN INSERT INTO tde_db.t_encrypt SELECT c2,c3 FROM tde_db.t_encrypt
96
97 5 rows affected
98 Records: 5 Duplicates: 0 Warnings: 0
99 RUN INSERT INTO tde_db.t_encrypt SELECT c2,c3 FROM tde_db.t_encrypt
100
101 10 rows affected
102 Records: 10 Duplicates: 0 Warnings: 0
103 RUN INSERT INTO tde_db.t_non_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
104
105 1 rows affected
106 RUN INSERT INTO tde_db.t_non_encrypt SELECT c2,c3 FROM tde_db.t_non_encrypt
107
108 5 rows affected
109 Records: 5 Duplicates: 0 Warnings: 0
110 RUN INSERT INTO tde_db.t_non_encrypt SELECT c2,c3 FROM tde_db.t_non_encrypt
111
112 10 rows affected
113 Records: 10 Duplicates: 0 Warnings: 0
114 RUN ROLLBACK
115
116 0 rows affected
117 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_encrypt
118 c2 SUBSTRING(c3,1,10)
119 1 aaaaaaaaaa
120 1 aaaaaaaaaa
121 1 aaaaaaaaaa
122 1 aaaaaaaaaa
123 0 rows affected
124 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_non_encrypt
125 c2 SUBSTRING(c3,1,10)
126 1 aaaaaaaaaa
127 1 aaaaaaaaaa
128 1 aaaaaaaaaa
129 1 aaaaaaaaaa
130 0 rows affected
131 RUN SET GLOBAL innodb_redo_log_encrypt = 0
132
133 0 rows affected
134 RUN SELECT @@global.innodb_redo_log_encrypt
135 @@global.innodb_redo_log_encrypt
136 0
137 0 rows affected
138 RUN SET GLOBAL innodb_undo_log_encrypt = 0
139
140 0 rows affected
141 RUN SELECT @@global.innodb_undo_log_encrypt
142 @@global.innodb_undo_log_encrypt
143 0
144 0 rows affected
145 RUN START TRANSACTION
146
147 0 rows affected
148 RUN INSERT INTO tde_db.t_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
149
150 1 rows affected
151 RUN INSERT INTO tde_db.t_non_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
152
153 1 rows affected
154 RUN COMMIT
155
156 0 rows affected
157 RUN START TRANSACTION
158
159 0 rows affected
160 RUN INSERT INTO tde_db.t_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
161
162 1 rows affected
163 RUN INSERT INTO tde_db.t_non_encrypt(c2,c3) VALUES (1,CONCAT(REPEAT("a",6*512*512)))
164
165 1 rows affected
166 RUN ROLLBACK
167
168 0 rows affected
169 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_encrypt
170 c2 SUBSTRING(c3,1,10)
171 1 aaaaaaaaaa
172 1 aaaaaaaaaa
173 1 aaaaaaaaaa
174 1 aaaaaaaaaa
175 1 aaaaaaaaaa
176 0 rows affected
177 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_non_encrypt
178 c2 SUBSTRING(c3,1,10)
179 1 aaaaaaaaaa
180 1 aaaaaaaaaa
181 1 aaaaaaaaaa
182 1 aaaaaaaaaa
183 1 aaaaaaaaaa
184 0 rows affected
185 RUN SELECT @@global.innodb_redo_log_encrypt
186 @@global.innodb_redo_log_encrypt
187 0
188 0 rows affected
189 RUN SET GLOBAL innodb_redo_log_encrypt = 1
190
191 0 rows affected
192 RUN SELECT @@global.innodb_undo_log_encrypt
193 @@global.innodb_undo_log_encrypt
194 0
195 0 rows affected
196 RUN SET GLOBAL innodb_undo_log_encrypt = 1
197
198 0 rows affected
199 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_encrypt
200 c2 SUBSTRING(c3,1,10)
201 1 aaaaaaaaaa
202 1 aaaaaaaaaa
203 1 aaaaaaaaaa
204 1 aaaaaaaaaa
205 1 aaaaaaaaaa
206 0 rows affected
207 RUN SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_non_encrypt
208 c2 SUBSTRING(c3,1,10)
209 1 aaaaaaaaaa
210 1 aaaaaaaaaa
211 1 aaaaaaaaaa
212 1 aaaaaaaaaa
213 1 aaaaaaaaaa
214 0 rows affected
215 Mysqlx.Ok {
216 msg: "bye!"
217 }
218 ok
219 DROP USER 'x_root'@'localhost';
220 SELECT @@global.innodb_redo_log_encrypt;
221 @@global.innodb_redo_log_encrypt
222 1
223 SELECT @@global.innodb_undo_log_encrypt;
224 @@global.innodb_undo_log_encrypt
225 1
226 # Restarting server with keyring plugin
227 SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_encrypt;
228 c2 SUBSTRING(c3,1,10)
229 1 aaaaaaaaaa
230 1 aaaaaaaaaa
231 1 aaaaaaaaaa
232 1 aaaaaaaaaa
233 1 aaaaaaaaaa
234 SELECT c2,SUBSTRING(c3,1,10) FROM tde_db.t_non_encrypt;
235 c2 SUBSTRING(c3,1,10)
236 1 aaaaaaaaaa
237 1 aaaaaaaaaa
238 1 aaaaaaaaaa
239 1 aaaaaaaaaa
240 1 aaaaaaaaaa
241 DROP DATABASE tde_db;
242 # restart