Debian Codegraph @

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

raw
1 # ==== Purpose ====
2 #
3 # This is an auxiliary file used by rpl_mixing_engines.test. It
4 # executes SQL statements according to a format string, as specified in
5 # rpl_mixing_engines.test. In addition, it accepts the special format
6 # strings 'configure' and 'clean', used before and after everything else.
7 #
8 # ==== Usage ====
9 #
10 # --let $commands= command1 command2 ...
11 # --let $database_name= name
12 # [--let $verbose= 1]
13 # --source include/rpl_mixing_engines.inc
14 #
15 # Parameters:
16 #
17 # $commands
18 # Space-separated list of commands. See rpl_mixing_engines.test
19 # for a list of all commands.
20 #
21 # $database_name
22 # Name of database to use. If $commands is 'configure' or
23 # 'clean', and the database name is not 'test', then the
24 # database is created or dropped, respectively.
25 #
26 # $verbose
27 # By default, show_binlog_events.inc is sourced after all
28 # commands have been processed, showing the result of all
29 # commands. If this flag is set, then show_binlog_events.inc is
30 # also sourced once after each command, showing only the result
31 # of that command.
32
33 --echo rpl_mixing_engines.inc [commands=$commands]
34
35 --let $rme_initial_commands= $commands
36
37 if ($commands == 'configure')
38 {
39 connection master;
40
41 --disable_query_log
42 if ($database_name != 'test')
43 {
44 --eval CREATE DATABASE $database_name
45 }
46 --eval use $database_name
47 --enable_query_log
48
49 eval CREATE TABLE nt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
50 eval CREATE TABLE nt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
51 eval CREATE TABLE nt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
52 eval CREATE TABLE nt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
53 eval CREATE TABLE nt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
54 eval CREATE TABLE nt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
55 eval CREATE TABLE tt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = $engine_type;
56 eval CREATE TABLE tt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = $engine_type;
57 eval CREATE TABLE tt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = $engine_type;
58 eval CREATE TABLE tt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = $engine_type;
59 eval CREATE TABLE tt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = $engine_type;
60 eval CREATE TABLE tt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = $engine_type;
61
62 INSERT INTO nt_1(trans_id, stmt_id) VALUES(1,1);
63 INSERT INTO nt_2(trans_id, stmt_id) VALUES(1,1);
64 INSERT INTO nt_3(trans_id, stmt_id) VALUES(1,1);
65 INSERT INTO nt_4(trans_id, stmt_id) VALUES(1,1);
66 INSERT INTO nt_5(trans_id, stmt_id) VALUES(1,1);
67 INSERT INTO nt_6(trans_id, stmt_id) VALUES(1,1);
68
69 INSERT INTO tt_1(trans_id, stmt_id) VALUES(1,1);
70 INSERT INTO tt_2(trans_id, stmt_id) VALUES(1,1);
71 INSERT INTO tt_3(trans_id, stmt_id) VALUES(1,1);
72 INSERT INTO tt_4(trans_id, stmt_id) VALUES(1,1);
73 INSERT INTO tt_5(trans_id, stmt_id) VALUES(1,1);
74 INSERT INTO tt_6(trans_id, stmt_id) VALUES(1,1);
75
76 DELIMITER |;
77
78 CREATE PROCEDURE pc_i_tt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
79 BEGIN
80 DECLARE in_stmt_id INTEGER;
81 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
82 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
83 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
84 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
85 END|
86
87 CREATE PROCEDURE pc_i_nt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
88 BEGIN
89 DECLARE in_stmt_id INTEGER;
90 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
91 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
92 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
93 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
94 END|
95
96 CREATE FUNCTION fc_i_tt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
97 BEGIN
98 DECLARE in_stmt_id INTEGER;
99 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
100 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
101 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
102 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
103 RETURN "fc_i_tt_5_suc";
104 END|
105
106 CREATE FUNCTION fc_i_nt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
107 BEGIN
108 DECLARE in_stmt_id INTEGER;
109 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
110 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
111 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
112 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
113 RETURN "fc_i_nt_5_suc";
114 END|
115
116 CREATE FUNCTION fc_i_nt_3_tt_3_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
117 BEGIN
118 DECLARE in_stmt_id INTEGER;
119 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= p_trans_id;
120 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
121 INSERT INTO nt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
122
123 SELECT max(stmt_id) INTO in_stmt_id FROM tt_3 WHERE trans_id= p_trans_id;
124 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
125 INSERT INTO tt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
126 RETURN "fc_i_nt_3_tt_3_suc";
127 END|
128
129 CREATE TRIGGER tr_i_tt_3_to_nt_3 AFTER INSERT ON tt_3 FOR EACH ROW
130 BEGIN
131 DECLARE in_stmt_id INTEGER;
132 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= NEW.trans_id;
133 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
134 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
135 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
136 END|
137
138 CREATE TRIGGER tr_i_nt_4_to_tt_4 AFTER INSERT ON nt_4 FOR EACH ROW
139 BEGIN
140 DECLARE in_stmt_id INTEGER;
141 SELECT max(stmt_id) INTO in_stmt_id FROM tt_4 WHERE trans_id= NEW.trans_id;
142 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
143 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
144 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
145 END|
146
147 CREATE TRIGGER tr_i_tt_5_to_tt_6 AFTER INSERT ON tt_5 FOR EACH ROW
148 BEGIN
149 DECLARE in_stmt_id INTEGER;
150 SELECT max(stmt_id) INTO in_stmt_id FROM tt_6 WHERE trans_id= NEW.trans_id;
151 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id, 1), 1) INTO in_stmt_id;
152 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
153 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
154 END|
155
156 CREATE TRIGGER tr_i_nt_5_to_nt_6 AFTER INSERT ON nt_5 FOR EACH ROW
157 BEGIN
158 DECLARE in_stmt_id INTEGER;
159 SELECT max(stmt_id) INTO in_stmt_id FROM nt_6 WHERE trans_id= NEW.trans_id;
160 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
161 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
162 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
163 END|
164
165 DELIMITER ;|
166
167 let $pos_trans_command= query_get_value("SHOW MASTER STATUS", Position, 1);
168
169 let $trans_id= 7;
170 let $tb_id= 1;
171 let $stmt_id= 1;
172 --let $commands=
173 let $sn= 0;
174 }
175
176 if ($commands == 'clean')
177 {
178 connection master;
179
180 --disable_query_log
181 --eval use $database_name
182 --enable_query_log
183
184 DROP TABLE tt_1;
185 DROP TABLE tt_2;
186 DROP TABLE tt_3;
187 DROP TABLE tt_4;
188 DROP TABLE tt_5;
189 DROP TABLE tt_6;
190
191 DROP TABLE nt_1;
192 DROP TABLE nt_2;
193 DROP TABLE nt_3;
194 DROP TABLE nt_4;
195 DROP TABLE nt_5;
196 DROP TABLE nt_6;
197
198 DROP PROCEDURE pc_i_tt_5_suc;
199 DROP PROCEDURE pc_i_nt_5_suc;
200 DROP FUNCTION fc_i_tt_5_suc;
201 DROP FUNCTION fc_i_nt_5_suc;
202 DROP FUNCTION fc_i_nt_3_tt_3_suc;
203
204 --disable_query_log
205 if ($database_name != 'test')
206 {
207 --eval DROP DATABASE $database_name
208 }
209 --enable_query_log
210
211 sync_slave_with_master;
212
213 --let $commands=
214 }
215
216 --disable_ps2_protocol
217 while ($commands != '')
218 {
219 --disable_query_log
220 --eval use $database_name
221 --enable_query_log
222
223 --disable_query_log
224 --let $command= `SELECT SUBSTRING_INDEX('$commands', ' ', 1)`
225 if ($verbose)
226 {
227 --echo -b-b-b-b-b-b-b-b-b-b-b- >> $command << -b-b-b-b-b-b-b-b-b-b-b-
228 let $pos_command= query_get_value("SHOW MASTER STATUS", Position, 1);
229 }
230 --enable_query_log
231 if ($command == 'B')
232 {
233 eval BEGIN;
234 }
235 if ($command == 'T')
236 {
237 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
238 eval INSERT INTO tt_1(trans_id, stmt_id) VALUES ($trans_id, $stmt_id);
239 inc $stmt_id;
240 }
241 if ($command == 'T-trig')
242 {
243 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
244 eval INSERT INTO tt_5(trans_id, stmt_id) VALUES ($trans_id, $stmt_id);
245 inc $stmt_id;
246 }
247 if ($command == 'T-func')
248 {
249 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
250 eval SELECT fc_i_tt_5_suc ($trans_id, $stmt_id);
251 inc $stmt_id;
252 }
253 if ($command == 'T-proc')
254 {
255 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
256 eval CALL pc_i_tt_5_suc ($trans_id, $stmt_id);
257 inc $stmt_id;
258 }
259 if ($command == 'eT')
260 {
261 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
262 let $old_trans_id= `SELECT max(trans_id) from tt_1`;
263 let $old_stmt_id= `SELECT max(stmt_id) from tt_1 where trans_id= $old_trans_id`;
264 --error ER_DUP_ENTRY, ER_DUP_KEY
265 eval INSERT INTO tt_1(trans_id, stmt_id) VALUES ($old_trans_id, $old_stmt_id);
266 inc $stmt_id;
267 }
268 if ($command == 'Te')
269 {
270 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
271 let $old_trans_id= `SELECT max(trans_id) from tt_1`;
272 let $old_stmt_id= `SELECT max(stmt_id) from tt_1 where trans_id= $old_trans_id`;
273 --error ER_DUP_ENTRY, ER_DUP_KEY
274 eval INSERT INTO tt_1(trans_id, stmt_id) VALUES ($trans_id, $stmt_id), ($old_trans_id, $old_stmt_id);
275 inc $stmt_id;
276 }
277 if ($command == 'Te-trig')
278 {
279 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
280 let $old_trans_id= `SELECT max(trans_id) from tt_5`;
281 let $old_stmt_id= `SELECT max(stmt_id) from tt_5 where trans_id= $old_trans_id`;
282 --error ER_DUP_ENTRY, ER_DUP_KEY
283 eval INSERT INTO tt_5(trans_id, stmt_id) VALUES ($trans_id, $stmt_id), ($old_trans_id, $old_stmt_id);
284 inc $stmt_id;
285 }
286 if ($command == 'Te-func')
287 {
288 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
289 let $old_trans_id= `SELECT max(trans_id) from tt_1`;
290 let $old_stmt_id= `SELECT max(stmt_id) from tt_1 where trans_id= $old_trans_id`;
291 --error ER_DUP_ENTRY, ER_DUP_KEY
292 eval INSERT INTO tt_1(trans_id, stmt_id, info) VALUES ($trans_id, $stmt_id, ''), ($old_trans_id, $old_stmt_id, fc_i_tt_5_suc ($trans_id, $stmt_id));
293 inc $stmt_id;
294 }
295 if ($command == 'N')
296 {
297 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
298 eval INSERT INTO nt_1(trans_id, stmt_id) VALUES ($trans_id, $stmt_id);
299 inc $stmt_id;
300 }
301 if ($command == 'N-trig')
302 {
303 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
304 eval INSERT INTO nt_5(trans_id, stmt_id) VALUES ($trans_id, $stmt_id);
305 inc $stmt_id;
306 }
307 if ($command == 'N-func')
308 {
309 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
310 eval SELECT fc_i_nt_5_suc ($trans_id, $stmt_id);
311 inc $stmt_id;
312 }
313 if ($command == 'N-proc')
314 {
315 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
316 eval CALL pc_i_nt_5_suc ($trans_id, $stmt_id);
317 inc $stmt_id;
318 }
319 if ($command == 'eN')
320 {
321 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
322 let $old_trans_id= `SELECT max(trans_id) from nt_1`;
323 let $old_stmt_id= `SELECT max(stmt_id) from nt_1 where trans_id= $old_trans_id`;
324 --error ER_DUP_ENTRY, ER_DUP_KEY
325 eval INSERT INTO nt_1(trans_id, stmt_id) VALUES ($old_trans_id, $old_stmt_id);
326 inc $stmt_id;
327 }
328 if ($command == 'Ne')
329 {
330 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
331 let $old_trans_id= `SELECT max(trans_id) from nt_1`;
332 let $old_stmt_id= `SELECT max(stmt_id) from nt_1 where trans_id= $old_trans_id`;
333 --error ER_DUP_ENTRY, ER_DUP_KEY
334 eval INSERT INTO nt_1(trans_id, stmt_id) VALUES ($trans_id, $stmt_id), ($old_trans_id, $old_stmt_id);
335 inc $stmt_id;
336 }
337 if ($command == 'Ne-trig')
338 {
339 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
340 let $old_trans_id= `SELECT max(trans_id) from nt_5`;
341 let $old_stmt_id= `SELECT max(stmt_id) from nt_5 where trans_id= $old_trans_id`;
342 --error ER_DUP_ENTRY, ER_DUP_KEY
343 eval INSERT INTO nt_5(trans_id, stmt_id) VALUES ($trans_id, $stmt_id), ($old_trans_id, $old_stmt_id);
344 inc $stmt_id;
345 }
346 if ($command == 'Ne-func')
347 {
348 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
349 let $old_trans_id= `SELECT max(trans_id) from nt_1`;
350 let $old_stmt_id= `SELECT max(stmt_id) from nt_1 where trans_id= $old_trans_id`;
351 --error ER_DUP_ENTRY, ER_DUP_KEY
352 eval INSERT INTO nt_1(trans_id, stmt_id, info) VALUES ($trans_id, $stmt_id, ''), ($old_trans_id, $old_stmt_id, fc_i_nt_5_suc ($trans_id, $stmt_id));
353 inc $stmt_id;
354 }
355 if ($command == 'tN')
356 {
357 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
358 eval INSERT INTO nt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM tt_1;
359 inc $stmt_id;
360 }
361 if ($command == 'tNe')
362 {
363 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
364 let $old_trans_id= `SELECT max(trans_id) from nt_1`;
365 let $old_stmt_id= `SELECT max(stmt_id) from nt_1 where trans_id= $old_trans_id`;
366 --error ER_DUP_ENTRY, ER_DUP_KEY
367 eval INSERT INTO nt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM tt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM tt_1;
368 inc $stmt_id;
369 }
370 if ($command == 'nT')
371 {
372 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
373 eval INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1;
374 inc $stmt_id;
375 }
376 if ($command == 'nTe')
377 {
378 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
379 let $old_trans_id= `SELECT max(trans_id) from tt_1`;
380 let $old_stmt_id= `SELECT max(stmt_id) from tt_1 where trans_id= $old_trans_id`;
381 --error ER_DUP_ENTRY, ER_DUP_KEY
382 eval INSERT INTO tt_1(trans_id, stmt_id, info) SELECT $trans_id, $stmt_id, COUNT(*) FROM nt_1 UNION SELECT $old_trans_id, $old_stmt_id, COUNT(*) FROM nt_1;
383 inc $stmt_id;
384 }
385 if ($command == 'NT')
386 {
387 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
388 eval UPDATE nt_3, tt_3 SET nt_3.info= "new text $trans_id --> $stmt_id", tt_3.info= "new text $trans_id --> $stmt_id" where nt_3.trans_id = tt_3.trans_id and tt_3.trans_id = 1;
389 inc $stmt_id;
390 }
391 if ($command == 'NT-trig')
392 {
393 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
394 eval INSERT INTO nt_4(trans_id, stmt_id) VALUES ($trans_id, $stmt_id);
395 inc $stmt_id;
396 }
397 if ($command == 'NT-func')
398 {
399 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
400 eval INSERT INTO nt_5(trans_id, stmt_id, info) VALUES ($trans_id, $stmt_id, fc_i_tt_5_suc($trans_id, $stmt_id));
401 inc $stmt_id;
402 }
403 if ($command == 'NeT-trig')
404 {
405 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
406 let $old_trans_id= `SELECT max(trans_id) from nt_4`;
407 let $old_stmt_id= `SELECT max(stmt_id) from nt_4 where trans_id= $old_trans_id`;
408 --error ER_DUP_ENTRY, ER_DUP_KEY
409 eval INSERT INTO nt_4(trans_id, stmt_id) VALUES ($trans_id, $stmt_id), ($old_trans_id, $old_stmt_id);
410 inc $stmt_id;
411 }
412 if ($command == 'NeT-func')
413 {
414 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
415 let $old_trans_id= `SELECT max(trans_id) from nt_5`;
416 let $old_stmt_id= `SELECT max(stmt_id) from nt_5 where trans_id= $old_trans_id`;
417 --error ER_DUP_ENTRY, ER_DUP_KEY
418 eval INSERT INTO nt_5(trans_id, stmt_id, info) VALUES ($trans_id, $stmt_id, ''), ($old_trans_id, $old_stmt_id, fc_i_tt_5_suc ($trans_id, $stmt_id));
419 inc $stmt_id;
420 }
421 if ($command == 'TN')
422 {
423 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
424 eval UPDATE tt_4, nt_4 SET tt_4.info= "new text $trans_id --> $stmt_id", nt_4.info= "new text $trans_id --> $stmt_id" where nt_4.trans_id = tt_4.trans_id and tt_4.trans_id = 1;
425 inc $stmt_id;
426 }
427 if ($command == 'TN-trig')
428 {
429 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
430 eval INSERT INTO tt_3(trans_id, stmt_id) VALUES ($trans_id, $stmt_id);
431 inc $stmt_id;
432 }
433 if ($command == 'TN-func')
434 {
435 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
436 eval INSERT INTO tt_5(trans_id, stmt_id, info) VALUES ($trans_id, $stmt_id, fc_i_nt_5_suc($trans_id, $stmt_id));
437 inc $stmt_id;
438 }
439 if ($command == 'TeN-trig')
440 {
441 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
442 let $old_trans_id= `SELECT max(trans_id) from tt_3`;
443 let $old_stmt_id= `SELECT max(stmt_id) from tt_3 where trans_id= $old_trans_id`;
444 --error ER_DUP_ENTRY, ER_DUP_KEY
445 eval INSERT INTO tt_3(trans_id, stmt_id) VALUES ($trans_id, $stmt_id), ($old_trans_id, $old_stmt_id);
446 inc $stmt_id;
447 }
448 if ($command == 'TeN-func')
449 {
450 #--echo DEBUG-- (trans_id, stmt_id) --> ($trans_id, $stmt_id)
451 let $old_trans_id= `SELECT max(trans_id) from tt_5`;
452 let $old_stmt_id= `SELECT max(stmt_id) from tt_5 where trans_id= $old_trans_id`;
453 --error ER_DUP_ENTRY, ER_DUP_KEY
454 eval INSERT INTO tt_5(trans_id, stmt_id, info) VALUES ($trans_id, $stmt_id, ''), ($old_trans_id, $old_stmt_id, fc_i_nt_5_suc ($trans_id, $stmt_id));
455 inc $stmt_id;
456 }
457 if ($command == 'set-T')
458 {
459 --eval SET @var= fc_i_tt_5_suc($trans_id, $stmt_id)
460 inc $stmt_id;
461 }
462 if ($command == 'set-N')
463 {
464 --eval SET @var= fc_i_nt_5_suc($trans_id, $stmt_id)
465 inc $stmt_id;
466 }
467 if ($command == 'set-NT')
468 {
469 --eval SET @var= fc_i_nt_3_tt_3_suc($trans_id, $stmt_id)
470 inc $stmt_id;
471 }
472 if ($command == 'CS-T->T')
473 {
474 --eval CREATE TABLE tt_xx_$tb_id (PRIMARY KEY(trans_id, stmt_id)) engine=$engine_type SELECT * FROM tt_1;
475 }
476 if ($command == 'CS-N->N')
477 {
478 --eval CREATE TABLE nt_xx_$tb_id (PRIMARY KEY(trans_id, stmt_id)) engine=MyIsam SELECT * FROM nt_1;
479 }
480 if ($command == 'CS-T->N')
481 {
482 --eval CREATE TABLE tt_xx_$tb_id (PRIMARY KEY(trans_id, stmt_id)) engine=$engine_type SELECT * FROM nt_1;
483 }
484 if ($command == 'CS-N->T')
485 {
486 --eval CREATE TABLE nt_xx_$tb_id (PRIMARY KEY(trans_id, stmt_id)) engine=MyIsam SELECT * FROM tt_1;
487 }
488 if ($command == 'CSe-T->T')
489 {
490 --error ER_DUP_ENTRY, ER_DUP_KEY
491 --eval CREATE TABLE tt_xx_$tb_id (PRIMARY KEY (stmt_id)) engine=$engine_type SELECT stmt_id FROM tt_1;
492 }
493 if ($command == 'CSe-N->N')
494 {
495 --error ER_DUP_ENTRY, ER_DUP_KEY
496 --eval CREATE TABLE nt_xx_$tb_id (PRIMARY KEY (stmt_id)) engine=MyIsam SELECT stmt_id FROM nt_1;
497 }
498 if ($command == 'CSe-T->N')
499 {
500 --error ER_DUP_ENTRY, ER_DUP_KEY
501 --eval CREATE TABLE tt_xx_$tb_id (PRIMARY KEY (stmt_id)) engine=$engine_type SELECT stmt_id FROM nt_1;
502 }
503 if ($command == 'CSe-N->T')
504 {
505 --error ER_DUP_ENTRY, ER_DUP_KEY
506 --eval CREATE TABLE nt_xx_$tb_id (PRIMARY KEY (stmt_id)) engine=MyIsam SELECT stmt_id FROM tt_1;
507 }
508 if ($command == 'CT')
509 {
510 --eval CREATE TEMPORARY TABLE tt_xx_$tb_id (a int) engine=$engine_type;
511 }
512 if ($command == 'IS-T<-N')
513 {
514 --eval INSERT INTO tt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, stmt_id, USER() FROM nt_1;
515 }
516 if ($command == 'ISe-T<-N')
517 {
518 --error ER_DUP_ENTRY, ER_DUP_KEY
519 --eval INSERT INTO tt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, trans_id, USER() FROM nt_1;
520 }
521 if ($command == 'IS-N<-T')
522 {
523 --eval INSERT INTO nt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, stmt_id, USER() FROM tt_1;
524 }
525 if ($command == 'ISe-N<-T')
526 {
527 --error ER_DUP_ENTRY, ER_DUP_KEY
528 --eval INSERT INTO nt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, trans_id, USER() FROM tt_1;
529 }
530 if ($command == 'IS-T<-T')
531 {
532 --eval INSERT INTO tt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, stmt_id, USER() FROM tt_1;
533 }
534 if ($command == 'ISe-T<-T')
535 {
536 --error ER_DUP_ENTRY, ER_DUP_KEY
537 --eval INSERT INTO tt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, trans_id, USER() FROM tt_1;
538 }
539 if ($command == 'IS-N<-N')
540 {
541 --eval INSERT INTO nt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, stmt_id, USER() FROM nt_1;
542 }
543 if ($command == 'ISe-N<-N')
544 {
545 --error ER_DUP_ENTRY, ER_DUP_KEY
546 --eval INSERT INTO nt_xx_$tb_id(trans_id, stmt_id, info) SELECT trans_id, trans_id, USER() FROM nt_1;
547 }
548 if ($command == 'trunc-CS-T')
549 {
550 eval TRUNCATE TABLE tt_xx_$tb_id;
551 }
552 if ($command == 'trunc-CS-N')
553 {
554 eval TRUNCATE TABLE nt_xx_$tb_id;
555 }
556 if ($command == 'trunc-CT')
557 {
558 eval TRUNCATE TABLE tt_xx_$tb_id;
559 }
560 if ($command == 'drop-CS')
561 {
562 --disable_warnings
563 eval DROP TABLE IF EXISTS tt_xx_$tb_id, nt_xx_$tb_id;
564 inc $tb_id;
565 --enable_warnings
566 }
567 if ($command == 'drop-CT')
568 {
569 --disable_warnings
570 eval DROP TEMPORARY TABLE IF EXISTS tt_xx_$tb_id;
571 inc $tb_id;
572 --enable_warnings
573 }
574 if ($command == 'C')
575 {
576 --error 0, ER_GET_ERRMSG
577 eval COMMIT;
578 }
579 if ($command == 'R')
580 {
581 --replace_column 2 #
582 --error 0, ER_GET_ERRMSG
583 eval ROLLBACK;
584 }
585 if ($command == 'Sn')
586 {
587 eval SAVEPOINT S_$sn;
588 --inc $sn
589 }
590 if ($command == 'Rn')
591 {
592 if ($sn)
593 {
594 --dec $sn
595 }
596 --replace_column 2 #
597 eval ROLLBACK TO S_$sn;
598 }
599 if ($command == 'Cn')
600 {
601 if ($sn)
602 {
603 --dec $sn
604 }
605 eval RELEASE SAVEPOINT S_$sn;
606 }
607 --disable_query_log
608 --let $commands= `SELECT LTRIM(SUBSTRING('$commands', LENGTH('$command') + 1))`
609 inc $stmt_id;
610
611 let $binlog_start= $pos_command;
612 if ($verbose)
613 {
614 # Use other connection because include/show_binlog_events.inc
615 # executes SELECT UUID(), which switches to row-logging when
616 # binlog_format=mixed, if there are open temporary tables. This is
617 # due to BUG#13692513.
618 --connection server_1
619 --source include/show_binlog_events.inc
620 --connection master
621 --echo -e-e-e-e-e-e-e-e-e-e-e- >> $command << -e-e-e-e-e-e-e-e-e-e-e-
622 }
623 if ($commands == '')
624 {
625 let $binlog_start= $pos_trans_command;
626 --echo -b-b-b-b-b-b-b-b-b-b-b- >> $rme_initial_commands << -b-b-b-b-b-b-b-b-b-b-b-
627 --connection server_1
628 --source include/show_binlog_events.inc
629 --connection master
630 --echo -e-e-e-e-e-e-e-e-e-e-e- >> $rme_initial_commands << -e-e-e-e-e-e-e-e-e-e-e-
631 --echo
632 let $pos_trans_command= query_get_value("SHOW MASTER STATUS", Position, 1);
633 let $stmt_id= 1;
634 inc $trans_id;
635 }
636 }
637 --enable_ps2_protocol
638
639 --let $commands= $rme_initial_commands