Debian Codegraph @

mysql-test/suite/innodb/r/log_encrypt_5.result

raw
1 # create bootstrap file
2 # Stop the MTR default DB server
3 # Run the bootstrap command of datadir1
4 DROP DATABASE IF EXISTS tde_db;
5 CREATE DATABASE tde_db;
6 USE tde_db;
7 INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
8 SET @@global.keyring_file_data= 'MYSQL_TMP_DIR/my_key_log3';
9 SELECT
10 PLUGIN_NAME, PLUGIN_STATUS, PLUGIN_TYPE
11 FROM INFORMATION_SCHEMA.PLUGINS
12 WHERE PLUGIN_NAME LIKE '%keyring_file%' ;
13 PLUGIN_NAME PLUGIN_STATUS PLUGIN_TYPE
14 keyring_file ACTIVE KEYRING
15 SET GLOBAL innodb_redo_log_encrypt = 1;
16 SET GLOBAL innodb_undo_log_encrypt = 1;
17 SELECT @@global.innodb_redo_log_encrypt ;
18 @@global.innodb_redo_log_encrypt
19 1
20 CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
21 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
22 SELECT a,LEFT(b,10) FROM tde_db.t1;
23 a LEFT(b,10)
24 1 aaaaaaaaaa
25 CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
26 ENCRYPTION='Y' ENGINE=InnoDB;
27 INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
28 SELECT a,LEFT(b,10) FROM tde_db.t2;
29 a LEFT(b,10)
30 1 aaaaaaaaaa
31 SET GLOBAL innodb_redo_log_encrypt = 0;
32 SET GLOBAL innodb_undo_log_encrypt = 0;
33 SELECT @@global.innodb_redo_log_encrypt ;
34 @@global.innodb_redo_log_encrypt
35 0
36 CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
37 INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
38 SELECT a,LEFT(b,10) FROM tde_db.t3;
39 a LEFT(b,10)
40 1 aaaaaaaaaa
41 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
42 ENCRYPTION='Y' ENGINE=InnoDB;
43 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
44 SELECT a,LEFT(b,10) FROM tde_db.t4;
45 a LEFT(b,10)
46 1 aaaaaaaaaa
47 SET GLOBAL innodb_redo_log_encrypt = 1;
48 SET GLOBAL innodb_undo_log_encrypt = 1;
49 SELECT @@global.innodb_redo_log_encrypt ;
50 @@global.innodb_redo_log_encrypt
51 1
52 CREATE TABLE tde_db.t5 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
53 INSERT INTO t5 (a, b) VALUES (1, REPEAT('a', 6*512*512));
54 SELECT a,LEFT(b,10) FROM tde_db.t5;
55 a LEFT(b,10)
56 1 aaaaaaaaaa
57 CREATE TABLE tde_db.t6 (a BIGINT PRIMARY KEY, b LONGBLOB)
58 ENCRYPTION='Y' ENGINE=InnoDB;
59 INSERT INTO t6 (a, b) VALUES (1, REPEAT('a', 6*512*512));
60 SELECT a,LEFT(b,10) FROM tde_db.t6;
61 a LEFT(b,10)
62 1 aaaaaaaaaa
63 START TRANSACTION;
64 INSERT INTO t5 (a, b) VALUES (2, REPEAT('a', 6*512*512));
65 INSERT INTO t6 (a, b) VALUES (2, REPEAT('a', 6*512*512));
66 COMMIT;
67 START TRANSACTION;
68 INSERT INTO t5 (a, b) VALUES (3, REPEAT('a', 6*512*512));
69 INSERT INTO t6 (a, b) VALUES (3, REPEAT('a', 6*512*512));
70 ROLLBACK;
71 SELECT a,LEFT(b,10) FROM tde_db.t5;
72 a LEFT(b,10)
73 1 aaaaaaaaaa
74 2 aaaaaaaaaa
75 SELECT a,LEFT(b,10) FROM tde_db.t6;
76 a LEFT(b,10)
77 1 aaaaaaaaaa
78 2 aaaaaaaaaa
79 UNINSTALL PLUGIN keyring_file;
80 DROP TABLE tde_db.t1,tde_db.t2,tde_db.t3,tde_db.t4,tde_db.t5,tde_db.t6;
81 DROP DATABASE tde_db;