Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_row_drop_create_temp_table.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 #########################################################################
7 # CONFIGURATION
8 #########################################################################
9 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.");
10 SET @commands= 'configure';
11 CREATE TABLE tt_xx_1 ( id INT ) ENGINE = Innodb;
12 CREATE TABLE nt_xx_1 ( id INT ) ENGINE = MyIsam;
13 CREATE TABLE tt_error_1 ( id INT, PRIMARY KEY (id) ) ENGINE = Innodb;
14 CREATE TABLE nt_error_1 ( id INT, PRIMARY KEY (id) ) ENGINE = MyIsam;
15 CREATE TABLE tt_error_2 ( id INT, PRIMARY KEY (id) ) ENGINE = Innodb;
16 CREATE TABLE nt_error_2 ( id INT, PRIMARY KEY (id) ) ENGINE = MyIsam;
17 CREATE TRIGGER tr_i_nt_2_to_tt_2 AFTER INSERT ON nt_error_2 FOR EACH ROW
18 BEGIN
19 DECLARE in_stmt_id INTEGER;
20 INSERT INTO tt_error_2(id) VALUES (NEW.id);
21 END|
22 CREATE TEMPORARY TABLE nt_tmp_xx_1 ( id INT ) ENGINE = MyIsam;
23 CREATE TEMPORARY TABLE tt_tmp_xx_1 ( id INT ) ENGINE = Innodb;
24 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2;
25 Warnings:
26 Note 1051 Unknown table 'test.nt_tmp_2'
27 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) ENGINE = MyIsam;
28 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1;
29 Warnings:
30 Note 1051 Unknown table 'test.nt_tmp_1'
31 CREATE TEMPORARY TABLE nt_tmp_1 ( id INT ) ENGINE = MyIsam;
32 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2;
33 Warnings:
34 Note 1051 Unknown table 'test.tt_tmp_2'
35 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) ENGINE = Innodb;
36 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1;
37 Warnings:
38 Note 1051 Unknown table 'test.tt_tmp_1'
39 CREATE TEMPORARY TABLE tt_tmp_1 ( id INT ) ENGINE = Innodb;
40 DROP TABLE IF EXISTS nt_2;
41 Warnings:
42 Note 1051 Unknown table 'test.nt_2'
43 CREATE TABLE nt_2 ( id INT ) ENGINE = MyIsam;
44 DROP TABLE IF EXISTS nt_1;
45 Warnings:
46 Note 1051 Unknown table 'test.nt_1'
47 CREATE TABLE nt_1 ( id INT ) ENGINE = MyIsam;
48 DROP TABLE IF EXISTS tt_2;
49 Warnings:
50 Note 1051 Unknown table 'test.tt_2'
51 CREATE TABLE tt_2 ( id INT ) ENGINE = Innodb;
52 DROP TABLE IF EXISTS tt_1;
53 Warnings:
54 Note 1051 Unknown table 'test.tt_1'
55 CREATE TABLE tt_1 ( id INT ) ENGINE = Innodb;
56 SET @commands= '';
57 #########################################################################
58 # 1 - Tables dropped by "DROP TEMPORARY TABLE"
59 #########################################################################
60
61 #
62 #1) Generates in the binlog what follows:
63 #
64 SET @commands= 'Drop-Temp-T-Temp';
65 DROP TEMPORARY TABLE tt_tmp_2;
66 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
67 include/show_binlog_events.inc
68 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
69
70 SET @commands= 'Drop-Temp-N-Temp';
71 DROP TEMPORARY TABLE nt_tmp_2;
72 -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-
73 include/show_binlog_events.inc
74 -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-
75
76 SET @commands= 'Drop-Temp-Xe-Temp';
77 DROP TEMPORARY TABLE tt_xx_1;
78 ERROR 42S02: Unknown table 'test.tt_xx_1'
79 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-Xe-Temp << -b-b-b-b-b-b-b-b-b-b-b-
80 include/show_binlog_events.inc
81 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-Xe-Temp << -e-e-e-e-e-e-e-e-e-e-e-
82
83 SET @commands= 'Drop-Temp-If-Xe-Temp';
84 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
85 Warnings:
86 Note 1051 Unknown table 'test.tt_xx_1'
87 -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-
88 include/show_binlog_events.inc
89 -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-
90
91 SET @commands= 'Drop-Temp-TXe-Temp';
92 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
93 ERROR 42S02: Unknown table 'test.tt_1'
94 -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-
95 include/show_binlog_events.inc
96 -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-
97
98 SET @commands= 'Drop-Temp-If-TXe-Temp';
99 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
100 Warnings:
101 Note 1051 Unknown table 'test.tt_1'
102 -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-
103 include/show_binlog_events.inc
104 -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-
105
106 SET @commands= 'Drop-Temp-NXe-Temp';
107 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
108 ERROR 42S02: Unknown table 'test.tt_1'
109 -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-
110 include/show_binlog_events.inc
111 -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-
112
113 SET @commands= 'Drop-Temp-If-NXe-Temp';
114 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
115 Warnings:
116 Note 1051 Unknown table 'test.tt_1'
117 -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-
118 include/show_binlog_events.inc
119 -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-
120
121 SET @commands= 'Drop-Temp-TN-Temp';
122 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
123 -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-
124 include/show_binlog_events.inc
125 -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-
126
127 SET @commands= 'Drop-Temp-TT-Temp';
128 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
129 -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-
130 include/show_binlog_events.inc
131 -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-
132
133 SET @commands= 'Drop-Temp-NN-Temp';
134 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
135 -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-
136 include/show_binlog_events.inc
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
139
140 #
141 #2) Generates in the binlog what follows:
142 #
143 SET @commands= 'B T Drop-Temp-T-Temp C';
144 BEGIN;
145 INSERT INTO tt_xx_1() VALUES (1);
146 DROP TEMPORARY TABLE tt_tmp_2;
147 COMMIT;
148 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
149 include/show_binlog_events.inc
150 Log_name Pos Event_type Server_id End_log_pos Info
151 master-bin.000001 # Query # # BEGIN
152 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
153 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
154 master-bin.000001 # Xid # # COMMIT /* XID */
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
157 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C';
158 BEGIN;
159 INSERT INTO tt_xx_1() VALUES (1);
160 DROP TEMPORARY TABLE tt_tmp_2;
161 INSERT INTO nt_xx_1() VALUES (1);
162 DROP TEMPORARY TABLE tt_tmp_1;
163 COMMIT;
164 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
165 include/show_binlog_events.inc
166 Log_name Pos Event_type Server_id End_log_pos Info
167 master-bin.000001 # Query # # BEGIN
168 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
169 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
170 master-bin.000001 # Query # # COMMIT
171 master-bin.000001 # Query # # BEGIN
172 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
173 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
174 master-bin.000001 # Xid # # COMMIT /* XID */
175 -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-
176
177 SET @commands= 'B T Drop-Temp-N-Temp C';
178 BEGIN;
179 INSERT INTO tt_xx_1() VALUES (1);
180 DROP TEMPORARY TABLE nt_tmp_2;
181 COMMIT;
182 -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-
183 include/show_binlog_events.inc
184 Log_name Pos Event_type Server_id End_log_pos Info
185 master-bin.000001 # Query # # BEGIN
186 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
187 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
188 master-bin.000001 # Xid # # COMMIT /* XID */
189 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
190
191 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C';
192 BEGIN;
193 INSERT INTO tt_xx_1() VALUES (1);
194 DROP TEMPORARY TABLE nt_tmp_2;
195 INSERT INTO nt_xx_1() VALUES (1);
196 DROP TEMPORARY TABLE nt_tmp_1;
197 COMMIT;
198 -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-
199 include/show_binlog_events.inc
200 Log_name Pos Event_type Server_id End_log_pos Info
201 master-bin.000001 # Query # # BEGIN
202 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
203 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
204 master-bin.000001 # Query # # COMMIT
205 master-bin.000001 # Query # # BEGIN
206 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
207 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
208 master-bin.000001 # Xid # # COMMIT /* XID */
209 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
210
211 SET @commands= 'B T Drop-Temp-Xe-Temp C';
212 BEGIN;
213 INSERT INTO tt_xx_1() VALUES (1);
214 DROP TEMPORARY TABLE tt_xx_1;
215 ERROR 42S02: Unknown table 'test.tt_xx_1'
216 COMMIT;
217 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
218 include/show_binlog_events.inc
219 Log_name Pos Event_type Server_id End_log_pos Info
220 master-bin.000001 # Query # # BEGIN
221 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
222 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
223 master-bin.000001 # Xid # # COMMIT /* XID */
224 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
225
226 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C';
227 BEGIN;
228 INSERT INTO tt_xx_1() VALUES (1);
229 DROP TEMPORARY TABLE tt_xx_1;
230 ERROR 42S02: Unknown table 'test.tt_xx_1'
231 INSERT INTO nt_xx_1() VALUES (1);
232 DROP TEMPORARY TABLE tt_xx_1;
233 ERROR 42S02: Unknown table 'test.tt_xx_1'
234 COMMIT;
235 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
236 include/show_binlog_events.inc
237 Log_name Pos Event_type Server_id End_log_pos Info
238 master-bin.000001 # Query # # BEGIN
239 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
240 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
241 master-bin.000001 # Query # # COMMIT
242 master-bin.000001 # Query # # BEGIN
243 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
244 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
245 master-bin.000001 # Xid # # COMMIT /* XID */
246 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
247
248 SET @commands= 'B T Drop-Temp-If-Xe-Temp C';
249 BEGIN;
250 INSERT INTO tt_xx_1() VALUES (1);
251 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
252 Warnings:
253 Note 1051 Unknown table 'test.tt_xx_1'
254 COMMIT;
255 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
256 include/show_binlog_events.inc
257 Log_name Pos Event_type Server_id End_log_pos Info
258 master-bin.000001 # Query # # BEGIN
259 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
260 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
261 master-bin.000001 # Xid # # COMMIT /* XID */
262 -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-
263
264 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C';
265 BEGIN;
266 INSERT INTO tt_xx_1() VALUES (1);
267 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
268 Warnings:
269 Note 1051 Unknown table 'test.tt_xx_1'
270 INSERT INTO nt_xx_1() VALUES (1);
271 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
272 Warnings:
273 Note 1051 Unknown table 'test.tt_xx_1'
274 COMMIT;
275 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
276 include/show_binlog_events.inc
277 Log_name Pos Event_type Server_id End_log_pos Info
278 master-bin.000001 # Query # # BEGIN
279 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
280 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
281 master-bin.000001 # Query # # COMMIT
282 master-bin.000001 # Query # # BEGIN
283 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
284 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
285 master-bin.000001 # Xid # # COMMIT /* XID */
286 -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-
287
288 SET @commands= 'B T Drop-Temp-TXe-Temp C';
289 BEGIN;
290 INSERT INTO tt_xx_1() VALUES (1);
291 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
292 ERROR 42S02: Unknown table 'test.tt_1'
293 COMMIT;
294 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
295 include/show_binlog_events.inc
296 Log_name Pos Event_type Server_id End_log_pos Info
297 master-bin.000001 # Query # # BEGIN
298 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
299 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
300 master-bin.000001 # Xid # # COMMIT /* XID */
301 -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-
302
303 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C';
304 BEGIN;
305 INSERT INTO tt_xx_1() VALUES (1);
306 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
307 ERROR 42S02: Unknown table 'test.tt_1'
308 INSERT INTO nt_xx_1() VALUES (1);
309 DROP TEMPORARY TABLE tt_tmp_1, tt_1;
310 ERROR 42S02: Unknown table 'test.tt_1'
311 COMMIT;
312 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
313 include/show_binlog_events.inc
314 Log_name Pos Event_type Server_id End_log_pos Info
315 master-bin.000001 # Query # # BEGIN
316 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
317 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
318 master-bin.000001 # Query # # COMMIT
319 master-bin.000001 # Query # # BEGIN
320 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
321 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
322 master-bin.000001 # Xid # # COMMIT /* XID */
323 -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-
324
325 SET @commands= 'B T Drop-Temp-If-TXe-Temp C';
326 BEGIN;
327 INSERT INTO tt_xx_1() VALUES (1);
328 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
329 Warnings:
330 Note 1051 Unknown table 'test.tt_1'
331 COMMIT;
332 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
333 include/show_binlog_events.inc
334 Log_name Pos Event_type Server_id End_log_pos Info
335 master-bin.000001 # Query # # BEGIN
336 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
337 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
338 master-bin.000001 # Xid # # COMMIT /* XID */
339 -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-
340
341 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C';
342 BEGIN;
343 INSERT INTO tt_xx_1() VALUES (1);
344 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
345 Warnings:
346 Note 1051 Unknown table 'test.tt_1'
347 INSERT INTO nt_xx_1() VALUES (1);
348 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1;
349 Warnings:
350 Note 1051 Unknown table 'test.tt_1'
351 COMMIT;
352 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
353 include/show_binlog_events.inc
354 Log_name Pos Event_type Server_id End_log_pos Info
355 master-bin.000001 # Query # # BEGIN
356 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
357 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
358 master-bin.000001 # Query # # COMMIT
359 master-bin.000001 # Query # # BEGIN
360 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
361 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
362 master-bin.000001 # Xid # # COMMIT /* XID */
363 -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-
364
365 SET @commands= 'B T Drop-Temp-NXe-Temp C';
366 BEGIN;
367 INSERT INTO tt_xx_1() VALUES (1);
368 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
369 ERROR 42S02: Unknown table 'test.tt_1'
370 COMMIT;
371 -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-
372 include/show_binlog_events.inc
373 Log_name Pos Event_type Server_id End_log_pos Info
374 master-bin.000001 # Query # # BEGIN
375 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
376 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
377 master-bin.000001 # Xid # # COMMIT /* XID */
378 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
379
380 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C';
381 BEGIN;
382 INSERT INTO tt_xx_1() VALUES (1);
383 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
384 ERROR 42S02: Unknown table 'test.tt_1'
385 INSERT INTO nt_xx_1() VALUES (1);
386 DROP TEMPORARY TABLE nt_tmp_1, tt_1;
387 ERROR 42S02: Unknown table 'test.tt_1'
388 COMMIT;
389 -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-
390 include/show_binlog_events.inc
391 Log_name Pos Event_type Server_id End_log_pos Info
392 master-bin.000001 # Query # # BEGIN
393 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
394 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
395 master-bin.000001 # Query # # COMMIT
396 master-bin.000001 # Query # # BEGIN
397 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
398 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
399 master-bin.000001 # Xid # # COMMIT /* XID */
400 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
401
402 SET @commands= 'B T Drop-Temp-If-NXe-Temp C';
403 BEGIN;
404 INSERT INTO tt_xx_1() VALUES (1);
405 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
406 Warnings:
407 Note 1051 Unknown table 'test.tt_1'
408 COMMIT;
409 -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-
410 include/show_binlog_events.inc
411 Log_name Pos Event_type Server_id End_log_pos Info
412 master-bin.000001 # Query # # BEGIN
413 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
414 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
415 master-bin.000001 # Xid # # COMMIT /* XID */
416 -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-
417
418 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C';
419 BEGIN;
420 INSERT INTO tt_xx_1() VALUES (1);
421 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
422 Warnings:
423 Note 1051 Unknown table 'test.tt_1'
424 INSERT INTO nt_xx_1() VALUES (1);
425 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1;
426 Warnings:
427 Note 1051 Unknown table 'test.tt_1'
428 COMMIT;
429 -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-
430 include/show_binlog_events.inc
431 Log_name Pos Event_type Server_id End_log_pos Info
432 master-bin.000001 # Query # # BEGIN
433 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
434 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
435 master-bin.000001 # Query # # COMMIT
436 master-bin.000001 # Query # # BEGIN
437 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
438 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
439 master-bin.000001 # Xid # # COMMIT /* XID */
440 -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-
441
442 SET @commands= 'B T Drop-Temp-TN-Temp C';
443 BEGIN;
444 INSERT INTO tt_xx_1() VALUES (1);
445 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
446 COMMIT;
447 -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-
448 include/show_binlog_events.inc
449 Log_name Pos Event_type Server_id End_log_pos Info
450 master-bin.000001 # Query # # BEGIN
451 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
452 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
453 master-bin.000001 # Xid # # COMMIT /* XID */
454 -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-
455
456 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C';
457 BEGIN;
458 INSERT INTO tt_xx_1() VALUES (1);
459 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
460 INSERT INTO nt_xx_1() VALUES (1);
461 DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1;
462 COMMIT;
463 -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-
464 include/show_binlog_events.inc
465 Log_name Pos Event_type Server_id End_log_pos Info
466 master-bin.000001 # Query # # BEGIN
467 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
468 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
469 master-bin.000001 # Query # # COMMIT
470 master-bin.000001 # Query # # BEGIN
471 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
472 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
473 master-bin.000001 # Xid # # COMMIT /* XID */
474 -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-
475
476 SET @commands= 'B T Drop-Temp-TT-Temp C';
477 BEGIN;
478 INSERT INTO tt_xx_1() VALUES (1);
479 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
480 COMMIT;
481 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
482 include/show_binlog_events.inc
483 Log_name Pos Event_type Server_id End_log_pos Info
484 master-bin.000001 # Query # # BEGIN
485 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
486 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
487 master-bin.000001 # Xid # # COMMIT /* XID */
488 -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-
489
490 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C';
491 BEGIN;
492 INSERT INTO tt_xx_1() VALUES (1);
493 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
494 INSERT INTO nt_xx_1() VALUES (1);
495 COMMIT;
496 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
497 include/show_binlog_events.inc
498 Log_name Pos Event_type Server_id End_log_pos Info
499 master-bin.000001 # Query # # BEGIN
500 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
501 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
502 master-bin.000001 # Query # # COMMIT
503 master-bin.000001 # Query # # BEGIN
504 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
505 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
506 master-bin.000001 # Xid # # COMMIT /* XID */
507 -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-
508
509 SET @commands= 'B T Drop-Temp-NN-Temp C';
510 BEGIN;
511 INSERT INTO tt_xx_1() VALUES (1);
512 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
513 COMMIT;
514 -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-
515 include/show_binlog_events.inc
516 Log_name Pos Event_type Server_id End_log_pos Info
517 master-bin.000001 # Query # # BEGIN
518 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
519 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
520 master-bin.000001 # Xid # # COMMIT /* XID */
521 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
522
523 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C';
524 BEGIN;
525 INSERT INTO tt_xx_1() VALUES (1);
526 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
527 INSERT INTO nt_xx_1() VALUES (1);
528 COMMIT;
529 -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-
530 include/show_binlog_events.inc
531 Log_name Pos Event_type Server_id End_log_pos Info
532 master-bin.000001 # Query # # BEGIN
533 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
534 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
535 master-bin.000001 # Query # # COMMIT
536 master-bin.000001 # Query # # BEGIN
537 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
538 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
539 master-bin.000001 # Xid # # COMMIT /* XID */
540 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
541
542 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C';
543 BEGIN;
544 INSERT INTO tt_xx_1() VALUES (1);
545 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
546 INSERT INTO nt_xx_1() VALUES (1);
547 INSERT INTO nt_error_1() VALUES (1), (1);
548 ERROR 23000: Duplicate entry '1' for key 'nt_error_1.PRIMARY'
549 COMMIT;
550 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C << -b-b-b-b-b-b-b-b-b-b-b-
551 include/show_binlog_events.inc
552 Log_name Pos Event_type Server_id End_log_pos Info
553 master-bin.000001 # Query # # BEGIN
554 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
555 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
556 master-bin.000001 # Query # # COMMIT
557 master-bin.000001 # Query # # BEGIN
558 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
559 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
560 master-bin.000001 # Query # # COMMIT
561 master-bin.000001 # Query # # BEGIN
562 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
563 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
564 master-bin.000001 # Xid # # COMMIT /* XID */
565 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C << -e-e-e-e-e-e-e-e-e-e-e-
566
567 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C';
568 BEGIN;
569 INSERT INTO tt_xx_1() VALUES (1);
570 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
571 INSERT INTO nt_xx_1() VALUES (1);
572 INSERT INTO tt_error_1() VALUES (1), (1);
573 ERROR 23000: Duplicate entry '1' for key 'tt_error_1.PRIMARY'
574 COMMIT;
575 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
576 include/show_binlog_events.inc
577 Log_name Pos Event_type Server_id End_log_pos Info
578 master-bin.000001 # Query # # BEGIN
579 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
580 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
581 master-bin.000001 # Query # # COMMIT
582 master-bin.000001 # Query # # BEGIN
583 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
584 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
585 master-bin.000001 # Xid # # COMMIT /* XID */
586 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
587
588 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C';
589 BEGIN;
590 INSERT INTO tt_xx_1() VALUES (1);
591 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
592 INSERT INTO nt_xx_1() VALUES (1);
593 INSERT INTO nt_error_1() VALUES (2), (2);
594 ERROR 23000: Duplicate entry '2' for key 'nt_error_1.PRIMARY'
595 COMMIT;
596 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C << -b-b-b-b-b-b-b-b-b-b-b-
597 include/show_binlog_events.inc
598 Log_name Pos Event_type Server_id End_log_pos Info
599 master-bin.000001 # Query # # BEGIN
600 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
601 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
602 master-bin.000001 # Query # # COMMIT
603 master-bin.000001 # Query # # BEGIN
604 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
605 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
606 master-bin.000001 # Query # # COMMIT
607 master-bin.000001 # Query # # BEGIN
608 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
609 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
610 master-bin.000001 # Xid # # COMMIT /* XID */
611 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C << -e-e-e-e-e-e-e-e-e-e-e-
612
613
614 #
615 #3) Generates in the binlog what follows:
616 #
617 SET @commands= 'B T Drop-Temp-T-Temp R';
618 BEGIN;
619 INSERT INTO tt_xx_1() VALUES (1);
620 DROP TEMPORARY TABLE tt_tmp_2;
621 ROLLBACK;
622 Warnings:
623 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
624 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
625 include/show_binlog_events.inc
626 -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-
627
628 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R';
629 BEGIN;
630 INSERT INTO tt_xx_1() VALUES (1);
631 DROP TEMPORARY TABLE tt_tmp_2;
632 INSERT INTO nt_xx_1() VALUES (1);
633 DROP TEMPORARY TABLE tt_tmp_1;
634 ROLLBACK;
635 Warnings:
636 Warning # Some non-transactional changed tables couldn't be rolled back
637 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
638 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
639 include/show_binlog_events.inc
640 Log_name Pos Event_type Server_id End_log_pos Info
641 master-bin.000001 # Query # # BEGIN
642 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
643 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
644 master-bin.000001 # Query # # COMMIT
645 -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-
646
647 SET @commands= 'B T Drop-Temp-N-Temp R';
648 BEGIN;
649 INSERT INTO tt_xx_1() VALUES (1);
650 DROP TEMPORARY TABLE nt_tmp_2;
651 ROLLBACK;
652 Warnings:
653 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
654 -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-
655 include/show_binlog_events.inc
656 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
657
658 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R';
659 BEGIN;
660 INSERT INTO tt_xx_1() VALUES (1);
661 DROP TEMPORARY TABLE nt_tmp_2;
662 INSERT INTO nt_xx_1() VALUES (1);
663 DROP TEMPORARY TABLE nt_tmp_1;
664 ROLLBACK;
665 Warnings:
666 Warning # Some non-transactional changed tables couldn't be rolled back
667 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
668 -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-
669 include/show_binlog_events.inc
670 Log_name Pos Event_type Server_id End_log_pos Info
671 master-bin.000001 # Query # # BEGIN
672 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
673 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
674 master-bin.000001 # Query # # COMMIT
675 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
676
677 SET @commands= 'B T Drop-Temp-Xe-Temp R';
678 BEGIN;
679 INSERT INTO tt_xx_1() VALUES (1);
680 DROP TEMPORARY TABLE tt_xx_1;
681 ERROR 42S02: Unknown table 'test.tt_xx_1'
682 ROLLBACK;
683 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
684 include/show_binlog_events.inc
685 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
686
687 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R';
688 BEGIN;
689 INSERT INTO tt_xx_1() VALUES (1);
690 DROP TEMPORARY TABLE tt_xx_1;
691 ERROR 42S02: Unknown table 'test.tt_xx_1'
692 INSERT INTO nt_xx_1() VALUES (1);
693 DROP TEMPORARY TABLE tt_xx_1;
694 ERROR 42S02: Unknown table 'test.tt_xx_1'
695 ROLLBACK;
696 Warnings:
697 Warning # Some non-transactional changed tables couldn't be rolled back
698 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
699 include/show_binlog_events.inc
700 Log_name Pos Event_type Server_id End_log_pos Info
701 master-bin.000001 # Query # # BEGIN
702 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
703 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
704 master-bin.000001 # Query # # COMMIT
705 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
706
707 SET @commands= 'B T Drop-Temp-If-Xe-Temp R';
708 BEGIN;
709 INSERT INTO tt_xx_1() VALUES (1);
710 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
711 Warnings:
712 Note 1051 Unknown table 'test.tt_xx_1'
713 ROLLBACK;
714 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
715 include/show_binlog_events.inc
716 -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-
717
718 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R';
719 BEGIN;
720 INSERT INTO tt_xx_1() VALUES (1);
721 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
722 Warnings:
723 Note 1051 Unknown table 'test.tt_xx_1'
724 INSERT INTO nt_xx_1() VALUES (1);
725 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
726 Warnings:
727 Note 1051 Unknown table 'test.tt_xx_1'
728 ROLLBACK;
729 Warnings:
730 Warning # Some non-transactional changed tables couldn't be rolled back
731 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
732 include/show_binlog_events.inc
733 Log_name Pos Event_type Server_id End_log_pos Info
734 master-bin.000001 # Query # # BEGIN
735 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
736 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
737 master-bin.000001 # Query # # COMMIT
738 -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-
739
740 SET @commands= 'B T Drop-Temp-TXe-Temp R';
741 BEGIN;
742 INSERT INTO tt_xx_1() VALUES (1);
743 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
744 ERROR 42S02: Unknown table 'test.tt_1'
745 ROLLBACK;
746 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
747 include/show_binlog_events.inc
748 -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-
749
750 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R';
751 BEGIN;
752 INSERT INTO tt_xx_1() VALUES (1);
753 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
754 ERROR 42S02: Unknown table 'test.tt_1'
755 INSERT INTO nt_xx_1() VALUES (1);
756 DROP TEMPORARY TABLE tt_tmp_1, tt_1;
757 ERROR 42S02: Unknown table 'test.tt_1'
758 ROLLBACK;
759 Warnings:
760 Warning # Some non-transactional changed tables couldn't be rolled back
761 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
762 include/show_binlog_events.inc
763 Log_name Pos Event_type Server_id End_log_pos Info
764 master-bin.000001 # Query # # BEGIN
765 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
766 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
767 master-bin.000001 # Query # # COMMIT
768 -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-
769
770 SET @commands= 'B T Drop-Temp-If-TXe-Temp R';
771 BEGIN;
772 INSERT INTO tt_xx_1() VALUES (1);
773 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
774 Warnings:
775 Note 1051 Unknown table 'test.tt_1'
776 ROLLBACK;
777 Warnings:
778 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
779 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
780 include/show_binlog_events.inc
781 -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-
782
783 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R';
784 BEGIN;
785 INSERT INTO tt_xx_1() VALUES (1);
786 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
787 Warnings:
788 Note 1051 Unknown table 'test.tt_1'
789 INSERT INTO nt_xx_1() VALUES (1);
790 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1;
791 Warnings:
792 Note 1051 Unknown table 'test.tt_1'
793 ROLLBACK;
794 Warnings:
795 Warning # Some non-transactional changed tables couldn't be rolled back
796 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
797 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
798 include/show_binlog_events.inc
799 Log_name Pos Event_type Server_id End_log_pos Info
800 master-bin.000001 # Query # # BEGIN
801 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
802 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
803 master-bin.000001 # Query # # COMMIT
804 -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-
805
806 SET @commands= 'B T Drop-Temp-NXe-Temp R';
807 BEGIN;
808 INSERT INTO tt_xx_1() VALUES (1);
809 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
810 ERROR 42S02: Unknown table 'test.tt_1'
811 ROLLBACK;
812 -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-
813 include/show_binlog_events.inc
814 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
815
816 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R';
817 BEGIN;
818 INSERT INTO tt_xx_1() VALUES (1);
819 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
820 ERROR 42S02: Unknown table 'test.tt_1'
821 INSERT INTO nt_xx_1() VALUES (1);
822 DROP TEMPORARY TABLE nt_tmp_1, tt_1;
823 ERROR 42S02: Unknown table 'test.tt_1'
824 ROLLBACK;
825 Warnings:
826 Warning # Some non-transactional changed tables couldn't be rolled back
827 -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-
828 include/show_binlog_events.inc
829 Log_name Pos Event_type Server_id End_log_pos Info
830 master-bin.000001 # Query # # BEGIN
831 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
832 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
833 master-bin.000001 # Query # # COMMIT
834 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
835
836 SET @commands= 'B T Drop-Temp-If-NXe-Temp R';
837 BEGIN;
838 INSERT INTO tt_xx_1() VALUES (1);
839 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
840 Warnings:
841 Note 1051 Unknown table 'test.tt_1'
842 ROLLBACK;
843 Warnings:
844 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
845 -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-
846 include/show_binlog_events.inc
847 -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-
848
849 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R';
850 BEGIN;
851 INSERT INTO tt_xx_1() VALUES (1);
852 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
853 Warnings:
854 Note 1051 Unknown table 'test.tt_1'
855 INSERT INTO nt_xx_1() VALUES (1);
856 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1;
857 Warnings:
858 Note 1051 Unknown table 'test.tt_1'
859 ROLLBACK;
860 Warnings:
861 Warning # Some non-transactional changed tables couldn't be rolled back
862 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
863 -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-
864 include/show_binlog_events.inc
865 Log_name Pos Event_type Server_id End_log_pos Info
866 master-bin.000001 # Query # # BEGIN
867 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
868 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
869 master-bin.000001 # Query # # COMMIT
870 -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-
871
872 SET @commands= 'B T Drop-Temp-TN-Temp R';
873 BEGIN;
874 INSERT INTO tt_xx_1() VALUES (1);
875 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
876 ROLLBACK;
877 Warnings:
878 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
879 -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-
880 include/show_binlog_events.inc
881 -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-
882
883 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R';
884 BEGIN;
885 INSERT INTO tt_xx_1() VALUES (1);
886 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
887 INSERT INTO nt_xx_1() VALUES (1);
888 DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1;
889 ROLLBACK;
890 Warnings:
891 Warning # Some non-transactional changed tables couldn't be rolled back
892 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
893 -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-
894 include/show_binlog_events.inc
895 Log_name Pos Event_type Server_id End_log_pos Info
896 master-bin.000001 # Query # # BEGIN
897 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
898 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
899 master-bin.000001 # Query # # COMMIT
900 -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-
901
902 SET @commands= 'B T Drop-Temp-TT-Temp R';
903 BEGIN;
904 INSERT INTO tt_xx_1() VALUES (1);
905 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
906 ROLLBACK;
907 Warnings:
908 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
909 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
910 include/show_binlog_events.inc
911 -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-
912
913 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R';
914 BEGIN;
915 INSERT INTO tt_xx_1() VALUES (1);
916 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
917 INSERT INTO nt_xx_1() VALUES (1);
918 ROLLBACK;
919 Warnings:
920 Warning # Some non-transactional changed tables couldn't be rolled back
921 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
922 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
923 include/show_binlog_events.inc
924 Log_name Pos Event_type Server_id End_log_pos Info
925 master-bin.000001 # Query # # BEGIN
926 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
927 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
928 master-bin.000001 # Query # # COMMIT
929 -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-
930
931 SET @commands= 'B T Drop-Temp-NN-Temp R';
932 BEGIN;
933 INSERT INTO tt_xx_1() VALUES (1);
934 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
935 ROLLBACK;
936 Warnings:
937 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
938 -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-
939 include/show_binlog_events.inc
940 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
941
942 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R';
943 BEGIN;
944 INSERT INTO tt_xx_1() VALUES (1);
945 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
946 INSERT INTO nt_xx_1() VALUES (1);
947 ROLLBACK;
948 Warnings:
949 Warning # Some non-transactional changed tables couldn't be rolled back
950 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
951 -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-
952 include/show_binlog_events.inc
953 Log_name Pos Event_type Server_id End_log_pos Info
954 master-bin.000001 # Query # # BEGIN
955 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
956 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
957 master-bin.000001 # Query # # COMMIT
958 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
959
960 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R';
961 BEGIN;
962 INSERT INTO tt_xx_1() VALUES (1);
963 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
964 INSERT INTO nt_xx_1() VALUES (1);
965 INSERT INTO nt_error_1() VALUES (3), (3);
966 ERROR 23000: Duplicate entry '3' for key 'nt_error_1.PRIMARY'
967 ROLLBACK;
968 Warnings:
969 Warning # Some non-transactional changed tables couldn't be rolled back
970 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
971 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R << -b-b-b-b-b-b-b-b-b-b-b-
972 include/show_binlog_events.inc
973 Log_name Pos Event_type Server_id End_log_pos Info
974 master-bin.000001 # Query # # BEGIN
975 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
976 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
977 master-bin.000001 # Query # # COMMIT
978 master-bin.000001 # Query # # BEGIN
979 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
980 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
981 master-bin.000001 # Query # # COMMIT
982 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R << -e-e-e-e-e-e-e-e-e-e-e-
983
984 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R';
985 BEGIN;
986 INSERT INTO tt_xx_1() VALUES (1);
987 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
988 INSERT INTO nt_xx_1() VALUES (1);
989 INSERT INTO tt_error_1() VALUES (2), (2);
990 ERROR 23000: Duplicate entry '2' for key 'tt_error_1.PRIMARY'
991 ROLLBACK;
992 Warnings:
993 Warning # Some non-transactional changed tables couldn't be rolled back
994 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
995 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
996 include/show_binlog_events.inc
997 Log_name Pos Event_type Server_id End_log_pos Info
998 master-bin.000001 # Query # # BEGIN
999 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1000 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1001 master-bin.000001 # Query # # COMMIT
1002 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
1003
1004 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R';
1005 BEGIN;
1006 INSERT INTO tt_xx_1() VALUES (1);
1007 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1008 INSERT INTO nt_xx_1() VALUES (1);
1009 INSERT INTO nt_error_1() VALUES (4), (4);
1010 ERROR 23000: Duplicate entry '4' for key 'nt_error_1.PRIMARY'
1011 ROLLBACK;
1012 Warnings:
1013 Warning # Some non-transactional changed tables couldn't be rolled back
1014 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1015 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R << -b-b-b-b-b-b-b-b-b-b-b-
1016 include/show_binlog_events.inc
1017 Log_name Pos Event_type Server_id End_log_pos Info
1018 master-bin.000001 # Query # # BEGIN
1019 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1020 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1021 master-bin.000001 # Query # # COMMIT
1022 master-bin.000001 # Query # # BEGIN
1023 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1024 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1025 master-bin.000001 # Query # # COMMIT
1026 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R << -e-e-e-e-e-e-e-e-e-e-e-
1027
1028 #########################################################################
1029 # 2 - Tables dropped by "DROP TABLE"
1030 #########################################################################
1031
1032 #
1033 #1) Generates in the binlog what follows:
1034 #
1035 SET @commands= 'Drop-T';
1036 DROP TABLE tt_2;
1037 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-T << -b-b-b-b-b-b-b-b-b-b-b-
1038 include/show_binlog_events.inc
1039 Log_name Pos Event_type Server_id End_log_pos Info
1040 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1041 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-T << -e-e-e-e-e-e-e-e-e-e-e-
1042
1043 SET @commands= 'Drop-N';
1044 DROP TABLE nt_2;
1045 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-N << -b-b-b-b-b-b-b-b-b-b-b-
1046 include/show_binlog_events.inc
1047 Log_name Pos Event_type Server_id End_log_pos Info
1048 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1049 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-N << -e-e-e-e-e-e-e-e-e-e-e-
1050
1051 SET @commands= 'Drop-Xe';
1052 DROP TABLE xx_1;
1053 ERROR 42S02: Unknown table 'test.xx_1'
1054 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Xe << -b-b-b-b-b-b-b-b-b-b-b-
1055 include/show_binlog_events.inc
1056 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Xe << -e-e-e-e-e-e-e-e-e-e-e-
1057
1058 SET @commands= 'Drop-If-Xe';
1059 DROP TABLE IF EXISTS xx_1;
1060 Warnings:
1061 Note 1051 Unknown table 'test.xx_1'
1062 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-If-Xe << -b-b-b-b-b-b-b-b-b-b-b-
1063 include/show_binlog_events.inc
1064 Log_name Pos Event_type Server_id End_log_pos Info
1065 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1066 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-If-Xe << -e-e-e-e-e-e-e-e-e-e-e-
1067
1068 SET @commands= 'Drop-TXe';
1069 DROP TABLE tt_2, xx_1;
1070 ERROR 42S02: Unknown table 'test.xx_1'
1071 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b-
1072 include/show_binlog_events.inc
1073 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e-
1074
1075 SET @commands= 'Drop-If-TXe';
1076 DROP TABLE IF EXISTS tt_2, xx_1;
1077 Warnings:
1078 Note 1051 Unknown table 'test.xx_1'
1079 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-If-TXe << -b-b-b-b-b-b-b-b-b-b-b-
1080 include/show_binlog_events.inc
1081 Log_name Pos Event_type Server_id End_log_pos Info
1082 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */
1083 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-If-TXe << -e-e-e-e-e-e-e-e-e-e-e-
1084
1085 SET @commands= 'Drop-NXe';
1086 DROP TABLE nt_2, xx_1;
1087 ERROR 42S02: Unknown table 'test.xx_1'
1088 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-NXe << -b-b-b-b-b-b-b-b-b-b-b-
1089 include/show_binlog_events.inc
1090 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-NXe << -e-e-e-e-e-e-e-e-e-e-e-
1091
1092 SET @commands= 'Drop-If-NXe';
1093 DROP TABLE IF EXISTS nt_2, xx_1;
1094 Warnings:
1095 Note 1051 Unknown table 'test.xx_1'
1096 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-If-NXe << -b-b-b-b-b-b-b-b-b-b-b-
1097 include/show_binlog_events.inc
1098 Log_name Pos Event_type Server_id End_log_pos Info
1099 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `nt_2` /* generated by server */
1100 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1101 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-If-NXe << -e-e-e-e-e-e-e-e-e-e-e-
1102
1103 SET @commands= 'Drop-TN';
1104 DROP TABLE tt_2, nt_2;
1105 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TN << -b-b-b-b-b-b-b-b-b-b-b-
1106 include/show_binlog_events.inc
1107 Log_name Pos Event_type Server_id End_log_pos Info
1108 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1109 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1110 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TN << -e-e-e-e-e-e-e-e-e-e-e-
1111
1112 SET @commands= 'Drop-TT';
1113 DROP TABLE tt_1, tt_2;
1114 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TT << -b-b-b-b-b-b-b-b-b-b-b-
1115 include/show_binlog_events.inc
1116 Log_name Pos Event_type Server_id End_log_pos Info
1117 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */
1118 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TT << -e-e-e-e-e-e-e-e-e-e-e-
1119
1120 SET @commands= 'Drop-NN';
1121 DROP TABLE nt_1, nt_2;
1122 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-NN << -b-b-b-b-b-b-b-b-b-b-b-
1123 include/show_binlog_events.inc
1124 Log_name Pos Event_type Server_id End_log_pos Info
1125 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1` /* generated by server */
1126 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1127 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-NN << -e-e-e-e-e-e-e-e-e-e-e-
1128
1129 SET @commands= 'Drop-N-TN-Temp';
1130 DROP TABLE tt_tmp_2, nt_tmp_2, nt_2;
1131 -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-
1132 include/show_binlog_events.inc
1133 Log_name Pos Event_type Server_id End_log_pos Info
1134 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1135 -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-
1136
1137 SET @commands= 'Drop-TN-Temp';
1138 DROP TABLE tt_tmp_2, nt_tmp_2;
1139 -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-
1140 include/show_binlog_events.inc
1141 -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-
1142
1143
1144 #
1145 #2) Generates in the binlog what follows:
1146 #
1147 SET @commands= 'B T Drop-T';
1148 BEGIN;
1149 INSERT INTO tt_xx_1() VALUES (1);
1150 DROP TABLE tt_2;
1151 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-T << -b-b-b-b-b-b-b-b-b-b-b-
1152 include/show_binlog_events.inc
1153 Log_name Pos Event_type Server_id End_log_pos Info
1154 master-bin.000001 # Query # # BEGIN
1155 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1156 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1157 master-bin.000001 # Xid # # COMMIT /* XID */
1158 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1159 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-T << -e-e-e-e-e-e-e-e-e-e-e-
1160
1161 SET @commands= 'B T Drop-N';
1162 BEGIN;
1163 INSERT INTO tt_xx_1() VALUES (1);
1164 DROP TABLE nt_2;
1165 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-N << -b-b-b-b-b-b-b-b-b-b-b-
1166 include/show_binlog_events.inc
1167 Log_name Pos Event_type Server_id End_log_pos Info
1168 master-bin.000001 # Query # # BEGIN
1169 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1170 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1171 master-bin.000001 # Xid # # COMMIT /* XID */
1172 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1173 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-N << -e-e-e-e-e-e-e-e-e-e-e-
1174
1175 SET @commands= 'B T Drop-Xe';
1176 BEGIN;
1177 INSERT INTO tt_xx_1() VALUES (1);
1178 DROP TABLE xx_1;
1179 ERROR 42S02: Unknown table 'test.xx_1'
1180 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Xe << -b-b-b-b-b-b-b-b-b-b-b-
1181 include/show_binlog_events.inc
1182 Log_name Pos Event_type Server_id End_log_pos Info
1183 master-bin.000001 # Query # # BEGIN
1184 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1185 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1186 master-bin.000001 # Xid # # COMMIT /* XID */
1187 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Xe << -e-e-e-e-e-e-e-e-e-e-e-
1188
1189 SET @commands= 'B T Drop-If-Xe';
1190 BEGIN;
1191 INSERT INTO tt_xx_1() VALUES (1);
1192 DROP TABLE IF EXISTS xx_1;
1193 Warnings:
1194 Note 1051 Unknown table 'test.xx_1'
1195 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-If-Xe << -b-b-b-b-b-b-b-b-b-b-b-
1196 include/show_binlog_events.inc
1197 Log_name Pos Event_type Server_id End_log_pos Info
1198 master-bin.000001 # Query # # BEGIN
1199 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1200 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1201 master-bin.000001 # Xid # # COMMIT /* XID */
1202 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1203 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-Xe << -e-e-e-e-e-e-e-e-e-e-e-
1204
1205 SET @commands= 'B T Drop-TXe';
1206 BEGIN;
1207 INSERT INTO tt_xx_1() VALUES (1);
1208 DROP TABLE tt_2, xx_1;
1209 ERROR 42S02: Unknown table 'test.xx_1'
1210 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b-
1211 include/show_binlog_events.inc
1212 Log_name Pos Event_type Server_id End_log_pos Info
1213 master-bin.000001 # Query # # BEGIN
1214 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1215 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1216 master-bin.000001 # Xid # # COMMIT /* XID */
1217 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e-
1218
1219 SET @commands= 'B T Drop-If-TXe';
1220 BEGIN;
1221 INSERT INTO tt_xx_1() VALUES (1);
1222 DROP TABLE IF EXISTS tt_2, xx_1;
1223 Warnings:
1224 Note 1051 Unknown table 'test.xx_1'
1225 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-If-TXe << -b-b-b-b-b-b-b-b-b-b-b-
1226 include/show_binlog_events.inc
1227 Log_name Pos Event_type Server_id End_log_pos Info
1228 master-bin.000001 # Query # # BEGIN
1229 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1230 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1231 master-bin.000001 # Xid # # COMMIT /* XID */
1232 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */
1233 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-TXe << -e-e-e-e-e-e-e-e-e-e-e-
1234
1235 SET @commands= 'B T Drop-NXe';
1236 BEGIN;
1237 INSERT INTO tt_xx_1() VALUES (1);
1238 DROP TABLE nt_2, xx_1;
1239 ERROR 42S02: Unknown table 'test.xx_1'
1240 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-NXe << -b-b-b-b-b-b-b-b-b-b-b-
1241 include/show_binlog_events.inc
1242 Log_name Pos Event_type Server_id End_log_pos Info
1243 master-bin.000001 # Query # # BEGIN
1244 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1245 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1246 master-bin.000001 # Xid # # COMMIT /* XID */
1247 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-NXe << -e-e-e-e-e-e-e-e-e-e-e-
1248
1249 SET @commands= 'B T Drop-If-NXe';
1250 BEGIN;
1251 INSERT INTO tt_xx_1() VALUES (1);
1252 DROP TABLE IF EXISTS nt_2, xx_1;
1253 Warnings:
1254 Note 1051 Unknown table 'test.xx_1'
1255 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-If-NXe << -b-b-b-b-b-b-b-b-b-b-b-
1256 include/show_binlog_events.inc
1257 Log_name Pos Event_type Server_id End_log_pos Info
1258 master-bin.000001 # Query # # BEGIN
1259 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1260 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1261 master-bin.000001 # Xid # # COMMIT /* XID */
1262 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `nt_2` /* generated by server */
1263 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1264 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-NXe << -e-e-e-e-e-e-e-e-e-e-e-
1265
1266 SET @commands= 'B T Drop-TN';
1267 BEGIN;
1268 INSERT INTO tt_xx_1() VALUES (1);
1269 DROP TABLE tt_2, nt_2;
1270 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TN << -b-b-b-b-b-b-b-b-b-b-b-
1271 include/show_binlog_events.inc
1272 Log_name Pos Event_type Server_id End_log_pos Info
1273 master-bin.000001 # Query # # BEGIN
1274 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1275 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1276 master-bin.000001 # Xid # # COMMIT /* XID */
1277 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1278 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1279 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TN << -e-e-e-e-e-e-e-e-e-e-e-
1280
1281 SET @commands= 'B T Drop-TT';
1282 BEGIN;
1283 INSERT INTO tt_xx_1() VALUES (1);
1284 DROP TABLE tt_1, tt_2;
1285 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TT << -b-b-b-b-b-b-b-b-b-b-b-
1286 include/show_binlog_events.inc
1287 Log_name Pos Event_type Server_id End_log_pos Info
1288 master-bin.000001 # Query # # BEGIN
1289 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1290 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1291 master-bin.000001 # Xid # # COMMIT /* XID */
1292 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */
1293 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TT << -e-e-e-e-e-e-e-e-e-e-e-
1294
1295 SET @commands= 'B T Drop-NN';
1296 BEGIN;
1297 INSERT INTO tt_xx_1() VALUES (1);
1298 DROP TABLE nt_1, nt_2;
1299 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-NN << -b-b-b-b-b-b-b-b-b-b-b-
1300 include/show_binlog_events.inc
1301 Log_name Pos Event_type Server_id End_log_pos Info
1302 master-bin.000001 # Query # # BEGIN
1303 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1304 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1305 master-bin.000001 # Xid # # COMMIT /* XID */
1306 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1` /* generated by server */
1307 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1308 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-NN << -e-e-e-e-e-e-e-e-e-e-e-
1309
1310 SET @commands= 'B T Drop-N-TN-Temp';
1311 BEGIN;
1312 INSERT INTO tt_xx_1() VALUES (1);
1313 DROP TABLE tt_tmp_2, nt_tmp_2, nt_2;
1314 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-N-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b-
1315 include/show_binlog_events.inc
1316 Log_name Pos Event_type Server_id End_log_pos Info
1317 master-bin.000001 # Query # # BEGIN
1318 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1319 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1320 master-bin.000001 # Xid # # COMMIT /* XID */
1321 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1322 -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-
1323
1324 SET @commands= 'B T Drop-TN-Temp';
1325 BEGIN;
1326 INSERT INTO tt_xx_1() VALUES (1);
1327 DROP TABLE tt_tmp_2, nt_tmp_2;
1328 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TN-Temp << -b-b-b-b-b-b-b-b-b-b-b-
1329 include/show_binlog_events.inc
1330 Log_name Pos Event_type Server_id End_log_pos Info
1331 master-bin.000001 # Query # # BEGIN
1332 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1333 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1334 master-bin.000001 # Xid # # COMMIT /* XID */
1335 -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-
1336
1337 #########################################################################
1338 # 3 - CREATE TEMPORARY TABLE
1339 #########################################################################
1340
1341 #
1342 #1) Generates in the binlog what follows:
1343 #
1344 SET @commands= 'Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp';
1345 DROP TEMPORARY TABLE nt_tmp_2;
1346 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1347 DROP TEMPORARY TABLE nt_tmp_1;
1348 DROP TEMPORARY TABLE nt_tmp_2;
1349 -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-
1350 include/show_binlog_events.inc
1351 -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-
1352
1353 SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp';
1354 DROP TEMPORARY TABLE tt_tmp_2;
1355 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1356 DROP TEMPORARY TABLE tt_tmp_1;
1357 DROP TEMPORARY TABLE tt_tmp_2;
1358 -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-
1359 include/show_binlog_events.inc
1360 -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-
1361
1362
1363 #
1364 #2) Generates in the binlog what follows:
1365 #
1366 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C';
1367 BEGIN;
1368 INSERT INTO tt_xx_1() VALUES (1);
1369 DROP TEMPORARY TABLE nt_tmp_2;
1370 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1371 DROP TEMPORARY TABLE nt_tmp_1;
1372 DROP TEMPORARY TABLE nt_tmp_2;
1373 COMMIT;
1374 -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-
1375 include/show_binlog_events.inc
1376 Log_name Pos Event_type Server_id End_log_pos Info
1377 master-bin.000001 # Query # # BEGIN
1378 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1379 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1380 master-bin.000001 # Xid # # COMMIT /* XID */
1381 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
1382
1383 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C';
1384 BEGIN;
1385 DROP TEMPORARY TABLE tt_tmp_2;
1386 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1387 DROP TEMPORARY TABLE tt_tmp_1;
1388 DROP TEMPORARY TABLE tt_tmp_2;
1389 COMMIT;
1390 -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-
1391 include/show_binlog_events.inc
1392 -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-
1393
1394 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C';
1395 BEGIN;
1396 DROP TEMPORARY TABLE tt_tmp_2;
1397 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1398 DROP TEMPORARY TABLE tt_tmp_1;
1399 DROP TEMPORARY TABLE tt_tmp_2;
1400 INSERT INTO nt_error_1() VALUES (5), (5);
1401 ERROR 23000: Duplicate entry '5' for key 'nt_error_1.PRIMARY'
1402 COMMIT;
1403 -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 Ne C << -b-b-b-b-b-b-b-b-b-b-b-
1404 include/show_binlog_events.inc
1405 Log_name Pos Event_type Server_id End_log_pos Info
1406 master-bin.000001 # Query # # BEGIN
1407 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1408 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1409 master-bin.000001 # Query # # COMMIT
1410 -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 Ne C << -e-e-e-e-e-e-e-e-e-e-e-
1411
1412 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C';
1413 BEGIN;
1414 DROP TEMPORARY TABLE tt_tmp_2;
1415 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1416 DROP TEMPORARY TABLE tt_tmp_1;
1417 DROP TEMPORARY TABLE tt_tmp_2;
1418 INSERT INTO tt_error_1() VALUES (3), (3);
1419 ERROR 23000: Duplicate entry '3' for key 'tt_error_1.PRIMARY'
1420 COMMIT;
1421 -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 Te C << -b-b-b-b-b-b-b-b-b-b-b-
1422 include/show_binlog_events.inc
1423 -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 Te C << -e-e-e-e-e-e-e-e-e-e-e-
1424
1425 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C';
1426 BEGIN;
1427 DROP TEMPORARY TABLE tt_tmp_2;
1428 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1429 DROP TEMPORARY TABLE tt_tmp_1;
1430 DROP TEMPORARY TABLE tt_tmp_2;
1431 INSERT INTO nt_error_1() VALUES (6), (6);
1432 ERROR 23000: Duplicate entry '6' for key 'nt_error_1.PRIMARY'
1433 COMMIT;
1434 -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 NeT-trig C << -b-b-b-b-b-b-b-b-b-b-b-
1435 include/show_binlog_events.inc
1436 Log_name Pos Event_type Server_id End_log_pos Info
1437 master-bin.000001 # Query # # BEGIN
1438 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1439 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1440 master-bin.000001 # Query # # COMMIT
1441 -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 NeT-trig C << -e-e-e-e-e-e-e-e-e-e-e-
1442
1443
1444 #
1445 #3) Generates in the binlog what follows:
1446 #
1447 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R';
1448 BEGIN;
1449 INSERT INTO tt_xx_1() VALUES (1);
1450 DROP TEMPORARY TABLE nt_tmp_2;
1451 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1452 DROP TEMPORARY TABLE nt_tmp_1;
1453 DROP TEMPORARY TABLE nt_tmp_2;
1454 ROLLBACK;
1455 Warnings:
1456 Warning # The creation of some temporary tables could not be rolled back.
1457 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1458 -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-
1459 include/show_binlog_events.inc
1460 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
1461
1462 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R';
1463 BEGIN;
1464 DROP TEMPORARY TABLE tt_tmp_2;
1465 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1466 DROP TEMPORARY TABLE tt_tmp_1;
1467 DROP TEMPORARY TABLE tt_tmp_2;
1468 ROLLBACK;
1469 Warnings:
1470 Warning # The creation of some temporary tables could not be rolled back.
1471 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1472 -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-
1473 include/show_binlog_events.inc
1474 -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-
1475
1476 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R';
1477 BEGIN;
1478 DROP TEMPORARY TABLE tt_tmp_2;
1479 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1480 DROP TEMPORARY TABLE tt_tmp_1;
1481 DROP TEMPORARY TABLE tt_tmp_2;
1482 INSERT INTO nt_error_1() VALUES (7), (7);
1483 ERROR 23000: Duplicate entry '7' for key 'nt_error_1.PRIMARY'
1484 ROLLBACK;
1485 Warnings:
1486 Warning # Some non-transactional changed tables couldn't be rolled back
1487 Warning # The creation of some temporary tables could not be rolled back.
1488 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1489 -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 Ne R << -b-b-b-b-b-b-b-b-b-b-b-
1490 include/show_binlog_events.inc
1491 Log_name Pos Event_type Server_id End_log_pos Info
1492 master-bin.000001 # Query # # BEGIN
1493 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1494 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1495 master-bin.000001 # Query # # COMMIT
1496 -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 Ne R << -e-e-e-e-e-e-e-e-e-e-e-
1497
1498 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R';
1499 BEGIN;
1500 DROP TEMPORARY TABLE tt_tmp_2;
1501 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1502 DROP TEMPORARY TABLE tt_tmp_1;
1503 DROP TEMPORARY TABLE tt_tmp_2;
1504 INSERT INTO tt_error_1() VALUES (4), (4);
1505 ERROR 23000: Duplicate entry '4' for key 'tt_error_1.PRIMARY'
1506 ROLLBACK;
1507 Warnings:
1508 Warning # The creation of some temporary tables could not be rolled back.
1509 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1510 -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 Te R << -b-b-b-b-b-b-b-b-b-b-b-
1511 include/show_binlog_events.inc
1512 -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 Te R << -e-e-e-e-e-e-e-e-e-e-e-
1513
1514 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R';
1515 BEGIN;
1516 DROP TEMPORARY TABLE tt_tmp_2;
1517 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1518 DROP TEMPORARY TABLE tt_tmp_1;
1519 DROP TEMPORARY TABLE tt_tmp_2;
1520 INSERT INTO nt_error_1() VALUES (8), (8);
1521 ERROR 23000: Duplicate entry '8' for key 'nt_error_1.PRIMARY'
1522 ROLLBACK;
1523 Warnings:
1524 Warning # Some non-transactional changed tables couldn't be rolled back
1525 Warning # The creation of some temporary tables could not be rolled back.
1526 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1527 -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 NeT-trig R << -b-b-b-b-b-b-b-b-b-b-b-
1528 include/show_binlog_events.inc
1529 Log_name Pos Event_type Server_id End_log_pos Info
1530 master-bin.000001 # Query # # BEGIN
1531 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1532 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1533 master-bin.000001 # Query # # COMMIT
1534 -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 NeT-trig R << -e-e-e-e-e-e-e-e-e-e-e-
1535
1536 #########################################################################
1537 # 4 - CHANGING TEMPORARY TABLES
1538 #########################################################################
1539
1540 #
1541 #1) Generates in the binlog what follows:
1542 #
1543 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp C';
1544 BEGIN;
1545 INSERT INTO nt_xx_1() VALUES (1);
1546 INSERT INTO nt_tmp_xx_1() VALUES (1);
1547 INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1;
1548 INSERT INTO nt_tmp_xx_1() VALUES (1);
1549 COMMIT;
1550 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-N-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
1551 include/show_binlog_events.inc
1552 Log_name Pos Event_type Server_id End_log_pos Info
1553 master-bin.000001 # Query # # BEGIN
1554 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1555 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1556 master-bin.000001 # Query # # COMMIT
1557 master-bin.000001 # Query # # BEGIN
1558 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1559 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1560 master-bin.000001 # Query # # COMMIT
1561 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-N-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
1562
1563 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp C';
1564 BEGIN;
1565 INSERT INTO nt_xx_1() VALUES (1);
1566 INSERT INTO nt_tmp_xx_1() VALUES (1);
1567 INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1;
1568 INSERT INTO nt_tmp_xx_1() VALUES (1);
1569 COMMIT;
1570 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-N-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
1571 include/show_binlog_events.inc
1572 Log_name Pos Event_type Server_id End_log_pos Info
1573 master-bin.000001 # Query # # BEGIN
1574 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1575 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1576 master-bin.000001 # Query # # COMMIT
1577 master-bin.000001 # Query # # BEGIN
1578 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1579 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1580 master-bin.000001 # Xid # # COMMIT /* XID */
1581 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-N-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
1582
1583 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp C';
1584 BEGIN;
1585 INSERT INTO nt_xx_1() VALUES (1);
1586 INSERT INTO nt_tmp_xx_1() VALUES (1);
1587 INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1;
1588 INSERT INTO nt_tmp_xx_1() VALUES (1);
1589 COMMIT;
1590 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-T-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
1591 include/show_binlog_events.inc
1592 Log_name Pos Event_type Server_id End_log_pos Info
1593 master-bin.000001 # Query # # BEGIN
1594 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1595 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1596 master-bin.000001 # Query # # COMMIT
1597 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-T-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
1598
1599 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp C';
1600 BEGIN;
1601 INSERT INTO nt_xx_1() VALUES (1);
1602 INSERT INTO nt_tmp_xx_1() VALUES (1);
1603 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1604 INSERT INTO nt_tmp_xx_1() VALUES (1);
1605 COMMIT;
1606 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
1607 include/show_binlog_events.inc
1608 Log_name Pos Event_type Server_id End_log_pos Info
1609 master-bin.000001 # Query # # BEGIN
1610 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1611 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1612 master-bin.000001 # Query # # COMMIT
1613 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp C << -e-e-e-e-e-e-e-e-e-e-e-
1614
1615 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne C';
1616 BEGIN;
1617 INSERT INTO nt_xx_1() VALUES (1);
1618 INSERT INTO nt_tmp_xx_1() VALUES (1);
1619 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1620 INSERT INTO nt_tmp_xx_1() VALUES (1);
1621 INSERT INTO nt_error_1() VALUES (9), (9);
1622 ERROR 23000: Duplicate entry '9' for key 'nt_error_1.PRIMARY'
1623 COMMIT;
1624 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne C << -b-b-b-b-b-b-b-b-b-b-b-
1625 include/show_binlog_events.inc
1626 Log_name Pos Event_type Server_id End_log_pos Info
1627 master-bin.000001 # Query # # BEGIN
1628 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1629 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1630 master-bin.000001 # Query # # COMMIT
1631 master-bin.000001 # Query # # BEGIN
1632 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1633 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1634 master-bin.000001 # Query # # COMMIT
1635 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne C << -e-e-e-e-e-e-e-e-e-e-e-
1636
1637 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te C';
1638 BEGIN;
1639 INSERT INTO nt_xx_1() VALUES (1);
1640 INSERT INTO nt_tmp_xx_1() VALUES (1);
1641 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1642 INSERT INTO nt_tmp_xx_1() VALUES (1);
1643 INSERT INTO tt_error_1() VALUES (5), (5);
1644 ERROR 23000: Duplicate entry '5' for key 'tt_error_1.PRIMARY'
1645 COMMIT;
1646 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
1647 include/show_binlog_events.inc
1648 Log_name Pos Event_type Server_id End_log_pos Info
1649 master-bin.000001 # Query # # BEGIN
1650 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1651 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1652 master-bin.000001 # Query # # COMMIT
1653 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
1654
1655 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C';
1656 BEGIN;
1657 INSERT INTO nt_xx_1() VALUES (1);
1658 INSERT INTO nt_tmp_xx_1() VALUES (1);
1659 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1660 INSERT INTO nt_tmp_xx_1() VALUES (1);
1661 INSERT INTO nt_error_1() VALUES (10), (10);
1662 ERROR 23000: Duplicate entry '10' for key 'nt_error_1.PRIMARY'
1663 COMMIT;
1664 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C << -b-b-b-b-b-b-b-b-b-b-b-
1665 include/show_binlog_events.inc
1666 Log_name Pos Event_type Server_id End_log_pos Info
1667 master-bin.000001 # Query # # BEGIN
1668 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1669 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1670 master-bin.000001 # Query # # COMMIT
1671 master-bin.000001 # Query # # BEGIN
1672 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1673 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1674 master-bin.000001 # Query # # COMMIT
1675 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C << -e-e-e-e-e-e-e-e-e-e-e-
1676
1677
1678
1679 #
1680 #2) Generates in the binlog what follows:
1681 #
1682 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp R';
1683 BEGIN;
1684 INSERT INTO nt_xx_1() VALUES (1);
1685 INSERT INTO nt_tmp_xx_1() VALUES (1);
1686 INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1;
1687 INSERT INTO nt_tmp_xx_1() VALUES (1);
1688 ROLLBACK;
1689 Warnings:
1690 Warning # Some non-transactional changed tables couldn't be rolled back
1691 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-N-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1692 include/show_binlog_events.inc
1693 Log_name Pos Event_type Server_id End_log_pos Info
1694 master-bin.000001 # Query # # BEGIN
1695 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1696 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1697 master-bin.000001 # Query # # COMMIT
1698 master-bin.000001 # Query # # BEGIN
1699 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1700 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1701 master-bin.000001 # Query # # COMMIT
1702 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-N-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
1703
1704 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp R';
1705 BEGIN;
1706 INSERT INTO nt_xx_1() VALUES (1);
1707 INSERT INTO nt_tmp_xx_1() VALUES (1);
1708 INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1;
1709 INSERT INTO nt_tmp_xx_1() VALUES (1);
1710 ROLLBACK;
1711 Warnings:
1712 Warning # Some non-transactional changed tables couldn't be rolled back
1713 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-N-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1714 include/show_binlog_events.inc
1715 Log_name Pos Event_type Server_id End_log_pos Info
1716 master-bin.000001 # Query # # BEGIN
1717 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1718 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1719 master-bin.000001 # Query # # COMMIT
1720 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-N-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
1721
1722 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp R';
1723 BEGIN;
1724 INSERT INTO nt_xx_1() VALUES (1);
1725 INSERT INTO nt_tmp_xx_1() VALUES (1);
1726 INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1;
1727 INSERT INTO nt_tmp_xx_1() VALUES (1);
1728 ROLLBACK;
1729 Warnings:
1730 Warning # Some non-transactional changed tables couldn't be rolled back
1731 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp N-SELECT-T-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1732 include/show_binlog_events.inc
1733 Log_name Pos Event_type Server_id End_log_pos Info
1734 master-bin.000001 # Query # # BEGIN
1735 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1736 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1737 master-bin.000001 # Query # # COMMIT
1738 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp N-SELECT-T-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
1739
1740 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp R';
1741 BEGIN;
1742 INSERT INTO nt_xx_1() VALUES (1);
1743 INSERT INTO nt_tmp_xx_1() VALUES (1);
1744 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1745 INSERT INTO nt_tmp_xx_1() VALUES (1);
1746 ROLLBACK;
1747 Warnings:
1748 Warning # Some non-transactional changed tables couldn't be rolled back
1749 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
1750 include/show_binlog_events.inc
1751 Log_name Pos Event_type Server_id End_log_pos Info
1752 master-bin.000001 # Query # # BEGIN
1753 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1754 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1755 master-bin.000001 # Query # # COMMIT
1756 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp R << -e-e-e-e-e-e-e-e-e-e-e-
1757
1758 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne R';
1759 BEGIN;
1760 INSERT INTO nt_xx_1() VALUES (1);
1761 INSERT INTO nt_tmp_xx_1() VALUES (1);
1762 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1763 INSERT INTO nt_tmp_xx_1() VALUES (1);
1764 INSERT INTO nt_error_1() VALUES (11), (11);
1765 ERROR 23000: Duplicate entry '11' for key 'nt_error_1.PRIMARY'
1766 ROLLBACK;
1767 Warnings:
1768 Warning # Some non-transactional changed tables couldn't be rolled back
1769 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne R << -b-b-b-b-b-b-b-b-b-b-b-
1770 include/show_binlog_events.inc
1771 Log_name Pos Event_type Server_id End_log_pos Info
1772 master-bin.000001 # Query # # BEGIN
1773 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1774 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1775 master-bin.000001 # Query # # COMMIT
1776 master-bin.000001 # Query # # BEGIN
1777 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1778 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1779 master-bin.000001 # Query # # COMMIT
1780 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Ne R << -e-e-e-e-e-e-e-e-e-e-e-
1781
1782 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te R';
1783 BEGIN;
1784 INSERT INTO nt_xx_1() VALUES (1);
1785 INSERT INTO nt_tmp_xx_1() VALUES (1);
1786 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1787 INSERT INTO nt_tmp_xx_1() VALUES (1);
1788 INSERT INTO tt_error_1() VALUES (6), (6);
1789 ERROR 23000: Duplicate entry '6' for key 'tt_error_1.PRIMARY'
1790 ROLLBACK;
1791 Warnings:
1792 Warning # Some non-transactional changed tables couldn't be rolled back
1793 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
1794 include/show_binlog_events.inc
1795 Log_name Pos Event_type Server_id End_log_pos Info
1796 master-bin.000001 # Query # # BEGIN
1797 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1798 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1799 master-bin.000001 # Query # # COMMIT
1800 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
1801
1802 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R';
1803 BEGIN;
1804 INSERT INTO nt_xx_1() VALUES (1);
1805 INSERT INTO nt_tmp_xx_1() VALUES (1);
1806 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1807 INSERT INTO nt_tmp_xx_1() VALUES (1);
1808 INSERT INTO nt_error_1() VALUES (12), (12);
1809 ERROR 23000: Duplicate entry '12' for key 'nt_error_1.PRIMARY'
1810 ROLLBACK;
1811 Warnings:
1812 Warning # Some non-transactional changed tables couldn't be rolled back
1813 -b-b-b-b-b-b-b-b-b-b-b- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R << -b-b-b-b-b-b-b-b-b-b-b-
1814 include/show_binlog_events.inc
1815 Log_name Pos Event_type Server_id End_log_pos Info
1816 master-bin.000001 # Query # # BEGIN
1817 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1818 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1819 master-bin.000001 # Query # # COMMIT
1820 master-bin.000001 # Query # # BEGIN
1821 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1822 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
1823 master-bin.000001 # Query # # COMMIT
1824 -e-e-e-e-e-e-e-e-e-e-e- >> B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R << -e-e-e-e-e-e-e-e-e-e-e-
1825
1826 ###################################################################################
1827 # CHECK CONSISTENCY
1828 ###################################################################################
1829 #########################################################################
1830 # CLEAN
1831 #########################################################################
1832 SET @commands= 'clean';
1833 DROP TABLE IF EXISTS tt_xx_1;
1834 DROP TABLE IF EXISTS nt_xx_1;
1835 DROP TABLE IF EXISTS tt_error_1;
1836 DROP TABLE IF EXISTS nt_error_1;
1837 DROP TABLE IF EXISTS tt_error_2;
1838 DROP TABLE IF EXISTS nt_error_2;
1839 DROP TEMPORARY TABLE IF EXISTS tt_tmp_xx_1;
1840 DROP TEMPORARY TABLE IF EXISTS nt_tmp_xx_1;
1841 DROP TABLE IF EXISTS nt_2;
1842 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2;
1843 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2;
1844 DROP TABLE IF EXISTS nt_1;
1845 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1;
1846 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1;
1847 DROP TABLE IF EXISTS tt_2;
1848 DROP TABLE IF EXISTS tt_1;
1849 SET @commands= '';
1850 include/rpl_end.inc