Debian Codegraph @

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