Debian Codegraph @

mysql-test/suite/rpl/include/rpl_drop_create_temp_table.test

raw
1 ###############################################################################
2 # In this test case, we check how changes to temporary tables are written
3 # to the binary log.
4 #
5 #
6 # B - Begin
7 # C - Commit
8 # R - Rollback
9 #
10 #
11 # T - Inserts a row into a T-table
12 #
13 #
14 # T-SELECT-N-Temp - Selects from a temporary N-table and inserts
15 # into a T-table.
16 # N-SELECT-N-Temp - Selects from a temporary N-table and inserts
17 # into a N-table.
18 # T-SELECT-T-Temp - Selects from a temporary T-table and inserts
19 # into a T-table.
20 # N-SELECT-T-Temp - Selects from a temporary T-table and inserts
21 # into a N-table.
22
23 # Create-N-Temp - Creates a temporary N-table if a temporary N-table
24 # was dropped before
25 # Create-T-Temp - Creates a temporary T-table if a temporary T-table
26 # was dropped before
27 #
28 #
29 # Drop-Temp-T-Temp - Drops a temporary T-table if there is any
30 # Drop-Temp-N-Temp - Drops a temporary N-table if there is any
31 # Drop-Temp-TN-Temp - Drops both a temporary T-table and N-table if there
32 # is any
33 # Drop-Temp-TT-Temp - Drops two temporary T-tables if there is any
34 # Drop-Temp-NN-Temp - Drops two temporary N-tables if there is any
35 #
36 # Note: MDEV-20091: DROP TEMPORARY TABLE IF EXISTS statements will be written
37 # to binlog only if the corresponding temporary table exists.
38 #
39 # Drop-Temp-Xe-Temp - Tries to drop a temporary table that does not exist
40 # Drop-Temp-NXe-Temp - Drops a temporary N-table if there is any and
41 # a temporary table that does not exist
42 # Drop-Temp-TXe-Temp - Drops a temporary T-table if there is any and
43 # a temporary table that does not exist
44 #
45 #
46 # Drop-Temp-If-Xe-Temp - Tries to drop a temporary table that does not exist
47 # Drop-Temp-If-TXe-Temp - Drops a temporary T-table if there is any and
48 # a temporary table that does not exist
49 #
50 #
51 # Drop-T - Drops a T-table if there is any
52 # Drop-N - Drops a N-table if there is any
53 # Drop-Xe - Tries to drop a table that does not exist
54 # Drop-TXe - Drops a T-table if there is any and a table that does
55 # not exist
56 # Drop-NXe - Drops a N-table if there is any and a table that does
57 # not exist
58 # Drop-TN - Drops both a T-table and N-table if there is any
59 # Drop-TT - Drops two T-tables if there is any
60 # Drop-NN - Drops two N-tables if there is any
61 # Drop-N-TN-Temp - Drops a N-table and both a temporary T-table and
62 # N-table if there is any
63 #
64 #
65 # Drop-If-Xe - Tries to drop a table that does not exist
66 # Drop-If-TXe - Drops a T-table if there is any and a table that does
67 # not exist
68 #
69 #
70 # This test uses the commands available at:
71 # suite/rpl/include/rpl_drop_create_temp_table.inc
72 #
73 ###############################################################################
74
75
76 --echo #########################################################################
77 --echo # CONFIGURATION
78 --echo #########################################################################
79
80 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.");
81
82 --let $tot_table= 2
83 SET @commands= 'configure';
84 --source suite/rpl/include/rpl_drop_create_temp_table.inc
85
86 --echo #########################################################################
87 --echo # 1 - Tables dropped by "DROP TEMPORARY TABLE"
88 --echo #########################################################################
89 connection master;
90
91 --echo
92 --echo #
93 --echo #1) Generates in the binlog what follows:
94 --echo #
95 SET @commands= 'Drop-Temp-T-Temp';
96 --source suite/rpl/include/rpl_drop_create_temp_table.inc
97
98 SET @commands= 'Drop-Temp-N-Temp';
99 --source suite/rpl/include/rpl_drop_create_temp_table.inc
100
101 SET @commands= 'Drop-Temp-Xe-Temp';
102 --source suite/rpl/include/rpl_drop_create_temp_table.inc
103
104 SET @commands= 'Drop-Temp-If-Xe-Temp';
105 --source suite/rpl/include/rpl_drop_create_temp_table.inc
106
107 SET @commands= 'Drop-Temp-TXe-Temp';
108 --source suite/rpl/include/rpl_drop_create_temp_table.inc
109
110 SET @commands= 'Drop-Temp-If-TXe-Temp';
111 --source suite/rpl/include/rpl_drop_create_temp_table.inc
112
113 SET @commands= 'Drop-Temp-NXe-Temp';
114 --source suite/rpl/include/rpl_drop_create_temp_table.inc
115
116 SET @commands= 'Drop-Temp-If-NXe-Temp';
117 --source suite/rpl/include/rpl_drop_create_temp_table.inc
118
119 SET @commands= 'Drop-Temp-TN-Temp';
120 --source suite/rpl/include/rpl_drop_create_temp_table.inc
121
122 SET @commands= 'Drop-Temp-TT-Temp';
123 --source suite/rpl/include/rpl_drop_create_temp_table.inc
124
125 SET @commands= 'Drop-Temp-NN-Temp';
126 --source suite/rpl/include/rpl_drop_create_temp_table.inc
127
128 --echo
129 --echo #
130 --echo #2) Generates in the binlog what follows:
131 --echo #
132 SET @commands= 'B T Drop-Temp-T-Temp C';
133 --source suite/rpl/include/rpl_drop_create_temp_table.inc
134
135 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C';
136 --source suite/rpl/include/rpl_drop_create_temp_table.inc
137
138 SET @commands= 'B T Drop-Temp-N-Temp C';
139 --source suite/rpl/include/rpl_drop_create_temp_table.inc
140
141 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C';
142 --source suite/rpl/include/rpl_drop_create_temp_table.inc
143
144 SET @commands= 'B T Drop-Temp-Xe-Temp C';
145 --source suite/rpl/include/rpl_drop_create_temp_table.inc
146
147 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C';
148 --source suite/rpl/include/rpl_drop_create_temp_table.inc
149
150 SET @commands= 'B T Drop-Temp-If-Xe-Temp C';
151 --source suite/rpl/include/rpl_drop_create_temp_table.inc
152
153 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C';
154 --source suite/rpl/include/rpl_drop_create_temp_table.inc
155
156 SET @commands= 'B T Drop-Temp-TXe-Temp C';
157 --source suite/rpl/include/rpl_drop_create_temp_table.inc
158
159 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C';
160 --source suite/rpl/include/rpl_drop_create_temp_table.inc
161
162 SET @commands= 'B T Drop-Temp-If-TXe-Temp C';
163 --source suite/rpl/include/rpl_drop_create_temp_table.inc
164
165 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C';
166 --source suite/rpl/include/rpl_drop_create_temp_table.inc
167
168 SET @commands= 'B T Drop-Temp-NXe-Temp C';
169 --source suite/rpl/include/rpl_drop_create_temp_table.inc
170
171 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C';
172 --source suite/rpl/include/rpl_drop_create_temp_table.inc
173
174 SET @commands= 'B T Drop-Temp-If-NXe-Temp C';
175 --source suite/rpl/include/rpl_drop_create_temp_table.inc
176
177 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C';
178 --source suite/rpl/include/rpl_drop_create_temp_table.inc
179
180 SET @commands= 'B T Drop-Temp-TN-Temp C';
181 --source suite/rpl/include/rpl_drop_create_temp_table.inc
182
183 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C';
184 --source suite/rpl/include/rpl_drop_create_temp_table.inc
185
186 SET @commands= 'B T Drop-Temp-TT-Temp C';
187 --source suite/rpl/include/rpl_drop_create_temp_table.inc
188
189 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C';
190 --source suite/rpl/include/rpl_drop_create_temp_table.inc
191
192 SET @commands= 'B T Drop-Temp-NN-Temp C';
193 --source suite/rpl/include/rpl_drop_create_temp_table.inc
194
195 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C';
196 --source suite/rpl/include/rpl_drop_create_temp_table.inc
197
198 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C';
199 --source suite/rpl/include/rpl_drop_create_temp_table.inc
200
201 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C';
202 --source suite/rpl/include/rpl_drop_create_temp_table.inc
203
204 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C';
205 --source suite/rpl/include/rpl_drop_create_temp_table.inc
206
207 --echo
208 --echo #
209 --echo #3) Generates in the binlog what follows:
210 --echo #
211 SET @commands= 'B T Drop-Temp-T-Temp R';
212 --source suite/rpl/include/rpl_drop_create_temp_table.inc
213
214 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R';
215 --source suite/rpl/include/rpl_drop_create_temp_table.inc
216
217 SET @commands= 'B T Drop-Temp-N-Temp R';
218 --source suite/rpl/include/rpl_drop_create_temp_table.inc
219
220 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R';
221 --source suite/rpl/include/rpl_drop_create_temp_table.inc
222
223 SET @commands= 'B T Drop-Temp-Xe-Temp R';
224 --source suite/rpl/include/rpl_drop_create_temp_table.inc
225
226 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R';
227 --source suite/rpl/include/rpl_drop_create_temp_table.inc
228
229 SET @commands= 'B T Drop-Temp-If-Xe-Temp R';
230 --source suite/rpl/include/rpl_drop_create_temp_table.inc
231
232 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R';
233 --source suite/rpl/include/rpl_drop_create_temp_table.inc
234
235 SET @commands= 'B T Drop-Temp-TXe-Temp R';
236 --source suite/rpl/include/rpl_drop_create_temp_table.inc
237
238 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R';
239 --source suite/rpl/include/rpl_drop_create_temp_table.inc
240
241 SET @commands= 'B T Drop-Temp-If-TXe-Temp R';
242 --source suite/rpl/include/rpl_drop_create_temp_table.inc
243
244 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R';
245 --source suite/rpl/include/rpl_drop_create_temp_table.inc
246
247 SET @commands= 'B T Drop-Temp-NXe-Temp R';
248 --source suite/rpl/include/rpl_drop_create_temp_table.inc
249
250 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R';
251 --source suite/rpl/include/rpl_drop_create_temp_table.inc
252
253 SET @commands= 'B T Drop-Temp-If-NXe-Temp R';
254 --source suite/rpl/include/rpl_drop_create_temp_table.inc
255
256 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R';
257 --source suite/rpl/include/rpl_drop_create_temp_table.inc
258
259 SET @commands= 'B T Drop-Temp-TN-Temp R';
260 --source suite/rpl/include/rpl_drop_create_temp_table.inc
261
262 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R';
263 --source suite/rpl/include/rpl_drop_create_temp_table.inc
264
265 SET @commands= 'B T Drop-Temp-TT-Temp R';
266 --source suite/rpl/include/rpl_drop_create_temp_table.inc
267
268 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R';
269 --source suite/rpl/include/rpl_drop_create_temp_table.inc
270
271 SET @commands= 'B T Drop-Temp-NN-Temp R';
272 --source suite/rpl/include/rpl_drop_create_temp_table.inc
273
274 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R';
275 --source suite/rpl/include/rpl_drop_create_temp_table.inc
276
277 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R';
278 --source suite/rpl/include/rpl_drop_create_temp_table.inc
279
280 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R';
281 --source suite/rpl/include/rpl_drop_create_temp_table.inc
282
283 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R';
284 --source suite/rpl/include/rpl_drop_create_temp_table.inc
285
286 --echo #########################################################################
287 --echo # 2 - Tables dropped by "DROP TABLE"
288 --echo #########################################################################
289 connection master;
290
291 --echo
292 --echo #
293 --echo #1) Generates in the binlog what follows:
294 --echo #
295 SET @commands= 'Drop-T';
296 --source suite/rpl/include/rpl_drop_create_temp_table.inc
297
298 SET @commands= 'Drop-N';
299 --source suite/rpl/include/rpl_drop_create_temp_table.inc
300
301 SET @commands= 'Drop-Xe';
302 --source suite/rpl/include/rpl_drop_create_temp_table.inc
303
304 SET @commands= 'Drop-If-Xe';
305 --source suite/rpl/include/rpl_drop_create_temp_table.inc
306
307 SET @commands= 'Drop-TXe';
308 --source suite/rpl/include/rpl_drop_create_temp_table.inc
309
310 SET @commands= 'Drop-If-TXe';
311 --source suite/rpl/include/rpl_drop_create_temp_table.inc
312
313 SET @commands= 'Drop-NXe';
314 --source suite/rpl/include/rpl_drop_create_temp_table.inc
315
316 SET @commands= 'Drop-If-NXe';
317 --source suite/rpl/include/rpl_drop_create_temp_table.inc
318
319 SET @commands= 'Drop-TN';
320 --source suite/rpl/include/rpl_drop_create_temp_table.inc
321
322 SET @commands= 'Drop-TT';
323 --source suite/rpl/include/rpl_drop_create_temp_table.inc
324
325 SET @commands= 'Drop-NN';
326 --source suite/rpl/include/rpl_drop_create_temp_table.inc
327
328 SET @commands= 'Drop-N-TN-Temp';
329 --source suite/rpl/include/rpl_drop_create_temp_table.inc
330
331 SET @commands= 'Drop-TN-Temp';
332 --source suite/rpl/include/rpl_drop_create_temp_table.inc
333
334 --echo
335 --echo #
336 --echo #2) Generates in the binlog what follows:
337 --echo #
338 SET @commands= 'B T Drop-T';
339 --source suite/rpl/include/rpl_drop_create_temp_table.inc
340
341 SET @commands= 'B T Drop-N';
342 --source suite/rpl/include/rpl_drop_create_temp_table.inc
343
344 SET @commands= 'B T Drop-Xe';
345 --source suite/rpl/include/rpl_drop_create_temp_table.inc
346
347 SET @commands= 'B T Drop-If-Xe';
348 --source suite/rpl/include/rpl_drop_create_temp_table.inc
349
350 SET @commands= 'B T Drop-TXe';
351 --source suite/rpl/include/rpl_drop_create_temp_table.inc
352
353 SET @commands= 'B T Drop-If-TXe';
354 --source suite/rpl/include/rpl_drop_create_temp_table.inc
355
356 SET @commands= 'B T Drop-NXe';
357 --source suite/rpl/include/rpl_drop_create_temp_table.inc
358
359 SET @commands= 'B T Drop-If-NXe';
360 --source suite/rpl/include/rpl_drop_create_temp_table.inc
361
362 SET @commands= 'B T Drop-TN';
363 --source suite/rpl/include/rpl_drop_create_temp_table.inc
364
365 SET @commands= 'B T Drop-TT';
366 --source suite/rpl/include/rpl_drop_create_temp_table.inc
367
368 SET @commands= 'B T Drop-NN';
369 --source suite/rpl/include/rpl_drop_create_temp_table.inc
370
371 SET @commands= 'B T Drop-N-TN-Temp';
372 --source suite/rpl/include/rpl_drop_create_temp_table.inc
373
374 SET @commands= 'B T Drop-TN-Temp';
375 --source suite/rpl/include/rpl_drop_create_temp_table.inc
376
377 --echo #########################################################################
378 --echo # 3 - CREATE TEMPORARY TABLE
379 --echo #########################################################################
380 connection master;
381
382 --echo
383 --echo #
384 --echo #1) Generates in the binlog what follows:
385 --echo #
386 SET @commands= 'Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp';
387 --source suite/rpl/include/rpl_drop_create_temp_table.inc
388
389 SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp';
390 --source suite/rpl/include/rpl_drop_create_temp_table.inc
391
392 --echo
393 --echo #
394 --echo #2) Generates in the binlog what follows:
395 --echo #
396 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C';
397 --source suite/rpl/include/rpl_drop_create_temp_table.inc
398
399 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C';
400 --source suite/rpl/include/rpl_drop_create_temp_table.inc
401
402 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C';
403 --source suite/rpl/include/rpl_drop_create_temp_table.inc
404
405 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C';
406 --source suite/rpl/include/rpl_drop_create_temp_table.inc
407
408 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C';
409 --source suite/rpl/include/rpl_drop_create_temp_table.inc
410
411 --echo
412 --echo #
413 --echo #3) Generates in the binlog what follows:
414 --echo #
415 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R';
416 --source suite/rpl/include/rpl_drop_create_temp_table.inc
417
418 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R';
419 --source suite/rpl/include/rpl_drop_create_temp_table.inc
420
421 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R';
422 --source suite/rpl/include/rpl_drop_create_temp_table.inc
423
424 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R';
425 --source suite/rpl/include/rpl_drop_create_temp_table.inc
426
427 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R';
428 --source suite/rpl/include/rpl_drop_create_temp_table.inc
429
430 --echo #########################################################################
431 --echo # 4 - CHANGING TEMPORARY TABLES
432 --echo #########################################################################
433 connection master;
434
435 --echo
436 --echo #
437 --echo #1) Generates in the binlog what follows:
438 --echo #
439 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp C';
440 --source suite/rpl/include/rpl_drop_create_temp_table.inc
441
442 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp C';
443 --source suite/rpl/include/rpl_drop_create_temp_table.inc
444
445 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp C';
446 --source suite/rpl/include/rpl_drop_create_temp_table.inc
447
448 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp C';
449 --source suite/rpl/include/rpl_drop_create_temp_table.inc
450
451 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne C';
452 --source suite/rpl/include/rpl_drop_create_temp_table.inc
453
454 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te C';
455 --source suite/rpl/include/rpl_drop_create_temp_table.inc
456
457 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C';
458 --source suite/rpl/include/rpl_drop_create_temp_table.inc
459
460 --echo
461 --echo
462 --echo #
463 --echo #2) Generates in the binlog what follows:
464 --echo #
465 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp R';
466 --source suite/rpl/include/rpl_drop_create_temp_table.inc
467
468 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp R';
469 --source suite/rpl/include/rpl_drop_create_temp_table.inc
470
471 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp R';
472 --source suite/rpl/include/rpl_drop_create_temp_table.inc
473
474 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp R';
475 --source suite/rpl/include/rpl_drop_create_temp_table.inc
476
477 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne R';
478 --source suite/rpl/include/rpl_drop_create_temp_table.inc
479
480 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te R';
481 --source suite/rpl/include/rpl_drop_create_temp_table.inc
482
483 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R';
484 --source suite/rpl/include/rpl_drop_create_temp_table.inc
485
486 --echo # > MDEV-26833
487 --echo # Errored out and rolled back Te statement should not produce any event to binlog
488 --echo # in the following cases:
489
490 SET @sav_var = @@session.binlog_direct_non_transactional_updates;
491
492 SET @@session.binlog_direct_non_transactional_updates = ON;
493 SET @commands= 'B T Drop-Temp-TT-Temp Te C';
494 --source suite/rpl/include/rpl_drop_create_temp_table.inc
495 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te C';
496 --source suite/rpl/include/rpl_drop_create_temp_table.inc
497 SET @commands= 'B T Drop-Temp-TN-Temp Te C';
498 --source suite/rpl/include/rpl_drop_create_temp_table.inc
499 SET @commands= 'B T N-Temp Te C';
500 --source suite/rpl/include/rpl_drop_create_temp_table.inc
501
502 SET @commands= 'B T Drop-Temp-TT-Temp Te R';
503 --source suite/rpl/include/rpl_drop_create_temp_table.inc
504 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te R';
505 --source suite/rpl/include/rpl_drop_create_temp_table.inc
506 SET @commands= 'B T Drop-Temp-TN-Temp Te R';
507 --source suite/rpl/include/rpl_drop_create_temp_table.inc
508 SET @commands= 'B T N-Temp Te R';
509 --source suite/rpl/include/rpl_drop_create_temp_table.inc
510
511 --echo # Non-transactional side effects.
512 SET @commands= 'B T N-Temp Te Ne C';
513 --source suite/rpl/include/rpl_drop_create_temp_table.inc
514 SET @commands= 'B T N-Temp Te Ne R';
515 --source suite/rpl/include/rpl_drop_create_temp_table.inc
516
517 SET @@session.binlog_direct_non_transactional_updates = OFF;
518 SET @commands= 'B T Drop-Temp-TT-Temp Te C';
519 --source suite/rpl/include/rpl_drop_create_temp_table.inc
520 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te C';
521 --source suite/rpl/include/rpl_drop_create_temp_table.inc
522 SET @commands= 'B T Drop-Temp-TN-Temp Te C';
523 --source suite/rpl/include/rpl_drop_create_temp_table.inc
524 SET @commands= 'B T N-Temp Te C';
525 --source suite/rpl/include/rpl_drop_create_temp_table.inc
526
527 SET @commands= 'B T Drop-Temp-TT-Temp Te R';
528 --source suite/rpl/include/rpl_drop_create_temp_table.inc
529 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te R';
530 --source suite/rpl/include/rpl_drop_create_temp_table.inc
531 SET @commands= 'B T Drop-Temp-TN-Temp Te R';
532 --source suite/rpl/include/rpl_drop_create_temp_table.inc
533 SET @commands= 'B T N-Temp Te R';
534 --source suite/rpl/include/rpl_drop_create_temp_table.inc
535
536 --echo # Non-transactional side effects.
537 SET @commands= 'B T N-Temp Te Ne C';
538 --source suite/rpl/include/rpl_drop_create_temp_table.inc
539 SET @commands= 'B T N-Temp Te Ne R';
540 --source suite/rpl/include/rpl_drop_create_temp_table.inc
541
542 SET @@session.binlog_direct_non_transactional_updates = @sav_var;
543 --echo # < MDEV-26833
544
545 --echo ###################################################################################
546 --echo # CHECK CONSISTENCY
547 --echo ###################################################################################
548 connection master;
549 sync_slave_with_master;
550
551 let $MYSQLD_DATADIR= `SELECT @@datadir`;
552
553 if (`select @@session.binlog_format != 'STATEMENT'`)
554 {
555 --exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLD_DATADIR/test-temporary-master.sql
556 --exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test > $MYSQLD_DATADIR/test-temporary-slave.sql
557 --diff_files $MYSQLD_DATADIR/test-temporary-master.sql $MYSQLD_DATADIR/test-temporary-slave.sql
558 }
559
560 --echo #########################################################################
561 --echo # CLEAN
562 --echo #########################################################################
563 SET @commands= 'clean';
564 --source suite/rpl/include/rpl_drop_create_temp_table.inc