Debian Codegraph @

mysql-test/suite/innodb/r/log_encrypt_4.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 SELECT @@global.innodb_redo_log_encrypt ;
6 @@global.innodb_redo_log_encrypt
7 1
8 USE test;
9 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
10 INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
11 SELECT * FROM tab1;
12 c1 c2
13 1 Test consistency undo*
14 CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
15 INSERT INTO tab2 VALUES(1, 'Test consistency undo*');
16 SELECT * FROM tab2;
17 c1 c2
18 1 Test consistency undo*
19 DROP TABLE tab1,tab2;
20 # restart:
21 # Stop the MTR default DB server
22 # Run the bootstrap command of datadir2, it should fail since the keyring is not loaded.
23 # Run the bootstrap command of datadir2
24 # Start the DB server with datadir2
25 SELECT @@global.innodb_redo_log_encrypt ;
26 @@global.innodb_redo_log_encrypt
27 1
28 USE test;
29 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
30 INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
31 SELECT * FROM tab1;
32 c1 c2
33 1 Test consistency undo*
34 CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
35 INSERT INTO tab2 VALUES(1, 'Test consistency undo*');
36 SELECT * FROM tab2;
37 c1 c2
38 1 Test consistency undo*
39 DROP TABLE tab1,tab2;
40 # restart:
41 # Stop the MTR default DB server
42 # Run the bootstrap command of datadir3
43 # Start the DB server with datadir3 and keyring loaded.
44 SELECT @@global.innodb_redo_log_encrypt ;
45 @@global.innodb_redo_log_encrypt
46 0
47 USE test;
48 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
49 INSERT INTO tab1 VALUES(1, 'Test consistency undo*');
50 SELECT * FROM tab1;
51 c1 c2
52 1 Test consistency undo*
53 CREATE TABLE tab2(c1 INT, c2 VARCHAR(30)) ENCRYPTION="Y";
54 DROP TABLE tab1;
55 # restart: