Debian Codegraph @

mysql-test/suite/innodb/t/tablespace_encrypt_4.test

raw
1 ################################################################################
2 # InnoDB transparent tablespace data encryption for general shared tablespace.
3 # This test case will test
4 # - Table movement from one tablespace to another tablespace
5 # - Partitoned Table create/alter with different combination of tablespace at
6 # table level and partition level.
7 ################################################################################
8
9 --source include/no_valgrind_without_big.inc
10 # Waiting time when (re)starting the server
11 --let $explicit_default_wait_counter=10000
12
13 --disable_query_log
14 call mtr.add_suppression("ibd can't be decrypted, please confirm the keyfile is match and keyring plugin is loaded.");
15 call mtr.add_suppression("\\[Error\\] \\[[^]]*\\] Encryption can't find master key, please check the keyring plugin is loaded.");
16 --enable_query_log
17
18 --echo #########################################################################
19 --echo # START : WITHOUT KEYRING PLUGIN
20 --echo #########################################################################
21 --echo
22 --echo #########
23 --echo # SETUP #
24 --echo #########
25
26 --echo #########################################################################
27 --echo # RESTART 1 : WITH KEYRING PLUGIN
28 --echo #########################################################################
29 let $restart_parameters = restart:
30 --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --performance-schema-consumer-events-stages-current=ON;
31 --source include/restart_mysqld_no_echo.inc
32
33 --echo #########################################################################
34 --echo # Non Partitioned Table #
35 --echo #########################################################################
36 --echo
37 --disable_warnings
38 DROP TABLE IF EXISTS t1;
39 --enable_warnings
40 --echo # Create an Encrypted and an Unencrypted tablespace
41 CREATE TABLESPACE encrypt_ts add datafile 'encrypt_ts.ibd' ENCRYPTION='Y';
42 CREATE TABLESPACE unencrypt_ts add datafile 'unencrypt_ts.ibd' ENCRYPTION='N';
43
44 --echo # Create table with "encryption" option in general tablespace
45 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION='y';
46 SHOW WARNINGS;
47 DROP TABLE t1;
48 --error ER_INVALID_ENCRYPTION_REQUEST
49 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION='n';
50 SHOW WARNINGS;
51 --error ER_INVALID_ENCRYPTION_REQUEST
52 CREATE TABLE t1 (c int) TABLESPACE=innodb_system ENCRYPTION='y';
53 SHOW WARNINGS;
54 CREATE TABLE t1 (c int) TABLESPACE=innodb_system ENCRYPTION='n';
55 SHOW WARNINGS;
56 DROP TABLE t1;
57
58 --echo #-------------------------------------------------------
59
60 --echo # general [encrypted] => general [unencrypted]
61 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION='Y';
62 --error ER_TARGET_TABLESPACE_UNENCRYPTED
63 ALTER TABLE t1 TABLESPACE=unencrypt_ts ENCRYPTION='N', ALGORITHM=INPLACE;
64
65 --error ER_TARGET_TABLESPACE_UNENCRYPTED
66 ALTER TABLE t1 TABLESPACE=unencrypt_ts ENCRYPTION='N', ALGORITHM=COPY;
67
68 --echo # general [unencrypted] => general [encrypted]
69 DROP TABLE t1;
70 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
71 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
72 ALTER TABLE t1 TABLESPACE=encrypt_ts ENCRYPTION='Y', ALGORITHM=INPLACE;
73
74 --echo # Changing encryption type without explicit ENCRYPTION clause fails.
75 --error ER_INVALID_ENCRYPTION_REQUEST
76 ALTER TABLE t1 TABLESPACE=encrypt_ts, ALGORITHM=COPY;
77
78 --error ER_INVALID_ENCRYPTION_REQUEST
79 ALTER TABLE t1 TABLESPACE=encrypt_ts, ALGORITHM=INPLACE;
80
81 DROP TABLE t1;
82 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
83 ALTER TABLE t1 TABLESPACE=encrypt_ts ENCRYPTION='Y', ALGORITHM=COPY;
84
85 --echo #-------------------------------------------------------
86
87 --echo # general [encrypted] => file-per-table [unencrypted]
88 DROP TABLE t1;
89 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION='Y';
90 --error ER_TARGET_TABLESPACE_UNENCRYPTED
91 ALTER TABLE t1 TABLESPACE=innodb_file_per_table, ALGORITHM=INPLACE;
92
93 --error ER_TARGET_TABLESPACE_UNENCRYPTED
94 ALTER TABLE t1 TABLESPACE=innodb_file_per_table, ALGORITHM=COPY;
95
96 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
97 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='n', ALGORITHM=INPLACE;
98
99 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='n', ALGORITHM=COPY;
100 SHOW CREATE TABLE t1;
101 DROP TABLE t1;
102
103 --echo # general [encrypted] => file-per-table [encrypted]
104 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION= 'Y';
105 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='y', ALGORITHM=INPLACE;
106
107 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='y', ALGORITHM=COPY;
108 SHOW CREATE TABLE t1;
109
110 --echo #-------------------------------------------------------
111
112 --echo # general [unencrypted] => file-per-table [unencrypted]
113 DROP TABLE t1;
114 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
115 SHOW CREATE TABLE t1;
116 ALTER TABLE t1 TABLESPACE=innodb_file_per_table, ALGORITHM=INPLACE;
117 SHOW CREATE TABLE t1;
118
119 DROP TABLE t1;
120 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
121 SHOW CREATE TABLE t1;
122 ALTER TABLE t1 TABLESPACE=innodb_file_per_table, ALGORITHM=COPY;
123 SHOW CREATE TABLE t1;
124
125 --echo # general [unencrypted] => file-per-table [encrypted]
126 DROP TABLE t1;
127 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
128 SHOW CREATE TABLE t1;
129 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
130 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='y', ALGORITHM=INPLACE;
131
132 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='y', ALGORITHM=COPY;
133 SHOW CREATE TABLE t1;
134
135 --echo # general [unencrypted] => file-per-table [unencrypted]
136 DROP TABLE t1;
137 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
138 SHOW CREATE TABLE t1;
139 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='n', ALGORITHM=INPLACE;
140 SHOW CREATE TABLE t1;
141
142 DROP TABLE t1;
143 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
144 SHOW CREATE TABLE t1;
145 ALTER TABLE t1 TABLESPACE=innodb_file_per_table ENCRYPTION='n', ALGORITHM=COPY;
146 SHOW CREATE TABLE t1;
147
148 --echo #-------------------------------------------------------
149
150 --echo # file-per-table [unencrypted] => general [encrypted]
151 DROP TABLE t1;
152 CREATE TABLE t1 (c int) ENCRYPTION='n';
153 SHOW CREATE TABLE t1;
154 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
155 ALTER TABLE t1 TABLESPACE=encrypt_ts ENCRYPTION='Y', ALGORITHM=INPLACE;
156 SHOW CREATE TABLE t1;
157
158 DROP TABLE t1;
159 CREATE TABLE t1 (c int) ENCRYPTION='n';
160 SHOW CREATE TABLE t1;
161 ALTER TABLE t1 TABLESPACE=encrypt_ts ENCRYPTION='Y', ALGORITHM=COPY;
162 SHOW CREATE TABLE t1;
163
164 --echo # file-per-table [encrypted] => general [encrypted]
165 DROP TABLE t1;
166 CREATE TABLE t1 (c int) ENCRYPTION='y';
167 SHOW CREATE TABLE t1;
168 ALTER TABLE t1 TABLESPACE=encrypt_ts, ALGORITHM=INPLACE;
169
170 DROP TABLE t1;
171 CREATE TABLE t1 (c int) ENCRYPTION='y';
172 SHOW CREATE TABLE t1;
173 ALTER TABLE t1 TABLESPACE=encrypt_ts, ALGORITHM=COPY;
174 SHOW CREATE TABLE t1;
175
176 --echo # file-per-table [encrypted] => general [unencrypted]
177 DROP TABLE t1;
178 CREATE TABLE t1 (c int) ENCRYPTION='y';
179 SHOW CREATE TABLE t1;
180 --error ER_TARGET_TABLESPACE_UNENCRYPTED
181 ALTER TABLE t1 TABLESPACE=unencrypt_ts ENCRYPTION='N', ALGORITHM=INPLACE;
182
183 --error ER_TARGET_TABLESPACE_UNENCRYPTED
184 ALTER TABLE t1 TABLESPACE=unencrypt_ts ENCRYPTION='N', ALGORITHM=COPY;
185
186 --echo # file-per-table [unencrypted] => general [unencrypted]
187 DROP TABLE t1;
188 CREATE TABLE t1 (c int) ENCRYPTION='n';
189 SHOW CREATE TABLE t1;
190 ALTER TABLE t1 TABLESPACE=unencrypt_ts, ALGORITHM=INPLACE;
191 SHOW CREATE TABLE t1;
192
193 DROP TABLE t1;
194 CREATE TABLE t1 (c int) ENCRYPTION='n';
195 SHOW CREATE TABLE t1;
196 ALTER TABLE t1 TABLESPACE=unencrypt_ts, ALGORITHM=COPY;
197 SHOW CREATE TABLE t1;
198 DROP TABLE t1;
199
200 --echo #-------------------------------------------------------
201 --echo # ALTER TABLE ADD COLUMN/INDEX WITH MOVING TO DIFFERENT TABLESPACE
202
203 CREATE TABLESPACE encrypt_ts1 add datafile 'encrypt_ts1.ibd' ENCRYPTION='Y';
204 CREATE TABLESPACE unencrypt_ts1 add datafile 'unencrypt_ts1.ibd' ENCRYPTION='N';
205
206 --echo # ALGORITHM=DEFAULT
207 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION='Y';
208 --error ER_TARGET_TABLESPACE_UNENCRYPTED
209 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=unencrypt_ts ENCRYPTION='N';
210 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=encrypt_ts1;
211 SHOW CREATE TABLE t1;
212 ALTER TABLE t1 ADD INDEX (c), TABLESPACE=encrypt_ts;
213 SHOW CREATE TABLE t1;
214 DROP TABLE t1;
215
216 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
217 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=unencrypt_ts1;
218 SHOW CREATE TABLE t1;
219 ALTER TABLE t1 ADD INDEX (c), TABLESPACE=unencrypt_ts;
220 SHOW CREATE TABLE t1;
221 ALTER TABLE t1 ADD INDEX (c2), TABLESPACE=encrypt_ts ENCRYPTION='Y';
222 SHOW CREATE TABLE t1;
223 DROP TABLE t1;
224
225 --echo # ALGORITHM=INPLACE
226 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION='Y';
227 --error ER_TARGET_TABLESPACE_UNENCRYPTED
228 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=unencrypt_ts ENCRYPTION='N', ALGORITHM=INPLACE;
229 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=encrypt_ts1 ENCRYPTION='Y', ALGORITHM=INPLACE;
230 SHOW CREATE TABLE t1;
231 ALTER TABLE t1 ADD INDEX (c), TABLESPACE=encrypt_ts, ALGORITHM=INPLACE;
232 SHOW CREATE TABLE t1;
233 DROP TABLE t1;
234
235 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
236 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=unencrypt_ts1, ALGORITHM=INPLACE;
237 SHOW CREATE TABLE t1;
238 ALTER TABLE t1 ADD INDEX (c), TABLESPACE=unencrypt_ts, ALGORITHM=INPLACE;
239 SHOW CREATE TABLE t1;
240 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
241 ALTER TABLE t1 ADD INDEX (c2), TABLESPACE=encrypt_ts ENCRYPTION='Y', ALGORITHM=INPLACE;
242 SHOW CREATE TABLE t1;
243 DROP TABLE t1;
244
245 --echo # ALGORITHM=COPY
246 CREATE TABLE t1 (c int) TABLESPACE=encrypt_ts ENCRYPTION='Y';
247 --error ER_TARGET_TABLESPACE_UNENCRYPTED
248 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=unencrypt_ts ENCRYPTION='N', ALGORITHM=COPY;
249 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=encrypt_ts1, ALGORITHM=COPY;
250 SHOW CREATE TABLE t1;
251 ALTER TABLE t1 ADD INDEX (c), TABLESPACE=encrypt_ts, ALGORITHM=COPY;
252 SHOW CREATE TABLE t1;
253 DROP TABLE t1;
254
255 CREATE TABLE t1 (c int) TABLESPACE=unencrypt_ts;
256 ALTER TABLE t1 ADD c2 char(10), TABLESPACE=unencrypt_ts1, ALGORITHM=COPY;
257 SHOW CREATE TABLE t1;
258 ALTER TABLE t1 ADD INDEX (c), TABLESPACE=unencrypt_ts, ALGORITHM=COPY;
259 SHOW CREATE TABLE t1;
260 ALTER TABLE t1 ADD INDEX (c2), TABLESPACE=encrypt_ts ENCRYPTION='Y', ALGORITHM=COPY;
261 SHOW CREATE TABLE t1;
262 DROP TABLE t1;
263
264 --echo #########################################################################
265 --echo # Partitioned Table #
266 --echo #########################################################################
267 --echo
268 --disable_warnings
269 DROP TABLE IF EXISTS t1;
270 --enable_warnings
271 --echo # Create table without explicit tablespace name
272 CREATE TABLE t1 (id INT, name VARCHAR(50))
273 PARTITION BY RANGE(id) (
274 PARTITION p0 VALUES LESS THAN (10),
275 PARTITION p1 VALUES LESS THAN (20),
276 PARTITION p2 VALUES LESS THAN (30));
277 --echo # Try to ALTER TABLE to have general tablespace at table level
278 --error ER_ILLEGAL_HA_CREATE_OPTION
279 ALTER TABLE t1 TABLESPACE=unencrypt_ts;
280 SHOW WARNINGS;
281 --echo # Alter encryption option
282 ALTER TABLE t1 ENCRYPTION='Y';
283 DROP TABLE t1;
284
285 --echo # Create table with general tablespace at table level
286 --error ER_ILLEGAL_HA_CREATE_OPTION
287 CREATE TABLE t1 (id INT, name VARCHAR(50))
288 TABLESPACE=encrypt_ts ENCRYPTION='Y'
289 PARTITION BY RANGE(id) (
290 PARTITION p0 VALUES LESS THAN (10),
291 PARTITION p1 VALUES LESS THAN (20),
292 PARTITION p2 VALUES LESS THAN (30));
293 SHOW WARNINGS;
294
295 --echo # Create table with system tablespace at table level
296 --error ER_ILLEGAL_HA_CREATE_OPTION
297 CREATE TABLE t1 (id INT, name VARCHAR(50))
298 TABLESPACE=innodb_system
299 PARTITION BY RANGE(id) (
300 PARTITION p0 VALUES LESS THAN (10),
301 PARTITION p1 VALUES LESS THAN (20),
302 PARTITION p2 VALUES LESS THAN (30));
303 SHOW WARNINGS;
304
305 --echo # Create table with innodb_file_per_table tablespace at table level
306 CREATE TABLE t1 (id INT, name VARCHAR(50))
307 TABLESPACE=innodb_file_per_table
308 PARTITION BY RANGE(id) (
309 PARTITION p0 VALUES LESS THAN (10),
310 PARTITION p1 VALUES LESS THAN (20),
311 PARTITION p2 VALUES LESS THAN (30));
312 DROP TABLE t1;
313
314 --echo # Create table with general tablespace at partition level
315 --error ER_ILLEGAL_HA_CREATE_OPTION
316 CREATE TABLE t1 (id INT, name VARCHAR(50)) ENCRYPTION='Y'
317 PARTITION BY RANGE(id) (
318 PARTITION p0 VALUES LESS THAN (10),
319 PARTITION p1 VALUES LESS THAN (20),
320 PARTITION p2 VALUES LESS THAN (30) TABLESPACE=encrypt_ts);
321 SHOW WARNINGS;
322
323 --echo # Create table with system tablespace at partition level
324 --error ER_ILLEGAL_HA_CREATE_OPTION
325 CREATE TABLE t1 (id INT, name VARCHAR(50))
326 PARTITION BY RANGE(id) (
327 PARTITION p0 VALUES LESS THAN (10),
328 PARTITION p1 VALUES LESS THAN (20),
329 PARTITION p2 VALUES LESS THAN (30) TABLESPACE=innodb_system);
330 SHOW WARNINGS;
331
332 --echo # Create table with innodb_file_per_table tablespace at partition level
333 CREATE TABLE t1 (id INT, name VARCHAR(50))
334 PARTITION BY RANGE(id) (
335 PARTITION p0 VALUES LESS THAN (10),
336 PARTITION p1 VALUES LESS THAN (20),
337 PARTITION p2 VALUES LESS THAN (30) TABLESPACE=innodb_file_per_table);
338 DROP TABLE t1;
339
340 --echo # Create table with ENCRYPTION='y' option
341 CREATE TABLE t1 (id INT, name VARCHAR(50))
342 ENCRYPTION='Y'
343 PARTITION BY RANGE(id) (
344 PARTITION p0 VALUES LESS THAN (10),
345 PARTITION p1 VALUES LESS THAN (20),
346 PARTITION p2 VALUES LESS THAN (30));
347 INSERT INTO t1 VALUES (5,'test');
348 INSERT INTO t1 VALUES (12,'test1');
349 INSERT INTO t1 VALUES (22,'test2');
350
351 --echo # Truncate specific partition of encrypted table
352 ALTER TABLE t1 TRUNCATE PARTITION p0;
353
354 --echo # Alter encryption option
355 ALTER TABLE t1 ENCRYPTION='N';
356 DROP TABLE t1;
357
358 --echo # Create table with ENCRYPTION='y' option and innodb_file_per_table
359 --echo # tablespace at table level
360 CREATE TABLE t1 (id INT, name VARCHAR(50))
361 ENCRYPTION='Y' TABLESPACE=innodb_file_per_table
362 PARTITION BY RANGE(id) (
363 PARTITION p0 VALUES LESS THAN (10),
364 PARTITION p1 VALUES LESS THAN (20),
365 PARTITION p2 VALUES LESS THAN (30));
366
367 --echo # Alter encryption option
368 ALTER TABLE t1 ENCRYPTION='N';
369
370 --echo # Alter table to move a partition to general tablespace.
371 --error ER_INVALID_ENCRYPTION_REQUEST
372 ALTER TABLE t1 REORGANIZE PARTITION P2 INTO (
373 PARTITION P2 VALUES LESS THAN (30) TABLESPACE=encrypt_ts);
374 SHOW WARNINGS;
375 --error ER_ILLEGAL_HA_CREATE_OPTION
376 ALTER TABLE t1 REORGANIZE PARTITION P2 INTO (
377 PARTITION P2 VALUES LESS THAN (30) TABLESPACE=unencrypt_ts);
378 SHOW WARNINGS;
379
380 --echo # Alter table to move a partition to system tablespace.
381 --error ER_ILLEGAL_HA_CREATE_OPTION
382 ALTER TABLE t1 REORGANIZE PARTITION P2 INTO (
383 PARTITION P2 VALUES LESS THAN (30) TABLESPACE=innodb_system);
384 SHOW WARNINGS;
385
386 --echo # Alter table to move a partition to file_per_table tablespace.
387 ALTER TABLE t1 REORGANIZE PARTITION P2 INTO (
388 PARTITION P2 VALUES LESS THAN (30) TABLESPACE=innodb_file_per_table);
389
390 SHOW CREATE TABLE t1;
391
392 --echo # Alter table to add a new partition in general tablespace
393 --error ER_INVALID_ENCRYPTION_REQUEST
394 ALTER TABLE t1 ADD PARTITION (
395 PARTITION p3 VALUES LESS THAN (40) tablespace=encrypt_ts);
396 SHOW WARNINGS;
397 --error ER_ILLEGAL_HA_CREATE_OPTION
398 ALTER TABLE t1 ADD PARTITION (
399 PARTITION p3 VALUES LESS THAN (40) tablespace=unencrypt_ts);
400 SHOW WARNINGS;
401
402 --echo # Alter table to add a new partition in innodb_system tablespace
403 --error ER_ILLEGAL_HA_CREATE_OPTION
404 ALTER TABLE t1 ADD PARTITION (
405 PARTITION p3 VALUES LESS THAN (40) tablespace=innodb_system);
406 SHOW WARNINGS;
407
408 --echo # Alter table to add a new partition in innodb_file_per_table tablespace
409 ALTER TABLE t1 ADD PARTITION (
410 PARTITION p3 VALUES LESS THAN (40) tablespace=innodb_file_per_table);
411
412 --echo # Alter table to add a new partition without giving tablespace
413 ALTER TABLE t1 ADD PARTITION (
414 PARTITION p4 VALUES LESS THAN (50));
415
416 SHOW CREATE TABLE t1;
417
418 --echo # Alter table to add a new partition with encryption option at partition
419 --echo # level.
420 --error ER_PARSE_ERROR
421 ALTER TABLE t1 ADD PARTITION (
422 PARTITION p5 VALUES LESS THAN (60) encryption='Y');
423
424 DROP TABLE t1;
425
426 --echo # Create table with ENCRYPTION='y' option and general tablespace
427 --echo # at table level
428 --error ER_ILLEGAL_HA_CREATE_OPTION
429 CREATE TABLE t1 (id INT, name VARCHAR(50))
430 ENCRYPTION='Y' TABLESPACE=encrypt_ts
431 PARTITION BY RANGE(id) (
432 PARTITION p0 VALUES LESS THAN (10),
433 PARTITION p1 VALUES LESS THAN (20),
434 PARTITION p2 VALUES LESS THAN (30));
435 SHOW WARNINGS;
436
437 --echo # Create table with ENCRYPTION='y' option and general tablespace
438 --echo # at partition level
439 --error ER_ILLEGAL_HA_CREATE_OPTION
440 CREATE TABLE t1 (id INT, name VARCHAR(50))
441 ENCRYPTION='Y'
442 PARTITION BY RANGE(id) (
443 PARTITION p0 VALUES LESS THAN (10),
444 PARTITION p1 VALUES LESS THAN (20),
445 PARTITION p2 VALUES LESS THAN (30) TABLESPACE=encrypt_ts);
446 SHOW WARNINGS;
447
448 --echo ###########
449 --echo # Cleanup #
450 --echo ###########
451 --disable_warnings
452 DROP TABLE IF EXISTS t1;
453 --enable_warnings
454 DROP TABLESPACE encrypt_ts;
455 DROP TABLESPACE encrypt_ts1;
456 DROP TABLESPACE unencrypt_ts;
457 DROP TABLESPACE unencrypt_ts1;
458 remove_file $MYSQL_TMP_DIR/mysecret_keyring;
459
460 --echo # Restarting server without keyring to restore server state
461 let $restart_parameters = restart: ;
462 --source include/restart_mysqld.inc