Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_kill_connection.result

raw
1 connection node_2;
2 connection node_1;
3 SET SESSION wsrep_trx_fragment_size = 1;
4 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
5 SET AUTOCOMMIT=OFF;
6 START TRANSACTION;
7 INSERT INTO t1 VALUES (1);
8 INSERT INTO t1 VALUES (2);
9 INSERT INTO t1 VALUES (3);
10 INSERT INTO t1 VALUES (4);
11 INSERT INTO t1 VALUES (5);
12 connection node_2;
13 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
14 connection node_1;
15 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
16 connection node_2;
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (1);
20 INSERT INTO t1 VALUES (2);
21 INSERT INTO t1 VALUES (3);
22 INSERT INTO t1 VALUES (4);
23 INSERT INTO t1 VALUES (5);
24 COMMIT;
25 SELECT COUNT(*) = 5 FROM t1;
26 COUNT(*) = 5
27 1
28 connection node_1a;
29 SELECT COUNT(*) = 5 FROM t1;
30 COUNT(*) = 5
31 1
32 DROP TABLE t1;