Debian Codegraph @

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

raw
1 #
2 # wl9508: Show that explicit and implicit undo tablespaces can be encrypted.
3 #
4 use test;
5 CREATE table tab1(c1 int);
6 # create bootstrap file
7 # Stop the MTR default DB server
8 # Run the bootstrap command of datadir1
9 SELECT @@datadir;
10 @@datadir
11 MYSQLD_DATADIR1/
12 SHOW VARIABLES LIKE 'keyring_file%';
13 Variable_name Value
14 keyring_file_data key_file/my_keyfile
15 SELECT @@innodb_undo_log_encrypt;
16 @@innodb_undo_log_encrypt
17 1
18 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
19 CREATE DATABASE nath;
20 use nath;
21 CREATE TABLE tab2(c1 int , c2 varchar(10)) Engine=InnoDB ENCRYPTION='Y';
22 INSERT INTO tab2 VALUES(2, 'VISH');
23 CREATE INDEX ix2 ON tab2(c2) ;
24 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
25 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
26 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
27 DELETE FROM tab2;
28 DROP UNDO TABLESPACE undo_003;
29 DROP UNDO TABLESPACE undo_004;
30 DROP TABLE tab2;
31 DROP DATABASE nath;
32 # Stop the encrypt server
33 # restart: --datadir=OLD_DATADIR
34 SELECT @@datadir;
35 @@datadir
36 MYSQLD_OLD_DATADIR
37 use test;
38 DROP TABLE tab1;
39 #
40 # bug#29006275 : ENCRYPTION MASTER KEY IS GENERATED WITH BLANK UUID
41 #
42 # Stop the non-encrypted server
43 # Run the bootstrap command of datadir1
44 # Show that a master key with a blank Server UUID is not used.
45 SELECT * FROM performance_schema.keyring_keys where KEY_ID='INNODBKey--1';
46 KEY_ID KEY_OWNER BACKEND_KEY_ID
47 # Stop the encrypted server
48 # restart: