Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 SET AUTOCOMMIT=OFF;
4 CREATE TABLE t1 (f1 VARCHAR(10)) ENGINE=InnoDB;
5 SET SESSION wsrep_trx_fragment_size = 1;
6 START TRANSACTION;
7 INSERT INTO t1 VALUES ('%abcdef%');
8 INSERT INTO t1 VALUES ('%abcdef%');
9 INSERT INTO t1 VALUES ('%abcdef%');
10 INSERT INTO t1 VALUES ('%abcdef%');
11 SAVEPOINT A;
12 INSERT INTO t1 VALUES ('xyzxyz');
13 INSERT INTO t1 VALUES ('xyzxyz');
14 INSERT INTO t1 VALUES ('xyzxyz');
15 INSERT INTO t1 VALUES ('xyzxyz');
16 INSERT INTO t1 VALUES ('xyzxyz');
17 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
18 connection node_1a;
19 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%abcdef%';
20 COUNT(*) > 0
21 1
22 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%xyz%';
23 COUNT(*) > 0
24 1
25 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%SAVEPOINT `A`%';
26 COUNT(*) = 1
27 1
28 connection node_1;
29 ROLLBACK TO SAVEPOINT A;
30 connection node_1a;
31 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%abcdef%';
32 COUNT(*) > 0
33 1
34 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%xyz%';
35 COUNT(*) > 0
36 1
37 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%SAVEPOINT `A`%';
38 COUNT(*) = 1
39 1
40 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%ROLLBACK TO `A`%';
41 COUNT(*) = 1
42 0
43 connection node_2;
44 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%abcdef%';
45 COUNT(*) > 0
46 1
47 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%xyz%';
48 COUNT(*) > 0
49 1
50 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%SAVEPOINT `A`%';
51 COUNT(*) = 1
52 1
53 SELECT COUNT(*) = 1 FROM mysql.wsrep_streaming_log WHERE frag LIKE '%ROLLBACK TO `A`%';
54 COUNT(*) = 1
55 0
56 connection node_1;
57 ROLLBACK;
58 connection node_1a;
59 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
60 COUNT(*) = 0
61 1
62 connection node_2;
63 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
64 COUNT(*) = 0
65 1
66 connection node_1;
67 DROP TABLE t1;