Debian Codegraph @

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

raw
1 #
2 # Bug #29820184 REDO LOGS MAY SILENTLY BE IGNORED WHEN ENCRYPTED TABLE
3 # CANNOT BE DECRYPTED.
4 #
5 CREATE TABLE t1(
6 a INT NOT NULL PRIMARY KEY,
7 c CHAR(200),
8 b BLOB,
9 INDEX(b(10))) ENGINE=innodb ROW_FORMAT=compressed ENCRYPTION='Y';
10 CREATE TABLE t2(
11 a INT NOT NULL PRIMARY KEY,
12 c CHAR(200),
13 b BLOB,
14 INDEX(b(10))) ENGINE=innodb ROW_FORMAT=compressed ENCRYPTION='Y';
15 CREATE TABLE t3(
16 a INT NOT NULL PRIMARY KEY,
17 c CHAR(200),
18 b BLOB,
19 INDEX(b(10))) ENGINE=innodb ENCRYPTION='Y';
20 CREATE TABLE t4(
21 a INT NOT NULL PRIMARY KEY,
22 c CHAR(200),
23 b BLOB,
24 INDEX(b(10))) ENGINE=innodb ENCRYPTION='Y';
25 # restart
26 INSERT INTO t2 SELECT * FROM t1;
27 INSERT INTO t3 SELECT * FROM t1;
28 INSERT INTO t4 SELECT * FROM t1;
29 COMMIT;
30 SET GLOBAL innodb_flush_log_at_trx_commit=1;
31 BEGIN;
32 UPDATE t1 SET c = REPEAT('secret3', 20);
33 UPDATE t2 SET c = REPEAT('secret4', 20);
34 UPDATE t3 set c = REPEAT('secret4', 20);
35 UPDATE t4 set c = REPEAT('secret4', 20);
36 INSERT INTO t1 (a,c,b) VALUES (21, REPEAT('secret5',20), REPEAT('secret6',6000));
37 INSERT INTO t2 (a,c,b) VALUES (21, REPEAT('secret7',20), REPEAT('secret8',6000));
38 INSERT into t3 (a,c,b) VALUES (21, REPEAT('secret9',20), REPEAT('secre10',6000));
39 INSERT into t4 (a,c,b) VALUES (21, REPEAT('secre11',20), REPEAT('secre12',6000));
40 COMMIT;
41 # Kill the server
42 # Restart mysqld without keyring plugin
43 # Restart mysqld with keyring plugin
44 drop TABLE t1,t2,t3,t4;