Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-1051.test

raw
1 #
2 # Test the case where SR is rolled back to savepoint that points to the
3 # very beginning of the transaction. This results in regular rollback
4 # rather than rollback to savepoint.
5 #
6
7 --source include/galera_cluster.inc
8 --source include/have_debug_sync.inc
9
10 --connection node_1
11 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
12 SET SESSION wsrep_trx_fragment_size=1;
13
14 #
15 # Test 1: regular transaction
16 #
17 --connection node_1
18 START TRANSACTION;
19 SAVEPOINT A;
20 INSERT INTO t1 VALUES (1);
21 ROLLBACK TO SAVEPOINT A;
22 COMMIT;
23
24 --connection node_1
25 SELECT COUNT(*) = 0 FROM t1;
26 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
27
28 --connection node_2
29 SELECT COUNT(*) = 0 FROM t1;
30 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
31
32 #
33 # Test 2: AUTOCOMMIT OFF
34 #
35 --connection node_1
36 SET AUTOCOMMIT=OFF;
37 SAVEPOINT A;
38 INSERT INTO t1 VALUES (2);
39 ROLLBACK TO SAVEPOINT A;
40 COMMIT;
41
42 --connection node_1
43 SELECT COUNT(*) = 0 FROM t1;
44 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
45
46 --connection node_2
47 SELECT COUNT(*) = 0 FROM t1;
48 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
49
50 DROP TABLE t1;