Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate Group Replication correct behaviour when present to DDL and
3 # autocommit= 0.
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. With all members ONLINE. On M1 firstly create tables and insert data, then
8 # execute several DDL statements when autocommit=0. DDL cases:-
9 # - CREATE TRIGGER
10 # - DROP TRIGGER
11 # - CREATE INDEX
12 # - DROP INDEX
13 # 2. Check consistency by comparing data and gtid_executed set in M1 and M2.
14 # 3. Check binlog events on both M1 and M2.
15 # 4. Clean up.
16 ################################################################################
17 --source include/set_privilege_checks_user_as_system_user.inc
18 --source include/have_group_replication_plugin.inc
19 --source include/group_replication.inc
20
21
22 --echo
23 --echo #############################################################
24 --echo # EXECUTE SEVERAL DDL STATEMENTS WHEN AUTOCOMMIT= 0
25 --echo #############################################################
26 --connection server1
27 CREATE TABLE tt_1 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB;
28 CREATE TABLE tt_2 (ddl_case INT, PRIMARY KEY(ddl_case)) ENGINE=InnoDB;
29
30 INSERT INTO tt_1(ddl_case) VALUES(0);
31 INSERT INTO tt_2(ddl_case) VALUES(0);
32
33 SET AUTOCOMMIT= 0;
34 --let $ddl_cases= 4
35 while ($ddl_cases >= 1)
36 {
37 --echo
38 --echo #############################################################
39 --echo # DDL case: $ddl_cases
40
41 --disable_query_log
42 --let $first_binlog_position= query_get_value("SHOW MASTER STATUS", Position, 1)
43 --enable_query_log
44
45 --eval INSERT INTO tt_1(ddl_case) VALUES ($ddl_cases)
46
47 if ($ddl_cases == 4)
48 {
49 --let $cmd= CREATE TRIGGER tr AFTER INSERT ON tt_1 FOR EACH ROW UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case
50 }
51
52 if ($ddl_cases == 3)
53 {
54 --let $cmd= DROP TRIGGER tr
55 }
56
57 if ($ddl_cases == 2)
58 {
59 --let $cmd= CREATE INDEX ix ON tt_1(ddl_case)
60 }
61
62 if ($ddl_cases == 1)
63 {
64 --let $cmd= DROP INDEX ix ON tt_1
65 }
66
67 --eval $cmd
68
69 --disable_query_log
70 --let $event_commit= query_get_value("SHOW BINLOG EVENTS FROM $first_binlog_position", Info, 4)
71 --enable_query_log
72
73 --let $binlog_start= $first_binlog_position;
74 --source include/show_binlog_events.inc
75 --dec $ddl_cases
76 }
77 SET AUTOCOMMIT= 1;
78
79
80 --echo
81 --echo #############################################################
82 --echo # CHECK CONSISTENCY
83 --echo #############################################################
84 --source include/rpl_sync.inc
85
86 --let $diff_tables= server1:tt_1,server2:tt_1
87 --source include/diff_tables.inc
88
89 --connection server1
90 --let $server1_gtid_executed= `SELECT @@GLOBAL.GTID_EXECUTED`
91 --connection server2
92 --let $server2_gtid_executed= `SELECT @@GLOBAL.GTID_EXECUTED`
93 --let $assert_text= 'server1 and server2 GTID_EXECUTED must be equal'
94 --let $assert_cond= "$server1_gtid_executed" = "$server2_gtid_executed"
95 --source include/assert.inc
96
97
98 --echo
99 --echo #############################################################
100 --echo # BINLOG CONTENT
101 --echo #############################################################
102 --echo SERVER 1
103 --connection server1
104 --let $binlog_start=
105 --let $keep_gtid_events= 1
106 --source include/show_binlog_events.inc
107
108 --echo SERVER 2
109 --connection server2
110 --source include/show_binlog_events.inc
111
112
113 --echo
114 --echo #############################################################
115 --echo # CLEAN
116 --echo #############################################################
117 DROP TABLE tt_1;
118 DROP TABLE tt_2;
119 --source include/group_replication_end.inc