Debian Codegraph @

mysql-test/suite/innodb/t/disable_log_encryption.test

raw
1 --source include/have_debug.inc
2 --source include/have_perl_64bit_int.inc
3 --source ../include/log_disable_page_cleaners.inc
4 DO innodb_redo_log_consumer_register();
5 SELECT @@global.innodb_redo_log_encrypt ;
6 CREATE TABLE t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
7 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
8 SET GLOBAL innodb_redo_log_encrypt = 1;
9 SELECT @@global.innodb_redo_log_encrypt ;
10 INSERT INTO t1 (a, b) VALUES (2, REPEAT('b', 6*512*512));
11 SET GLOBAL innodb_redo_log_encrypt = 0;
12 SELECT @@global.innodb_redo_log_encrypt ;
13 INSERT INTO t1 (a, b) VALUES (3, REPEAT('c', 6*512*512));
14 FLUSH LOGS;
15 CHECKSUM TABLE t1;
16 --source include/kill_mysqld.inc
17
18 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so
19 --source include/start_mysqld.inc
20
21 CHECKSUM TABLE t1;
22 SELECT a,LEFT(b,8) FROM t1;
23
24 DO innodb_redo_log_consumer_register();
25 INSERT INTO t1 (a, b) VALUES (4, REPEAT('d', 6*512*512));
26
27 let MYSQLD_DATADIR = `select @@datadir`;
28 --source include/kill_mysqld.inc
29
30 perl;
31 use strict;
32 require 'include/ib_redo_log_files.inc';
33 my $found_a = 0;
34 my $found_c = 0;
35 my $found_d = 0;
36 for my $file (log_get_non_tmp_files()) {
37 open(FILE, "$file") or die("Unable to open $file: $!\n");
38 while (<FILE>) {
39 if ($_ =~ /aaaaaaaaaaaaaaaaaaaaaaaaaaa/) {
40 $found_a = 1;
41 }
42 if ($_ =~ /bbbbbbbbbbbbbbbbbbbbbbbbbbb/) {
43 print "Pattern bbbbb found unencrypted\n";
44 }
45 if ($_ =~ /ccccccccccccccccccccccccccc/) {
46 $found_c = 1;
47 }
48 if ($_ =~ /ddddddddddddddddddddddddddd/) {
49 $found_d = 1;
50 }
51 }
52 close(FILE);
53 }
54 if ($found_a == 0) {
55 print "Pattern aaaaaaa expected to be present unencrypted, but not found\n";
56 }
57 if ($found_c == 0) {
58 print "Pattern ccccccc expected to be present unencrypted, but not found\n";
59 }
60 if ($found_d == 0) {
61 print "Pattern ddddddd expected to be present unencrypted, but not found\n";
62 }
63 EOF
64
65 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $KEYRING_PLUGIN keyring_file.so
66 --source include/start_mysqld.inc
67 SELECT a,LEFT(b,8) FROM t1;
68 DROP TABLE t1;