encryption/r/tablespace.result

25 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
29 WHERE NAME LIKE 'ts1';
31 ts1	N
32 DROP TABLESPACE ts1;
39 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
43 WHERE NAME LIKE 'ts1';
45 ts1	Y
46 DROP TABLESPACE ts1;
55 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
59 WHERE NAME LIKE 'ts1';
61 ts1	N
62 DROP TABLESPACE ts1;
66 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
70 WHERE NAME LIKE 'ts1';
72 ts1	N
73 DROP TABLESPACE ts1;
82 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
86 WHERE NAME LIKE 'ts1';
88 ts1	Y
89 DROP TABLESPACE ts1;
93 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
97 WHERE NAME LIKE 'ts1';
99 ts1	Y
100 DROP TABLESPACE ts1;
112 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
116 WHERE NAME LIKE 'ts1';
118 ts1	Y
119 DROP TABLESPACE ts1;
126 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
130 WHERE NAME LIKE 'ts1';
132 ts1	N
133 DROP TABLESPACE ts1;
140 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
144 WHERE NAME LIKE 'ts1';
146 ts1	Y
147 DROP TABLESPACE ts1;
154 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
158 WHERE NAME LIKE 'ts1';
160 ts1	N
161 DROP TABLESPACE ts1;
170 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
176 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
180 WHERE NAME LIKE 'ts1';
182 ts1	Y
183 DROP TABLESPACE ts1;
192 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
196 WHERE NAME LIKE 'ts1';
198 ts1	N
199 DROP TABLESPACE ts1;
203 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
207 WHERE NAME LIKE 'ts1';
209 ts1	N
210 DROP TABLESPACE ts1;
219 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
223 WHERE NAME LIKE 'ts1';
225 ts1	Y
226 DROP TABLESPACE ts1;
230 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
234 WHERE NAME LIKE 'ts1';
236 ts1	Y
237 DROP TABLESPACE ts1;
246 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
252 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
256 WHERE NAME LIKE 'ts1';
258 ts1	N
259 DROP TABLESPACE ts1;
270 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='k';
283 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
285 WHERE NAME LIKE 'ts1';
287 ts1	N
290 ALTER TABLESPACE ts1 ENCRYPTION='n';
294 WHERE NAME LIKE 'ts1';
296 ts1	N
297 DROP TABLESPACE ts1;
302 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
304 WHERE NAME LIKE 'ts1';
306 ts1	N
309 ALTER TABLESPACE ts1 ENCRYPTION='n';
313 WHERE NAME LIKE 'ts1';
315 ts1	N
316 DROP TABLESPACE ts1;
321 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
323 WHERE NAME LIKE 'ts1';
325 ts1	N
327 ALTER TABLESPACE ts1 ENCRYPTION='n';
331 WHERE NAME LIKE 'ts1';
333 ts1	N
334 DROP TABLESPACE ts1;
344 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
346 WHERE NAME LIKE 'ts1';
348 ts1	Y
351 ALTER TABLESPACE ts1 ENCRYPTION='y';
355 WHERE NAME LIKE 'ts1';
357 ts1	Y
358 DROP TABLESPACE ts1;
363 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
365 WHERE NAME LIKE 'ts1';
367 ts1	Y
370 ALTER TABLESPACE ts1 ENCRYPTION='y';
374 WHERE NAME LIKE 'ts1';
376 ts1	Y
377 DROP TABLESPACE ts1;
382 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
384 WHERE NAME LIKE 'ts1';
386 ts1	Y
388 ALTER TABLESPACE ts1 ENCRYPTION='y';
392 WHERE NAME LIKE 'ts1';
394 ts1	Y
395 DROP TABLESPACE ts1;
406 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
408 WHERE NAME LIKE 'ts1';
410 ts1	N
413 ALTER TABLESPACE ts1 ENCRYPTION='y';
417 WHERE NAME LIKE 'ts1';
419 ts1	Y
420 DROP TABLESPACE ts1;
425 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
427 WHERE NAME LIKE 'ts1';
429 ts1	N
432 ALTER TABLESPACE ts1 ENCRYPTION='y';
438 WHERE NAME LIKE 'ts1';
440 ts1	N
441 DROP TABLESPACE ts1;
446 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
448 WHERE NAME LIKE 'ts1';
450 ts1	N
452 ALTER TABLESPACE ts1 ENCRYPTION='y';
456 WHERE NAME LIKE 'ts1';
458 ts1	Y
459 DROP TABLESPACE ts1;
470 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
472 WHERE NAME LIKE 'ts1';
474 ts1	N
477 ALTER TABLESPACE ts1 ENCRYPTION='y';
481 WHERE NAME LIKE 'ts1';
483 ts1	Y
484 DROP TABLESPACE ts1;
489 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
491 WHERE NAME LIKE 'ts1';
493 ts1	N
496 ALTER TABLESPACE ts1 ENCRYPTION='y';
500 WHERE NAME LIKE 'ts1';
502 ts1	Y
503 DROP TABLESPACE ts1;
508 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='n';
510 WHERE NAME LIKE 'ts1';
512 ts1	N
514 ALTER TABLESPACE ts1 ENCRYPTION='y';
518 WHERE NAME LIKE 'ts1';
520 ts1	Y
521 DROP TABLESPACE ts1;
532 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
534 WHERE NAME LIKE 'ts1';
536 ts1	Y
539 ALTER TABLESPACE ts1 ENCRYPTION='n';
543 WHERE NAME LIKE 'ts1';
545 ts1	N
546 DROP TABLESPACE ts1;
551 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
553 WHERE NAME LIKE 'ts1';
555 ts1	Y
558 ALTER TABLESPACE ts1 ENCRYPTION='n';
562 WHERE NAME LIKE 'ts1';
564 ts1	N
565 DROP TABLESPACE ts1;
570 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
572 WHERE NAME LIKE 'ts1';
574 ts1	Y
576 ALTER TABLESPACE ts1 ENCRYPTION='n';
580 WHERE NAME LIKE 'ts1';
582 ts1	N
583 DROP TABLESPACE ts1;
594 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
596 WHERE NAME LIKE 'ts1';
598 ts1	Y
601 ALTER TABLESPACE ts1 ENCRYPTION='n';
605 WHERE NAME LIKE 'ts1';
607 ts1	N
608 DROP TABLESPACE ts1;
613 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
615 WHERE NAME LIKE 'ts1';
617 ts1	Y
620 ALTER TABLESPACE ts1 ENCRYPTION='n';
626 WHERE NAME LIKE 'ts1';
628 ts1	Y
629 DROP TABLESPACE ts1;
634 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
636 WHERE NAME LIKE 'ts1';
638 ts1	Y
640 ALTER TABLESPACE ts1 ENCRYPTION='n';
644 WHERE NAME LIKE 'ts1';
646 ts1	N
647 DROP TABLESPACE ts1;
656 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd' ENCRYPTION='y';
658 WHERE NAME LIKE 'ts1';
660 ts1	Y
663 ALTER TABLESPACE ts1 ENCRYPTION='k';
668 Error	1533	Failed to alter: TABLESPACE ts1
671 WHERE NAME LIKE 'ts1';
673 ts1	Y
674 DROP TABLESPACE ts1;