Debian Codegraph @

mysql-test/suite/galera_3nodes/r/galera_certification_ccc.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_3;
6 connection node_1;
7 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
8 SET AUTOCOMMIT=OFF;
9 START TRANSACTION;
10 INSERT INTO t1 VALUES (1);
11 SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
12 VARIABLE_VALUE = 3
13 1
14 connection node_3;
15 SET GLOBAL wsrep_cluster_address = '';
16 connection node_1;
17 INSERT INTO t1 VALUES (2);
18 SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
19 VARIABLE_VALUE = 2
20 1
21 COMMIT;
22 connection node_2;
23 SELECT COUNT(*) = 2 FROM t1;
24 COUNT(*) = 2
25 1
26 connection node_3;
27 connection node_1;
28 DROP TABLE t1;
29 disconnect node_2;
30 disconnect node_1;