Debian Codegraph @

mysql-test/suite/group_replication/t/gr_dependent_ddl_dml_same_server.test

raw
1 ################################################################################
2 # Test executing dependent DDL(s) and DML(s) on same member but in different
3 # sessions in group replication environment:
4 # i) one after the other ii) in parallel
5 # Scenario:
6 # 0. Start 2 servers with GR
7 # 1. Create a table (t1), Insert some data
8 # 2. Execute dependent DDL and DML (one after the other) in different sessions
9 # of server1. Verify data in the group.
10 # 3. Execute dependent DDL and DML (in parallel) in different sessions of
11 # server1. Verify data in the group.
12 # 4. Clean-up
13 ################################################################################
14
15 --source include/have_group_replication_plugin.inc
16 --source include/group_replication.inc
17
18 --echo
19 --echo #1. Create table, insert some data
20 --echo
21 --let $rpl_connection_name= server1
22 --source include/rpl_connection.inc
23
24 CREATE TABLE t1 (a INT PRIMARY KEY);
25 INSERT INTO t1 (a) VALUES (10),(20);
26 --source include/rpl_sync.inc
27
28 --echo
29 --echo #2. Execute dependent DDL and DML (one after the other)
30 --echo # in different sessions, on same member
31 --echo
32 # 2.1 Perform some DMLs on a session in server1
33 BEGIN;
34 INSERT INTO t1 (a) values (30);
35 UPDATE t1 set a= 1 where a= 10;
36 DELETE FROM t1 WHERE a= 20;
37 UPDATE t1 set a= 3 where a= 30;
38 COMMIT;
39
40 # 2.2 Perform some DDLs on server_1
41 --let $rpl_connection_name= server_1
42 --source include/rpl_connection.inc
43 ALTER TABLE t1 add column b varchar(10) DEFAULT 'empty';
44
45 --source include/rpl_sync.inc
46 SELECT * FROM t1;
47 --echo # 2.3 Check that t1 on Server1, Server2 has same data
48 --let $diff_tables= server1:test.t1, server2:test.t1
49 --source include/diff_tables.inc
50
51 --echo
52 --echo # 3. Execute dependent DDL and DML (concurrently)
53 --echo # in different sessions, on same member
54 --echo
55 # 3.1 Perform some DMLs on a session in server1 (but not committed)
56 --let $rpl_connection_name= server1
57 --source include/rpl_connection.inc
58 BEGIN;
59 INSERT INTO t1 (a,b) values (2, 'two');
60 UPDATE t1 set b= 'one' WHERE a= 1;
61 UPDATE t1 set b= 'three' WHERE a=3;
62
63 # 3.2 Perform some DDLs on server_1
64 # This is blocked until the transaction (which is incomplete) is
65 # completed on other session.
66 --let $rpl_connection_name= server_1
67 --source include/rpl_connection.inc
68 SELECT * FROM t1;
69 --send ALTER TABLE t1 DROP b
70
71 --let $rpl_connection_name= server1
72 --source include/rpl_connection.inc
73 COMMIT;
74
75 # Check the contents of the table after reap.
76 --let $rpl_connection_name= server_1
77 --source include/rpl_connection.inc
78 --reap
79 SELECT * FROM t1;
80
81 --source include/rpl_sync.inc
82 --echo # 3.3 Check that t1 on Server1, Server2 has same data
83 --let $diff_tables= server1:test.t1, server2:test.t1
84 --source include/diff_tables.inc
85
86 # Clean-up
87 --let $rpl_connection_name= server1
88 --source include/rpl_connection.inc
89 DROP TABLE t1;
90
91 --source include/group_replication_end.inc