Debian Codegraph @

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

raw
1 #
2 # 35289234 - Can't disable encryption once redo log encryption is enabled
3 #
4 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB;
5 SHOW CREATE TABLE t1;
6 Table Create Table
7 t1 CREATE TABLE `t1` (
8 `c1` int DEFAULT NULL,
9 `c2` char(20) DEFAULT NULL
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
11 INSERT INTO t1 VALUES(0, "aaaaa");
12 INSERT INTO t1 VALUES(1, "bbbbb");
13 INSERT INTO t1 VALUES(2, "ccccc");
14 INSERT INTO t1 VALUES(3, "ddddd");
15 INSERT INTO t1 VALUES(4, "eeeee");
16 INSERT INTO t1 VALUES(5, "fffff");
17 INSERT INTO t1 VALUES(6, "ggggg");
18 INSERT INTO t1 VALUES(7, "hhhhh");
19 INSERT INTO t1 VALUES(8, "iiiii");
20 INSERT INTO t1 VALUES(9, "jjjjj");
21 INSERT INTO t1 select * from t1;
22 INSERT INTO t1 select * from t1;
23 INSERT INTO t1 select * from t1;
24 INSERT INTO t1 select * from t1;
25 INSERT INTO t1 select * from t1;
26 INSERT INTO t1 select * from t1;
27 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
28 c1 c2
29 0 aaaaa
30 0 aaaaa
31 0 aaaaa
32 0 aaaaa
33 0 aaaaa
34 0 aaaaa
35 0 aaaaa
36 0 aaaaa
37 0 aaaaa
38 0 aaaaa
39 SET GLOBAL innodb_redo_log_encrypt=OFF;
40 SET GLOBAL innodb_fast_shutdown = 0;
41 # restart:--innodb_redo_log_encrypt=OFF
42 SELECT * FROM t1 ORDER BY c1 LIMIT 10;
43 c1 c2
44 0 aaaaa
45 0 aaaaa
46 0 aaaaa
47 0 aaaaa
48 0 aaaaa
49 0 aaaaa
50 0 aaaaa
51 0 aaaaa
52 0 aaaaa
53 0 aaaaa
54 DROP TABLE t1;
55 # restart: