Debian Codegraph @

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

raw
1 # ----------------------------------------------------------------------
2 # Setup
3 # Creating custom global manifest file for MySQL server
4 # Creating custom global configuration file for keyring component: component_keyring_file
5 # Re-starting mysql server with manifest file
6 # ----------------------------------------------------------------------
7 # create bootstrap file
8 # Stop the MTR default DB server
9 # Run the bootstrap command of datadir1
10 DROP DATABASE IF EXISTS tde_db;
11 CREATE DATABASE tde_db;
12 USE tde_db;
13 SET GLOBAL innodb_redo_log_encrypt = 1;
14 SET GLOBAL innodb_undo_log_encrypt = 1;
15 SELECT @@global.innodb_redo_log_encrypt ;
16 @@global.innodb_redo_log_encrypt
17 1
18 CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
19 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
20 SELECT a,LEFT(b,10) FROM tde_db.t1;
21 a LEFT(b,10)
22 1 aaaaaaaaaa
23 CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
24 ENCRYPTION='Y' ENGINE=InnoDB;
25 INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
26 SELECT a,LEFT(b,10) FROM tde_db.t2;
27 a LEFT(b,10)
28 1 aaaaaaaaaa
29 SET GLOBAL innodb_redo_log_encrypt = 0;
30 SET GLOBAL innodb_undo_log_encrypt = 0;
31 SELECT @@global.innodb_redo_log_encrypt ;
32 @@global.innodb_redo_log_encrypt
33 0
34 CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
35 INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
36 SELECT a,LEFT(b,10) FROM tde_db.t3;
37 a LEFT(b,10)
38 1 aaaaaaaaaa
39 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
40 ENCRYPTION='Y' ENGINE=InnoDB;
41 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
42 SELECT a,LEFT(b,10) FROM tde_db.t4;
43 a LEFT(b,10)
44 1 aaaaaaaaaa
45 SET GLOBAL innodb_redo_log_encrypt = 1;
46 SET GLOBAL innodb_undo_log_encrypt = 1;
47 SELECT @@global.innodb_redo_log_encrypt ;
48 @@global.innodb_redo_log_encrypt
49 1
50 CREATE TABLE tde_db.t5 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
51 INSERT INTO t5 (a, b) VALUES (1, REPEAT('a', 6*512*512));
52 SELECT a,LEFT(b,10) FROM tde_db.t5;
53 a LEFT(b,10)
54 1 aaaaaaaaaa
55 CREATE TABLE tde_db.t6 (a BIGINT PRIMARY KEY, b LONGBLOB)
56 ENCRYPTION='Y' ENGINE=InnoDB;
57 INSERT INTO t6 (a, b) VALUES (1, REPEAT('a', 6*512*512));
58 SELECT a,LEFT(b,10) FROM tde_db.t6;
59 a LEFT(b,10)
60 1 aaaaaaaaaa
61 START TRANSACTION;
62 INSERT INTO t5 (a, b) VALUES (2, REPEAT('a', 6*512*512));
63 INSERT INTO t6 (a, b) VALUES (2, REPEAT('a', 6*512*512));
64 COMMIT;
65 START TRANSACTION;
66 INSERT INTO t5 (a, b) VALUES (3, REPEAT('a', 6*512*512));
67 INSERT INTO t6 (a, b) VALUES (3, REPEAT('a', 6*512*512));
68 ROLLBACK;
69 SELECT a,LEFT(b,10) FROM tde_db.t5;
70 a LEFT(b,10)
71 1 aaaaaaaaaa
72 2 aaaaaaaaaa
73 SELECT a,LEFT(b,10) FROM tde_db.t6;
74 a LEFT(b,10)
75 1 aaaaaaaaaa
76 2 aaaaaaaaaa
77 DROP TABLE tde_db.t1,tde_db.t2,tde_db.t3,tde_db.t4,tde_db.t5,tde_db.t6;
78 DROP DATABASE tde_db;
79 # ----------------------------------------------------------------------
80 # Teardown
81 # Removing local keyring file for keyring component: component_keyring_file
82 # Removing global configuration file for keyring component: component_keyring_file
83 # Removing global manifest file for MySQL server
84 # Restarting server without the manifest file
85 # ----------------------------------------------------------------------