Debian Codegraph @

mysql-test/suite/rpl/include/rpl_xa_mixed_engines.inc

raw
1 #
2 # The test file is invoked from rpl.rpl_xa_survive_disconnect_mixed_engines
3 #
4 # The test file is orginized as three sections: setup, run and cleanup.
5 # The main logics is resided in the run section which generates
6 # three types of XA transaction: two kinds of mixed and one on non-transactional
7 # table.
8 #
9 # param $command one of three of: 'setup', 'run' or 'cleanup'
10 # param $xa_terminate how to conclude: 'XA COMMIT' or 'XA ROLLBACK'
11 # param $one_phase 'one_phase' can be opted with XA COMMIT above
12 # param $xa_prepare_opt '1' or empty can be opted to test with and without XA PREPARE
13 # param $xid arbitrary name for xa trx, defaults to 'xa_trx'
14 # Note '' is merely to underline, not a part of the value.
15 #
16
17 if ($command == setup)
18 {
19 # Test randomizes the following variable's value:
20 SET @@session.binlog_direct_non_transactional_updates := if(floor(rand()*10)%2,'ON','OFF');
21 CREATE TABLE t (a INT) ENGINE=innodb;
22 CREATE TABLE tm (a INT) ENGINE=myisam;
23 }
24 if (!$xid)
25 {
26 --let $xid=xa_trx
27 }
28 if ($command == run)
29 {
30 ## Non-temporary table cases
31 # Non transactional table goes first
32 --eval XA START '$xid'
33 --disable_warnings
34 INSERT INTO tm VALUES (1);
35 INSERT INTO t VALUES (1);
36 --enable_warnings
37 --eval XA END '$xid'
38 if ($xa_prepare_opt)
39 {
40 --eval XA PREPARE '$xid'
41 }
42 --eval $xa_terminate '$xid' $one_phase
43
44 # Transactional table goes first
45 --eval XA START '$xid'
46 --disable_warnings
47 INSERT INTO t VALUES (2);
48 INSERT INTO tm VALUES (2);
49 --enable_warnings
50 --eval XA END '$xid'
51 if ($xa_prepare_opt)
52 {
53 --eval XA PREPARE '$xid'
54 }
55 --eval $xa_terminate '$xid' $one_phase
56
57 # The pure non-transactional table
58 --eval XA START '$xid'
59 --disable_warnings
60 INSERT INTO tm VALUES (3);
61 --enable_warnings
62 --eval XA END '$xid'
63 if ($xa_prepare_opt)
64 {
65 --eval XA PREPARE '$xid'
66 }
67 --eval $xa_terminate '$xid' $one_phase
68
69 ## Temporary tables
70 # create outside xa use at the tail
71 CREATE TEMPORARY TABLE tmp_i LIKE t;
72 CREATE TEMPORARY TABLE tmp_m LIKE tm;
73 --eval XA START '$xid'
74 --disable_warnings
75 INSERT INTO t VALUES (4);
76 INSERT INTO tm VALUES (4);
77 INSERT INTO tmp_i VALUES (4);
78 INSERT INTO tmp_m VALUES (4);
79 INSERT INTO t SELECT * FROM tmp_i;
80 INSERT INTO tm SELECT * FROM tmp_m;
81 --enable_warnings
82 --eval XA END '$xid'
83 if ($xa_prepare_opt)
84 {
85 --eval XA PREPARE '$xid'
86 }
87 --eval $xa_terminate '$xid' $one_phase
88
89 # temporary tables at the head
90 --eval XA START '$xid'
91 --disable_warnings
92 INSERT INTO tmp_i VALUES (5);
93 INSERT INTO tmp_m VALUES (5);
94 INSERT INTO t SELECT * FROM tmp_i;
95 INSERT INTO tm SELECT * FROM tmp_m;
96 INSERT INTO t VALUES (5);
97 INSERT INTO tm VALUES (5);
98 --enable_warnings
99 --eval XA END '$xid'
100 if ($xa_prepare_opt)
101 {
102 --eval XA PREPARE '$xid'
103 }
104 --eval $xa_terminate '$xid' $one_phase
105
106 # create inside xa use at the tail
107 DROP TEMPORARY TABLE tmp_i;
108 DROP TEMPORARY TABLE tmp_m;
109
110 --eval XA START '$xid'
111 --disable_warnings
112 INSERT INTO t VALUES (6);
113 INSERT INTO tm VALUES (6);
114 CREATE TEMPORARY TABLE tmp_i LIKE t;
115 CREATE TEMPORARY TABLE tmp_m LIKE tm;
116 INSERT INTO tmp_i VALUES (6);
117 INSERT INTO tmp_m VALUES (6);
118 INSERT INTO t SELECT * FROM tmp_i;
119 INSERT INTO tm SELECT * FROM tmp_m;
120 --enable_warnings
121 --eval XA END '$xid'
122 if ($xa_prepare_opt)
123 {
124 --eval XA PREPARE '$xid'
125 }
126 --eval $xa_terminate '$xid' $one_phase
127
128 # use at the head
129 DROP TEMPORARY TABLE tmp_i;
130 DROP TEMPORARY TABLE tmp_m;
131 --eval XA START '$xid'
132 --disable_warnings
133 CREATE TEMPORARY TABLE tmp_i LIKE t;
134 CREATE TEMPORARY TABLE tmp_m LIKE tm;
135 INSERT INTO tmp_i VALUES (7);
136 INSERT INTO tmp_m VALUES (7);
137 INSERT INTO t SELECT * FROM tmp_i;
138 INSERT INTO tm SELECT * FROM tmp_m;
139 INSERT INTO t VALUES (7);
140 INSERT INTO tm VALUES (7);
141 --enable_warnings
142 --eval XA END '$xid'
143 if ($xa_prepare_opt)
144 {
145 --eval XA PREPARE '$xid'
146 }
147 --eval $xa_terminate '$xid' $one_phase
148
149 # use at the tail and drop
150 --eval XA START '$xid'
151 --disable_warnings
152 INSERT INTO t VALUES (8);
153 INSERT INTO tm VALUES (8);
154 INSERT INTO tmp_i VALUES (8);
155 INSERT INTO tmp_m VALUES (8);
156 INSERT INTO t SELECT * FROM tmp_i;
157 INSERT INTO tm SELECT * FROM tmp_m;
158 DROP TEMPORARY TABLE tmp_i;
159 DROP TEMPORARY TABLE tmp_m;
160 --enable_warnings
161 --eval XA END '$xid'
162 if ($xa_prepare_opt)
163 {
164 --eval XA PREPARE '$xid'
165 }
166 --eval $xa_terminate '$xid' $one_phase
167
168 ## Ineffective transactional table operation case
169
170 --eval XA START '$xid'
171 UPDATE t SET a = 99 where a = -1;
172 --eval XA END '$xid'
173 if ($xa_prepare_opt)
174 {
175 --eval XA PREPARE '$xid'
176 }
177 --eval $xa_terminate '$xid' $one_phase
178 }
179
180 if ($command == cleanup)
181 {
182 DROP TABLE t, tm;
183 }