Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_rollback_savepoint.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test that ROLLBACK TO SAVEPOINT works correctly with streaming replication
6 #
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER, f2 VARCHAR(10)) ENGINE=InnoDB;
10 SET SESSION wsrep_trx_fragment_size = 1;
11 SET AUTOCOMMIT=OFF;
12 START TRANSACTION;
13 INSERT INTO t1 VALUES (1, 'a');
14 INSERT INTO t1 VALUES (2, 'a');
15 INSERT INTO t1 VALUES (3, 'a');
16 INSERT INTO t1 VALUES (4, 'a');
17 INSERT INTO t1 VALUES (5, 'a');
18 --connection node_2
19 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
20 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
21 --source include/wait_condition.inc
22
23 --connection node_1
24 SAVEPOINT s1;
25 INSERT INTO t1 VALUES (11, 'b');
26 INSERT INTO t1 VALUES (12, 'b');
27 INSERT INTO t1 VALUES (13, 'b');
28 INSERT INTO t1 VALUES (14, 'b');
29 INSERT INTO t1 VALUES (15, 'b');
30
31 --connection node_2
32 --let $wait_condition = SELECT COUNT(*) > 5 FROM t1;
33 --source include/wait_condition.inc
34
35 --connection node_1
36 ROLLBACK TO SAVEPOINT s1;
37
38 INSERT INTO t1 VALUES (21, 'c');
39 INSERT INTO t1 VALUES (22, 'c');
40 INSERT INTO t1 VALUES (23, 'c');
41 INSERT INTO t1 VALUES (24, 'c');
42 INSERT INTO t1 VALUES (25, 'c');
43
44 --connection node_2
45 SELECT COUNT(*) = 5 FROM t1 WHERE f2 = 'a';
46 SELECT COUNT(*) = 0 FROM t1 WHERE f2 = 'b';
47 SELECT COUNT(*) = 5 FROM t1 WHERE f2 = 'c';
48
49 --connection node_1
50 COMMIT;
51 DROP TABLE t1;