Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
5 SET SESSION wsrep_trx_fragment_size = 3;
6 SHOW WARNINGS;
7 Level Code Message
8 SET SESSION wsrep_trx_fragment_unit = 'statements';
9 SHOW WARNINGS;
10 Level Code Message
11 connection node_1;
12 SET AUTOCOMMIT=OFF;
13 START TRANSACTION;
14 INSERT INTO t1 VALUES (1);
15 # Expect nothing is replicated yet, so far we have 2 statements
16 connection node_2;
17 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
18 SELECT COUNT(*) AS EXPECT_0 FROM t1;
19 EXPECT_0
20 0
21 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
22 EXPECT_0
23 0
24 connection node_1;
25 INSERT INTO t1 VALUES (2);
26 # Expect 2 rows in t1 and 1 fragment in SR table
27 connection node_2;
28 SELECT COUNT(*) AS EXPECT_2 FROM t1;
29 EXPECT_2
30 2
31 SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_streaming_log;
32 EXPECT_1
33 1
34 connection node_1;
35 INSERT INTO t1 VALUES (3);
36 INSERT INTO t1 VALUES (4);
37 INSERT INTO t1 VALUES (5);
38 # Expect 5 rows in t1 and 2 fragments in SR table
39 connection node_2;
40 SELECT COUNT(*) AS EXPECT_5 FROM t1;
41 EXPECT_5
42 5
43 SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_streaming_log;
44 EXPECT_2
45 2
46 connection node_1;
47 COMMIT;
48 # Expect 5 rows in t1 and empty SR table
49 SELECT COUNT(*) AS EXPECT_5 FROM t1;
50 EXPECT_5
51 5
52 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
53 EXPECT_0
54 0
55 connection node_2;
56 SELECT COUNT(*) AS EXPECT_5 FROM t1;
57 EXPECT_5
58 5
59 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
60 EXPECT_0
61 0
62 DROP TABLE t1;