Debian Codegraph @

mysql-test/suite/galera/t/galera_encrypt_tmp_files.test

raw
1 # This file tests that mariadb cluster should not crash when encrypt_tmp_file
2 # is enabled
3
4 --source include/galera_cluster.inc
5 --source include/have_innodb.inc
6
7 SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
8 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
9
10 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
11 INSERT INTO t1 VALUES (1);
12
13 --connection node_2
14 SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
15 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
16
17 SELECT COUNT(*) = 1 FROM t1;
18
19 DROP TABLE t1;
20
21 --connection node_1
22
23 CREATE TABLE `t1` (
24 `col1` int(11) NOT NULL,
25 `col2` varchar(64) NOT NULL DEFAULT '',
26 `col3` varchar(32) NOT NULL DEFAULT '0',
27 `col4` varchar(64) NOT NULL DEFAULT '',
28 `col5` tinyint(4) NOT NULL DEFAULT '0',
29 `col6` int(11) NOT NULL DEFAULT '0',
30 `col7` varchar(64) NOT NULL DEFAULT '',
31 `col8` tinyint(4) NOT NULL DEFAULT '0',
32 `col9` tinyint(4) NOT NULL DEFAULT '0',
33 `col10` text NOT NULL,
34 `col11` varchar(255) NOT NULL DEFAULT '',
35 `col12` tinyint(4) NOT NULL DEFAULT '1'
36 ) ;
37
38 #Although we just need $counter >= 907 for IO_CACHE to use
39 #encrypted temp file. Just on safe side I am using $counter
40 # = 1100
41 --disable_query_log
42 --let $counter=1100
43 --let $query= (1,'test','test','test',0,0,'-1',0,0,'','',-1)
44 while($counter)
45 {
46 --let $query= $query ,(1,'test','test','test',0,0,'-1',0,0,'','',-1)
47 --dec $counter
48 }
49 --let $query= INSERT INTO t1 values $query ;
50 --eval $query
51 --enable_query_log
52 #INSERT INTO `t1` VALUE
53
54 create table t2 (test int);
55 insert into t2 values (1);
56
57 drop table t1,t2;