Debian Codegraph @

mysql-test/suite/galera/r/galera_encrypt_tmp_files.result

raw
1 connection node_2;
2 connection node_1;
3 SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
4 VARIABLE_VALUE = 'Synced'
5 1
6 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
7 VARIABLE_VALUE = 2
8 1
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
10 INSERT INTO t1 VALUES (1);
11 connection node_2;
12 SELECT VARIABLE_VALUE = 'Synced' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_local_state_comment';
13 VARIABLE_VALUE = 'Synced'
14 1
15 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
16 VARIABLE_VALUE = 2
17 1
18 SELECT COUNT(*) = 1 FROM t1;
19 COUNT(*) = 1
20 1
21 DROP TABLE t1;
22 connection node_1;
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 create table t2 (test int);
38 insert into t2 values (1);
39 drop table t1,t2;