Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/galera_sr_join_slave.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connection node_1;
5 connection node_1;
6 connection node_2;
7 connection node_3;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 connection node_2;
10 connection node_1;
11 SET SESSION wsrep_trx_fragment_size = 1;
12 SET AUTOCOMMIT=OFF;
13 START TRANSACTION;
14 INSERT INTO t1 VALUES (1);
15 INSERT INTO t1 VALUES (2);
16 INSERT INTO t1 VALUES (3);
17 INSERT INTO t1 VALUES (4);
18 INSERT INTO t1 VALUES (5);
19 connection node_2;
20 # restart
21 connection node_1;
22 INSERT INTO t1 VALUES (6);
23 INSERT INTO t1 VALUES (7);
24 INSERT INTO t1 VALUES (8);
25 INSERT INTO t1 VALUES (9);
26 INSERT INTO t1 VALUES (10);
27 COMMIT;
28 SELECT COUNT(*) = 10 FROM t1;
29 COUNT(*) = 10
30 1
31 connection node_2;
32 SELECT COUNT(*) = 10 FROM t1;
33 COUNT(*) = 10
34 1
35 connection node_3;
36 SELECT COUNT(*) = 10 FROM t1;
37 COUNT(*) = 10
38 1
39 connection node_1;
40 DROP TABLE t1;