Debian Codegraph @

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

raw
1 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
2 SET GLOBAL innodb_master_thread_disabled_debug = 1;
3 SET GLOBAL debug = "+d,disable_se_persists_gtid";
4 FLUSH ENGINE LOGS;
5 SET GLOBAL debug = "+d,gtid_persist_flush_disable";
6 SET GLOBAL innodb_log_checkpoint_now = 1;
7 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
8 SET GLOBAL innodb_checkpoint_disabled = 1;
9 SET GLOBAL innodb_purge_stop_now = 1;
10 DO innodb_redo_log_consumer_register();
11 SELECT @@global.innodb_redo_log_encrypt ;
12 @@global.innodb_redo_log_encrypt
13 0
14 CREATE TABLE t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
15 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
16 SET GLOBAL innodb_redo_log_encrypt = 1;
17 SELECT @@global.innodb_redo_log_encrypt ;
18 @@global.innodb_redo_log_encrypt
19 1
20 INSERT INTO t1 (a, b) VALUES (2, REPEAT('b', 6*512*512));
21 SET GLOBAL innodb_redo_log_encrypt = 0;
22 SELECT @@global.innodb_redo_log_encrypt ;
23 @@global.innodb_redo_log_encrypt
24 0
25 INSERT INTO t1 (a, b) VALUES (3, REPEAT('c', 6*512*512));
26 FLUSH LOGS;
27 CHECKSUM TABLE t1;
28 Table Checksum
29 test.t1 2003490276
30 # Kill the server
31 # restart
32 CHECKSUM TABLE t1;
33 Table Checksum
34 test.t1 2003490276
35 SELECT a,LEFT(b,8) FROM t1;
36 a LEFT(b,8)
37 1 aaaaaaaa
38 2 bbbbbbbb
39 3 cccccccc
40 DO innodb_redo_log_consumer_register();
41 INSERT INTO t1 (a, b) VALUES (4, REPEAT('d', 6*512*512));
42 # Kill the server
43 # restart
44 SELECT a,LEFT(b,8) FROM t1;
45 a LEFT(b,8)
46 1 aaaaaaaa
47 2 bbbbbbbb
48 3 cccccccc
49 4 dddddddd
50 DROP TABLE t1;