Debian Codegraph @

mysql-test/suite/galera_sr/r/GCF-1051.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
5 SET SESSION wsrep_trx_fragment_size=1;
6 connection node_1;
7 START TRANSACTION;
8 SAVEPOINT A;
9 INSERT INTO t1 VALUES (1);
10 ROLLBACK TO SAVEPOINT A;
11 COMMIT;
12 connection node_1;
13 SELECT COUNT(*) = 0 FROM t1;
14 COUNT(*) = 0
15 1
16 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
17 COUNT(*) = 0
18 1
19 connection node_2;
20 SELECT COUNT(*) = 0 FROM t1;
21 COUNT(*) = 0
22 1
23 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
24 COUNT(*) = 0
25 1
26 connection node_1;
27 SET AUTOCOMMIT=OFF;
28 SAVEPOINT A;
29 INSERT INTO t1 VALUES (2);
30 ROLLBACK TO SAVEPOINT A;
31 COMMIT;
32 connection node_1;
33 SELECT COUNT(*) = 0 FROM t1;
34 COUNT(*) = 0
35 1
36 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
37 COUNT(*) = 0
38 1
39 connection node_2;
40 SELECT COUNT(*) = 0 FROM t1;
41 COUNT(*) = 0
42 1
43 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
44 COUNT(*) = 0
45 1
46 DROP TABLE t1;