← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_row_drop_create_temp_table.result

  • Committer: Package Import Robot
  • Author(s): Dave Chiluk, Eduardo Damato
  • Date: 2014-01-09 09:44:14 UTC
  • mfrom: (18.1.5 precise-security)
  • Revision ID: package-import@ubuntu.com-20140109094414-ght3gi7yvzsyvhm5
Tags: 5.5.34-0ubuntu0.12.04.2
https://launchpad.net/bugs/1121874
[ Eduardo Damato ]
Fix upstart script to account for datadir disk shortage (LP: #1121874) 

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_row_drop_create_temp_table.result
53
53
DROP TEMPORARY TABLE tt_tmp_2;
54
54
-b-b-b-b-b-b-b-b-b-b-b- >>  << -b-b-b-b-b-b-b-b-b-b-b-
55
55
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
56
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
56
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
57
57
-e-e-e-e-e-e-e-e-e-e-e- >>  << -e-e-e-e-e-e-e-e-e-e-e-
58
58
 
59
59
SET @commands= 'Drop-Temp-N-Temp';
60
60
DROP TEMPORARY TABLE nt_tmp_2;
61
61
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-N-Temp << -b-b-b-b-b-b-b-b-b-b-b-
62
62
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
63
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
63
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
64
64
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-N-Temp << -e-e-e-e-e-e-e-e-e-e-e-
65
65
 
66
66
SET @commands= 'Drop-Temp-Xe-Temp';
76
76
Note    1051    Unknown table 'tt_xx_1'
77
77
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-If-Xe-Temp << -b-b-b-b-b-b-b-b-b-b-b-
78
78
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
79
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
 
79
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
80
80
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-If-Xe-Temp << -e-e-e-e-e-e-e-e-e-e-e-
81
81
 
82
82
SET @commands= 'Drop-Temp-TXe-Temp';
84
84
ERROR 42S02: Unknown table 'tt_1'
85
85
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-TXe-Temp << -b-b-b-b-b-b-b-b-b-b-b-
86
86
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
87
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
87
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
88
88
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-TXe-Temp << -e-e-e-e-e-e-e-e-e-e-e-
89
89
 
90
90
SET @commands= 'Drop-Temp-If-TXe-Temp';
93
93
Note    1051    Unknown table 'tt_1'
94
94
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-If-TXe-Temp << -b-b-b-b-b-b-b-b-b-b-b-
95
95
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
96
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
 
96
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
97
97
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-If-TXe-Temp << -e-e-e-e-e-e-e-e-e-e-e-
98
98
 
99
99
SET @commands= 'Drop-Temp-NXe-Temp';
101
101
ERROR 42S02: Unknown table 'tt_1'
102
102
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-NXe-Temp << -b-b-b-b-b-b-b-b-b-b-b-
103
103
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
104
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
104
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
105
105
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-NXe-Temp << -e-e-e-e-e-e-e-e-e-e-e-
106
106
 
107
107
SET @commands= 'Drop-Temp-If-NXe-Temp';
110
110
Note    1051    Unknown table 'tt_1'
111
111
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-If-NXe-Temp << -b-b-b-b-b-b-b-b-b-b-b-
112
112
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
113
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
114
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
 
113
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
114
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
115
115
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-If-NXe-Temp << -e-e-e-e-e-e-e-e-e-e-e-
116
116
 
117
117
SET @commands= 'Drop-Temp-TN-Temp';
118
118
DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
119
119
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b-
120
120
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
121
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
122
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
121
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
122
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
123
123
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e-
124
124
 
125
125
SET @commands= 'Drop-Temp-TT-Temp';
126
126
DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
127
127
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-TT-Temp << -b-b-b-b-b-b-b-b-b-b-b-
128
128
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
129
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */
 
129
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_tmp_2` /* generated by server */
130
130
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-TT-Temp << -e-e-e-e-e-e-e-e-e-e-e-
131
131
 
132
132
SET @commands= 'Drop-Temp-NN-Temp';
133
133
DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
134
134
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-NN-Temp << -b-b-b-b-b-b-b-b-b-b-b-
135
135
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
136
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */
 
136
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1`,`test`.`nt_tmp_2` /* generated by server */
137
137
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-NN-Temp << -e-e-e-e-e-e-e-e-e-e-e-
138
138
 
139
139
 
150
150
master-bin.000001       #       Query   #       #       BEGIN
151
151
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
152
152
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
153
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
153
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
154
154
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
155
155
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
156
156
 
170
170
master-bin.000001       #       Query   #       #       BEGIN
171
171
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
172
172
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
173
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
174
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
 
173
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
174
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
175
175
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
176
176
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
177
177
 
183
183
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
184
184
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
185
185
master-bin.000001       #       Query   #       #       BEGIN
186
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
186
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
187
187
master-bin.000001       #       Query   #       #       COMMIT
188
188
master-bin.000001       #       Query   #       #       BEGIN
189
189
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
201
201
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
202
202
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
203
203
master-bin.000001       #       Query   #       #       BEGIN
204
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
204
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
205
205
master-bin.000001       #       Query   #       #       COMMIT
206
206
master-bin.000001       #       Query   #       #       BEGIN
207
207
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
208
208
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
209
209
master-bin.000001       #       Query   #       #       COMMIT
210
210
master-bin.000001       #       Query   #       #       BEGIN
211
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
211
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
212
212
master-bin.000001       #       Query   #       #       COMMIT
213
213
master-bin.000001       #       Query   #       #       BEGIN
214
214
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
263
263
master-bin.000001       #       Query   #       #       BEGIN
264
264
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
265
265
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
266
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
 
266
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
267
267
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
268
268
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
269
269
 
287
287
master-bin.000001       #       Query   #       #       BEGIN
288
288
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
289
289
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
290
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
291
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
 
290
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
 
291
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
292
292
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
293
293
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
294
294
 
303
303
master-bin.000001       #       Query   #       #       BEGIN
304
304
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
305
305
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
306
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
306
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
307
307
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
308
308
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
309
309
 
325
325
master-bin.000001       #       Query   #       #       BEGIN
326
326
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
327
327
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
328
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
329
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
 
328
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
329
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
330
330
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
331
331
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
332
332
 
342
342
master-bin.000001       #       Query   #       #       BEGIN
343
343
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
344
344
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
345
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
 
345
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
346
346
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
347
347
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
348
348
 
366
366
master-bin.000001       #       Query   #       #       BEGIN
367
367
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
368
368
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
369
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
370
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */
 
369
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
 
370
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_1` /* generated by server */
371
371
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
372
372
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
373
373
 
380
380
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
381
381
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
382
382
master-bin.000001       #       Query   #       #       BEGIN
383
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
383
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
384
384
master-bin.000001       #       Query   #       #       COMMIT
385
385
master-bin.000001       #       Query   #       #       BEGIN
386
386
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
400
400
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
401
401
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
402
402
master-bin.000001       #       Query   #       #       BEGIN
403
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
403
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
404
404
master-bin.000001       #       Query   #       #       COMMIT
405
405
master-bin.000001       #       Query   #       #       BEGIN
406
406
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
407
407
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
408
408
master-bin.000001       #       Query   #       #       COMMIT
409
409
master-bin.000001       #       Query   #       #       BEGIN
410
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
410
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
411
411
master-bin.000001       #       Query   #       #       COMMIT
412
412
master-bin.000001       #       Query   #       #       BEGIN
413
413
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
425
425
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
426
426
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
427
427
master-bin.000001       #       Query   #       #       BEGIN
428
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
428
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
429
429
master-bin.000001       #       Query   #       #       COMMIT
430
430
master-bin.000001       #       Query   #       #       BEGIN
431
431
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
432
432
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
433
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
 
433
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
434
434
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
435
435
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
436
436
 
448
448
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
449
449
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
450
450
master-bin.000001       #       Query   #       #       BEGIN
451
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
451
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
452
452
master-bin.000001       #       Query   #       #       COMMIT
453
453
master-bin.000001       #       Query   #       #       BEGIN
454
454
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
455
455
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
456
456
master-bin.000001       #       Query   #       #       COMMIT
457
457
master-bin.000001       #       Query   #       #       BEGIN
458
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
458
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
459
459
master-bin.000001       #       Query   #       #       COMMIT
460
460
master-bin.000001       #       Query   #       #       BEGIN
461
461
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
462
462
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
463
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
464
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
 
463
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
 
464
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
465
465
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
466
466
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
467
467
 
473
473
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
474
474
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
475
475
master-bin.000001       #       Query   #       #       BEGIN
476
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
476
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
477
477
master-bin.000001       #       Query   #       #       COMMIT
478
478
master-bin.000001       #       Query   #       #       BEGIN
479
479
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
480
480
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
481
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
481
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
482
482
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
483
483
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
484
484
 
492
492
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
493
493
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
494
494
master-bin.000001       #       Query   #       #       BEGIN
495
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
495
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
496
496
master-bin.000001       #       Query   #       #       COMMIT
497
497
master-bin.000001       #       Query   #       #       BEGIN
498
498
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
499
499
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
500
500
master-bin.000001       #       Query   #       #       COMMIT
501
501
master-bin.000001       #       Query   #       #       BEGIN
502
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
502
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
503
503
master-bin.000001       #       Query   #       #       COMMIT
504
504
master-bin.000001       #       Query   #       #       BEGIN
505
505
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
506
506
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
507
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
508
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
 
507
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
508
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
509
509
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
510
510
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
511
511
 
519
519
master-bin.000001       #       Query   #       #       BEGIN
520
520
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
521
521
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
522
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */
 
522
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_tmp_2` /* generated by server */
523
523
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
524
524
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
525
525
 
538
538
master-bin.000001       #       Query   #       #       BEGIN
539
539
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
540
540
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
541
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */
 
541
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_tmp_2` /* generated by server */
542
542
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
543
543
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
544
544
 
550
550
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
551
551
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
552
552
master-bin.000001       #       Query   #       #       BEGIN
553
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */
 
553
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1`,`test`.`nt_tmp_2` /* generated by server */
554
554
master-bin.000001       #       Query   #       #       COMMIT
555
555
master-bin.000001       #       Query   #       #       BEGIN
556
556
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
567
567
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
568
568
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
569
569
master-bin.000001       #       Query   #       #       BEGIN
570
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */
 
570
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1`,`test`.`nt_tmp_2` /* generated by server */
571
571
master-bin.000001       #       Query   #       #       COMMIT
572
572
master-bin.000001       #       Query   #       #       BEGIN
573
573
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
593
593
master-bin.000001       #       Query   #       #       BEGIN
594
594
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
595
595
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
596
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
596
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
597
597
master-bin.000001       #       Query   #       #       ROLLBACK
598
598
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
599
599
 
615
615
master-bin.000001       #       Query   #       #       BEGIN
616
616
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
617
617
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
618
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
619
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
 
618
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
619
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
620
620
master-bin.000001       #       Query   #       #       ROLLBACK
621
621
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
622
622
 
628
628
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
629
629
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
630
630
master-bin.000001       #       Query   #       #       BEGIN
631
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
631
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
632
632
master-bin.000001       #       Query   #       #       COMMIT
633
633
master-bin.000001       #       Query   #       #       BEGIN
634
634
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
648
648
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
649
649
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
650
650
master-bin.000001       #       Query   #       #       BEGIN
651
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
651
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
652
652
master-bin.000001       #       Query   #       #       COMMIT
653
653
master-bin.000001       #       Query   #       #       BEGIN
654
654
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
655
655
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
656
656
master-bin.000001       #       Query   #       #       COMMIT
657
657
master-bin.000001       #       Query   #       #       BEGIN
658
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
658
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
659
659
master-bin.000001       #       Query   #       #       COMMIT
660
660
master-bin.000001       #       Query   #       #       BEGIN
661
661
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
712
712
master-bin.000001       #       Query   #       #       BEGIN
713
713
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
714
714
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
715
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
 
715
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
716
716
master-bin.000001       #       Query   #       #       ROLLBACK
717
717
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
718
718
 
738
738
master-bin.000001       #       Query   #       #       BEGIN
739
739
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
740
740
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
741
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
742
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
 
741
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
 
742
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
743
743
master-bin.000001       #       Query   #       #       ROLLBACK
744
744
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
745
745
 
754
754
master-bin.000001       #       Query   #       #       BEGIN
755
755
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
756
756
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
757
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
757
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
758
758
master-bin.000001       #       Query   #       #       ROLLBACK
759
759
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
760
760
 
778
778
master-bin.000001       #       Query   #       #       BEGIN
779
779
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
780
780
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
781
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
782
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
 
781
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
782
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
783
783
master-bin.000001       #       Query   #       #       ROLLBACK
784
784
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
785
785
 
795
795
master-bin.000001       #       Query   #       #       BEGIN
796
796
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
797
797
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
798
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
 
798
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
799
799
master-bin.000001       #       Query   #       #       ROLLBACK
800
800
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
801
801
 
821
821
master-bin.000001       #       Query   #       #       BEGIN
822
822
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
823
823
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
824
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
825
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */
 
824
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
 
825
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_1` /* generated by server */
826
826
master-bin.000001       #       Query   #       #       ROLLBACK
827
827
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
828
828
 
835
835
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
836
836
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
837
837
master-bin.000001       #       Query   #       #       BEGIN
838
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
838
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
839
839
master-bin.000001       #       Query   #       #       COMMIT
840
840
master-bin.000001       #       Query   #       #       BEGIN
841
841
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
857
857
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
858
858
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
859
859
master-bin.000001       #       Query   #       #       BEGIN
860
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
860
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
861
861
master-bin.000001       #       Query   #       #       COMMIT
862
862
master-bin.000001       #       Query   #       #       BEGIN
863
863
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
864
864
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
865
865
master-bin.000001       #       Query   #       #       COMMIT
866
866
master-bin.000001       #       Query   #       #       BEGIN
867
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
867
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
868
868
master-bin.000001       #       Query   #       #       COMMIT
869
869
master-bin.000001       #       Query   #       #       BEGIN
870
870
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
882
882
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
883
883
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
884
884
master-bin.000001       #       Query   #       #       BEGIN
885
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
885
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
886
886
master-bin.000001       #       Query   #       #       COMMIT
887
887
master-bin.000001       #       Query   #       #       BEGIN
888
888
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
889
889
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
890
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
 
890
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
891
891
master-bin.000001       #       Query   #       #       ROLLBACK
892
892
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
893
893
 
907
907
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
908
908
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
909
909
master-bin.000001       #       Query   #       #       BEGIN
910
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
910
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
911
911
master-bin.000001       #       Query   #       #       COMMIT
912
912
master-bin.000001       #       Query   #       #       BEGIN
913
913
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
914
914
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
915
915
master-bin.000001       #       Query   #       #       COMMIT
916
916
master-bin.000001       #       Query   #       #       BEGIN
917
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
917
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
918
918
master-bin.000001       #       Query   #       #       COMMIT
919
919
master-bin.000001       #       Query   #       #       BEGIN
920
920
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
921
921
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
922
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
923
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
 
922
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
 
923
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
924
924
master-bin.000001       #       Query   #       #       ROLLBACK
925
925
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
926
926
 
932
932
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
933
933
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
934
934
master-bin.000001       #       Query   #       #       BEGIN
935
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
935
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
936
936
master-bin.000001       #       Query   #       #       COMMIT
937
937
master-bin.000001       #       Query   #       #       BEGIN
938
938
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
939
939
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
940
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
940
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
941
941
master-bin.000001       #       Query   #       #       ROLLBACK
942
942
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
943
943
 
953
953
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
954
954
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
955
955
master-bin.000001       #       Query   #       #       BEGIN
956
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
956
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
957
957
master-bin.000001       #       Query   #       #       COMMIT
958
958
master-bin.000001       #       Query   #       #       BEGIN
959
959
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
960
960
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
961
961
master-bin.000001       #       Query   #       #       COMMIT
962
962
master-bin.000001       #       Query   #       #       BEGIN
963
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
 
963
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
964
964
master-bin.000001       #       Query   #       #       COMMIT
965
965
master-bin.000001       #       Query   #       #       BEGIN
966
966
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
967
967
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
968
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
969
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
 
968
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
969
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
970
970
master-bin.000001       #       Query   #       #       ROLLBACK
971
971
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
972
972
 
980
980
master-bin.000001       #       Query   #       #       BEGIN
981
981
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
982
982
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
983
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */
 
983
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_tmp_2` /* generated by server */
984
984
master-bin.000001       #       Query   #       #       ROLLBACK
985
985
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
986
986
 
1001
1001
master-bin.000001       #       Query   #       #       BEGIN
1002
1002
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
1003
1003
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
1004
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */
 
1004
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_tmp_2` /* generated by server */
1005
1005
master-bin.000001       #       Query   #       #       ROLLBACK
1006
1006
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
1007
1007
 
1013
1013
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1014
1014
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1015
1015
master-bin.000001       #       Query   #       #       BEGIN
1016
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */
 
1016
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1`,`test`.`nt_tmp_2` /* generated by server */
1017
1017
master-bin.000001       #       Query   #       #       COMMIT
1018
1018
master-bin.000001       #       Query   #       #       BEGIN
1019
1019
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
1032
1032
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1033
1033
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1034
1034
master-bin.000001       #       Query   #       #       BEGIN
1035
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */
 
1035
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1`,`test`.`nt_tmp_2` /* generated by server */
1036
1036
master-bin.000001       #       Query   #       #       COMMIT
1037
1037
master-bin.000001       #       Query   #       #       BEGIN
1038
1038
master-bin.000001       #       Table_map       #       #       table_id: # (test.nt_xx_1)
1140
1140
DROP TABLE tt_tmp_2, nt_tmp_2, nt_2;
1141
1141
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-N-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b-
1142
1142
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1143
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
1144
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
1143
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
1144
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
1145
1145
master-bin.000001       #       Query   #       #       use `test`; DROP TABLE `nt_2` /* generated by server */
1146
1146
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e-
1147
1147
 
1149
1149
DROP TABLE tt_tmp_2, nt_tmp_2;
1150
1150
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b-
1151
1151
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1152
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
1153
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
1152
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
1153
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
1154
1154
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e-
1155
1155
 
1156
1156
 
1318
1318
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
1319
1319
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
1320
1320
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
1321
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
1322
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
1321
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
1322
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
1323
1323
master-bin.000001       #       Query   #       #       use `test`; DROP TABLE `nt_2` /* generated by server */
1324
1324
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e-
1325
1325
 
1333
1333
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
1334
1334
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
1335
1335
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
1336
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
1337
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
1336
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
1337
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
1338
1338
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e-
1339
1339
 
1340
1340
#########################################################################
1351
1351
DROP TEMPORARY TABLE nt_tmp_2;
1352
1352
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp << -b-b-b-b-b-b-b-b-b-b-b-
1353
1353
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1354
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
1355
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
1356
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
1354
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
1355
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
 
1356
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
1357
1357
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp << -e-e-e-e-e-e-e-e-e-e-e-
1358
1358
 
1359
1359
SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp';
1363
1363
DROP TEMPORARY TABLE tt_tmp_2;
1364
1364
-b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp << -b-b-b-b-b-b-b-b-b-b-b-
1365
1365
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1366
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
1367
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
1368
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
1366
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
1367
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
 
1368
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
1369
1369
-e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp << -e-e-e-e-e-e-e-e-e-e-e-
1370
1370
 
1371
1371
 
1383
1383
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
1384
1384
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1385
1385
master-bin.000001       #       Query   #       #       BEGIN
1386
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
1387
 
master-bin.000001       #       Query   #       #       COMMIT
1388
 
master-bin.000001       #       Query   #       #       BEGIN
1389
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
1390
 
master-bin.000001       #       Query   #       #       COMMIT
1391
 
master-bin.000001       #       Query   #       #       BEGIN
1392
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
1386
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
1387
master-bin.000001       #       Query   #       #       COMMIT
 
1388
master-bin.000001       #       Query   #       #       BEGIN
 
1389
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
 
1390
master-bin.000001       #       Query   #       #       COMMIT
 
1391
master-bin.000001       #       Query   #       #       BEGIN
 
1392
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
1393
1393
master-bin.000001       #       Query   #       #       COMMIT
1394
1394
master-bin.000001       #       Query   #       #       BEGIN
1395
1395
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
1407
1407
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
1408
1408
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1409
1409
master-bin.000001       #       Query   #       #       BEGIN
1410
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
1411
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
1412
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
1410
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
1411
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
 
1412
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
1413
1413
master-bin.000001       #       Query   #       #       COMMIT
1414
1414
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
1415
1415
 
1428
1428
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1429
1429
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1430
1430
master-bin.000001       #       Query   #       #       BEGIN
1431
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
1432
 
master-bin.000001       #       Query   #       #       COMMIT
1433
 
master-bin.000001       #       Query   #       #       BEGIN
1434
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
1435
 
master-bin.000001       #       Query   #       #       COMMIT
1436
 
master-bin.000001       #       Query   #       #       BEGIN
1437
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
 
1431
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
 
1432
master-bin.000001       #       Query   #       #       COMMIT
 
1433
master-bin.000001       #       Query   #       #       BEGIN
 
1434
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
 
1435
master-bin.000001       #       Query   #       #       COMMIT
 
1436
master-bin.000001       #       Query   #       #       BEGIN
 
1437
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
1438
1438
master-bin.000001       #       Query   #       #       COMMIT
1439
1439
master-bin.000001       #       Query   #       #       BEGIN
1440
1440
master-bin.000001       #       Table_map       #       #       table_id: # (test.tt_xx_1)
1452
1452
-b-b-b-b-b-b-b-b-b-b-b- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1453
1453
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
1454
1454
master-bin.000001       #       Query   #       #       BEGIN
1455
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
1456
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
1457
 
master-bin.000001       #       Query   #       #       use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
 
1455
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
 
1456
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
 
1457
master-bin.000001       #       Query   #       #       DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
1458
1458
master-bin.000001       #       Query   #       #       ROLLBACK
1459
1459
-e-e-e-e-e-e-e-e-e-e-e- >> B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
1460
1460