Debian Codegraph @

mysql-test/suite/galera/t/MDEV-31272.test

raw
1 #
2 # MDEV-31272: Statement rollback causes empty writeset replication
3 #
4
5 --source include/galera_cluster.inc
6
7 #
8 # Case 1: Multi statement transaction
9 #
10 --connection node_1
11 CREATE TABLE t1 (f1 int primary key, f2 int);
12 INSERT INTO t1 VALUES (1,0);
13
14 --let $replicated_old = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_replicated'`
15
16 BEGIN;
17 --error ER_DUP_ENTRY
18 INSERT INTO t1 VALUES (2,4),(1,1);
19 COMMIT;
20
21 --let $replicated_new = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_replicated'`
22
23 --disable_query_log
24 --eval SELECT $replicated_new - $replicated_old AS 'Writesets replicated (expect 0)';
25 --enable_query_log
26
27 --connection node_1
28 SELECT * FROM t1;
29 --connection node_2
30 SELECT * FROM t1;
31
32 DROP TABLE t1;
33
34
35 #
36 # Case 2: autocommit statement
37 #
38 --connection node_1
39 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER);
40 INSERT INTO t1 VALUES (1,0);
41
42 --let $replicated_old = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_replicated'`
43
44 --error ER_DUP_ENTRY
45 INSERT INTO t1 VALUES (2,4), (1,1);
46
47 --let $replicated_new = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_replicated'`
48
49 --disable_query_log
50 --eval SELECT $replicated_new - $replicated_old AS 'Writesets replicated (expect 0)';
51 --enable_query_log
52
53 --connection node_1
54 SELECT * FROM t1;
55 --connection node_2
56 SELECT * FROM t1;
57
58 DROP TABLE t1;