Debian Codegraph @

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

raw
1 # create bootstrap file
2 # Stop the MTR default DB server
3 # Run the bootstrap command of datadir1
4 # Start the DB server with datadir1
5 DROP DATABASE IF EXISTS tde_db;
6 CREATE DATABASE tde_db;
7 USE tde_db;
8 SET GLOBAL innodb_redo_log_encrypt = 1;
9 SELECT @@global.innodb_redo_log_encrypt ;
10 @@global.innodb_redo_log_encrypt
11 1
12 SELECT @@global.innodb_redo_log_encrypt ;
13 @@global.innodb_redo_log_encrypt
14 1
15 CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
16 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
17 SELECT a,LEFT(b,10) FROM tde_db.t1;
18 a LEFT(b,10)
19 1 aaaaaaaaaa
20 CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
21 ENCRYPTION='Y' ENGINE=InnoDB;
22 INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
23 SELECT a,LEFT(b,10) FROM tde_db.t2;
24 a LEFT(b,10)
25 1 aaaaaaaaaa
26 SELECT @@global.innodb_redo_log_encrypt ;
27 @@global.innodb_redo_log_encrypt
28 1
29 CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
30 INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
31 SELECT a,LEFT(b,10) FROM tde_db.t3;
32 a LEFT(b,10)
33 1 aaaaaaaaaa
34 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
35 ENCRYPTION='Y' ENGINE=InnoDB;
36 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
37 SELECT a,LEFT(b,10) FROM tde_db.t4;
38 a LEFT(b,10)
39 1 aaaaaaaaaa
40 SELECT @@global.innodb_redo_log_encrypt ;
41 @@global.innodb_redo_log_encrypt
42 1
43 CREATE TABLE tde_db.t5 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
44 INSERT INTO t5 (a, b) VALUES (1, REPEAT('a', 6*512*512));
45 SELECT a,LEFT(b,10) FROM tde_db.t5;
46 a LEFT(b,10)
47 1 aaaaaaaaaa
48 CREATE TABLE tde_db.t6 (a BIGINT PRIMARY KEY, b LONGBLOB)
49 ENCRYPTION='Y' ENGINE=InnoDB;
50 INSERT INTO t6 (a, b) VALUES (1, REPEAT('a', 6*512*512));
51 SELECT a,LEFT(b,10) FROM tde_db.t6;
52 a LEFT(b,10)
53 1 aaaaaaaaaa
54 UNINSTALL PLUGIN keyring_file;
55 DROP DATABASE tde_db;
56 # Try starting without keyring : Error
57 # Search for error message
58 Pattern "Redo log was encrypted, but keyring is not loaded" found
59 Pattern "Aborting" found
60 # Restart without keyring plugin possible if redo files removed
61 # Start the DB server with datadir1
62 # Try starting without keyring and --innodb_force_recovery=SRV_FORCE_NO_LOG_REDO.
63 # Start the DB server with datadir1
64 SELECT 1;
65 1
66 1
67 # restart