Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test the effect of unrelated DDL on a concurrent SR transaction
6 #
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
10 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
11 SET SESSION wsrep_trx_fragment_size = 1;
12
13 SET AUTOCOMMIT=OFF;
14 START TRANSACTION;
15
16 INSERT INTO t1 VALUES (1, 1);
17 INSERT INTO t1 VALUES (2, 2);
18 INSERT INTO t1 VALUES (3, 3);
19 INSERT INTO t1 VALUES (4, 4);
20 INSERT INTO t1 VALUES (5, 5);
21
22 --connection node_2
23 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
24 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
25 --source include/wait_condition.inc
26 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
27
28 ALTER TABLE t2 DROP COLUMN f2;
29
30 # SR applied before the DDL is still visible
31 SELECT COUNT(*) = 5 FROM t1;
32 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
33
34 --connection node_1
35
36 # Transaction can continue, even after the DDL
37 --error 0
38 INSERT INTO t1 VALUES (6, 6);
39
40 --connection node_2
41 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
42 --source include/wait_condition.inc
43
44 --connection node_1
45 COMMIT;
46 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
47
48 --connection node_2
49 SELECT COUNT(*) = 6 FROM t1;
50 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
51
52 DROP TABLE t1;
53 DROP TABLE t2;