Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_stm_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 Log_name Pos Event_type Server_id End_log_pos Info
69 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
70 -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
71
72 SET @commands= 'Drop-Temp-N-Temp';
73 DROP TEMPORARY TABLE nt_tmp_2;
74 -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-
75 include/show_binlog_events.inc
76 Log_name Pos Event_type Server_id End_log_pos Info
77 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
78 -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-
79
80 SET @commands= 'Drop-Temp-Xe-Temp';
81 DROP TEMPORARY TABLE tt_xx_1;
82 ERROR 42S02: Unknown table 'test.tt_xx_1'
83 -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-
84 include/show_binlog_events.inc
85 -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-
86
87 SET @commands= 'Drop-Temp-If-Xe-Temp';
88 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
89 Warnings:
90 Note 1051 Unknown table 'test.tt_xx_1'
91 -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-
92 include/show_binlog_events.inc
93 -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-
94
95 SET @commands= 'Drop-Temp-TXe-Temp';
96 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
97 ERROR 42S02: Unknown table 'test.tt_1'
98 -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-
99 include/show_binlog_events.inc
100 -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-
101
102 SET @commands= 'Drop-Temp-If-TXe-Temp';
103 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
104 Warnings:
105 Note 1051 Unknown table 'test.tt_1'
106 -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-
107 include/show_binlog_events.inc
108 Log_name Pos Event_type Server_id End_log_pos Info
109 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
110 -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-
111
112 SET @commands= 'Drop-Temp-NXe-Temp';
113 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
114 ERROR 42S02: Unknown table 'test.tt_1'
115 -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-
116 include/show_binlog_events.inc
117 -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-
118
119 SET @commands= 'Drop-Temp-If-NXe-Temp';
120 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
121 Warnings:
122 Note 1051 Unknown table 'test.tt_1'
123 -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-
124 include/show_binlog_events.inc
125 Log_name Pos Event_type Server_id End_log_pos Info
126 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
127 -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-
128
129 SET @commands= 'Drop-Temp-TN-Temp';
130 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
131 -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-
132 include/show_binlog_events.inc
133 Log_name Pos Event_type Server_id End_log_pos Info
134 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
135 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
136 -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-
137
138 SET @commands= 'Drop-Temp-TT-Temp';
139 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
140 -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-
141 include/show_binlog_events.inc
142 Log_name Pos Event_type Server_id End_log_pos Info
143 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
144 -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-
145
146 SET @commands= 'Drop-Temp-NN-Temp';
147 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
148 -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-
149 include/show_binlog_events.inc
150 Log_name Pos Event_type Server_id End_log_pos Info
151 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
152 -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-
153
154
155 #
156 #2) Generates in the binlog what follows:
157 #
158 SET @commands= 'B T Drop-Temp-T-Temp C';
159 BEGIN;
160 INSERT INTO tt_xx_1() VALUES (1);
161 DROP TEMPORARY TABLE tt_tmp_2;
162 COMMIT;
163 -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-
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 tt_xx_1() VALUES (1)
168 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
169 master-bin.000001 # Xid # # COMMIT /* XID */
170 -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-
171
172 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C';
173 BEGIN;
174 INSERT INTO tt_xx_1() VALUES (1);
175 DROP TEMPORARY TABLE tt_tmp_2;
176 INSERT INTO nt_xx_1() VALUES (1);
177 DROP TEMPORARY TABLE tt_tmp_1;
178 COMMIT;
179 -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-
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 nt_xx_1() VALUES (1)
184 master-bin.000001 # Query # # COMMIT
185 master-bin.000001 # Query # # BEGIN
186 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
187 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
188 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
189 master-bin.000001 # Xid # # COMMIT /* XID */
190 -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-
191
192 SET @commands= 'B T Drop-Temp-N-Temp C';
193 BEGIN;
194 INSERT INTO tt_xx_1() VALUES (1);
195 DROP TEMPORARY TABLE nt_tmp_2;
196 COMMIT;
197 -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-
198 include/show_binlog_events.inc
199 Log_name Pos Event_type Server_id End_log_pos Info
200 master-bin.000001 # Query # # BEGIN
201 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
202 master-bin.000001 # Query # # COMMIT
203 master-bin.000001 # Query # # BEGIN
204 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
205 master-bin.000001 # Xid # # COMMIT /* XID */
206 -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-
207
208 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C';
209 BEGIN;
210 INSERT INTO tt_xx_1() VALUES (1);
211 DROP TEMPORARY TABLE nt_tmp_2;
212 INSERT INTO nt_xx_1() VALUES (1);
213 DROP TEMPORARY TABLE nt_tmp_1;
214 COMMIT;
215 -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-
216 include/show_binlog_events.inc
217 Log_name Pos Event_type Server_id End_log_pos Info
218 master-bin.000001 # Query # # BEGIN
219 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
220 master-bin.000001 # Query # # COMMIT
221 master-bin.000001 # Query # # BEGIN
222 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
223 master-bin.000001 # Query # # COMMIT
224 master-bin.000001 # Query # # BEGIN
225 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
226 master-bin.000001 # Query # # COMMIT
227 master-bin.000001 # Query # # BEGIN
228 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
229 master-bin.000001 # Xid # # COMMIT /* XID */
230 -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-
231
232 SET @commands= 'B T Drop-Temp-Xe-Temp C';
233 BEGIN;
234 INSERT INTO tt_xx_1() VALUES (1);
235 DROP TEMPORARY TABLE tt_xx_1;
236 ERROR 42S02: Unknown table 'test.tt_xx_1'
237 COMMIT;
238 -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-
239 include/show_binlog_events.inc
240 Log_name Pos Event_type Server_id End_log_pos Info
241 master-bin.000001 # Query # # BEGIN
242 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
243 master-bin.000001 # Xid # # COMMIT /* XID */
244 -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-
245
246 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C';
247 BEGIN;
248 INSERT INTO tt_xx_1() VALUES (1);
249 DROP TEMPORARY TABLE tt_xx_1;
250 ERROR 42S02: Unknown table 'test.tt_xx_1'
251 INSERT INTO nt_xx_1() VALUES (1);
252 DROP TEMPORARY TABLE tt_xx_1;
253 ERROR 42S02: Unknown table 'test.tt_xx_1'
254 COMMIT;
255 -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-
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 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
260 master-bin.000001 # Query # # COMMIT
261 master-bin.000001 # Query # # BEGIN
262 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
263 master-bin.000001 # Xid # # COMMIT /* XID */
264 -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-
265
266 SET @commands= 'B T Drop-Temp-If-Xe-Temp C';
267 BEGIN;
268 INSERT INTO tt_xx_1() VALUES (1);
269 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
270 Warnings:
271 Note 1051 Unknown table 'test.tt_xx_1'
272 COMMIT;
273 -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-
274 include/show_binlog_events.inc
275 Log_name Pos Event_type Server_id End_log_pos Info
276 master-bin.000001 # Query # # BEGIN
277 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
278 master-bin.000001 # Xid # # COMMIT /* XID */
279 -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-
280
281 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C';
282 BEGIN;
283 INSERT INTO tt_xx_1() VALUES (1);
284 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
285 Warnings:
286 Note 1051 Unknown table 'test.tt_xx_1'
287 INSERT INTO nt_xx_1() VALUES (1);
288 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
289 Warnings:
290 Note 1051 Unknown table 'test.tt_xx_1'
291 COMMIT;
292 -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-
293 include/show_binlog_events.inc
294 Log_name Pos Event_type Server_id End_log_pos Info
295 master-bin.000001 # Query # # BEGIN
296 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
297 master-bin.000001 # Query # # COMMIT
298 master-bin.000001 # Query # # BEGIN
299 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
300 master-bin.000001 # Xid # # COMMIT /* XID */
301 -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-
302
303 SET @commands= 'B T 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 COMMIT;
309 -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-
310 include/show_binlog_events.inc
311 Log_name Pos Event_type Server_id End_log_pos Info
312 master-bin.000001 # Query # # BEGIN
313 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
314 master-bin.000001 # Xid # # COMMIT /* XID */
315 -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-
316
317 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C';
318 BEGIN;
319 INSERT INTO tt_xx_1() VALUES (1);
320 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
321 ERROR 42S02: Unknown table 'test.tt_1'
322 INSERT INTO nt_xx_1() VALUES (1);
323 DROP TEMPORARY TABLE tt_tmp_1, tt_1;
324 ERROR 42S02: Unknown table 'test.tt_1'
325 COMMIT;
326 -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-
327 include/show_binlog_events.inc
328 Log_name Pos Event_type Server_id End_log_pos Info
329 master-bin.000001 # Query # # BEGIN
330 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
331 master-bin.000001 # Query # # COMMIT
332 master-bin.000001 # Query # # BEGIN
333 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
334 master-bin.000001 # Xid # # COMMIT /* XID */
335 -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-
336
337 SET @commands= 'B T Drop-Temp-If-TXe-Temp C';
338 BEGIN;
339 INSERT INTO tt_xx_1() VALUES (1);
340 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
341 Warnings:
342 Note 1051 Unknown table 'test.tt_1'
343 COMMIT;
344 -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-
345 include/show_binlog_events.inc
346 Log_name Pos Event_type Server_id End_log_pos Info
347 master-bin.000001 # Query # # BEGIN
348 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
349 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
350 master-bin.000001 # Xid # # COMMIT /* XID */
351 -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-
352
353 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C';
354 BEGIN;
355 INSERT INTO tt_xx_1() VALUES (1);
356 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
357 Warnings:
358 Note 1051 Unknown table 'test.tt_1'
359 INSERT INTO nt_xx_1() VALUES (1);
360 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1;
361 Warnings:
362 Note 1051 Unknown table 'test.tt_1'
363 COMMIT;
364 -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-
365 include/show_binlog_events.inc
366 Log_name Pos Event_type Server_id End_log_pos Info
367 master-bin.000001 # Query # # BEGIN
368 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
369 master-bin.000001 # Query # # COMMIT
370 master-bin.000001 # Query # # BEGIN
371 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
372 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
373 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
374 master-bin.000001 # Xid # # COMMIT /* XID */
375 -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-
376
377 SET @commands= 'B T Drop-Temp-NXe-Temp C';
378 BEGIN;
379 INSERT INTO tt_xx_1() VALUES (1);
380 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
381 ERROR 42S02: Unknown table 'test.tt_1'
382 COMMIT;
383 -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-
384 include/show_binlog_events.inc
385 Log_name Pos Event_type Server_id End_log_pos Info
386 master-bin.000001 # Query # # BEGIN
387 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
388 master-bin.000001 # Xid # # COMMIT /* XID */
389 -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-
390
391 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C';
392 BEGIN;
393 INSERT INTO tt_xx_1() VALUES (1);
394 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
395 ERROR 42S02: Unknown table 'test.tt_1'
396 INSERT INTO nt_xx_1() VALUES (1);
397 DROP TEMPORARY TABLE nt_tmp_1, tt_1;
398 ERROR 42S02: Unknown table 'test.tt_1'
399 COMMIT;
400 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C << -b-b-b-b-b-b-b-b-b-b-b-
401 include/show_binlog_events.inc
402 Log_name Pos Event_type Server_id End_log_pos Info
403 master-bin.000001 # Query # # BEGIN
404 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
405 master-bin.000001 # Query # # COMMIT
406 master-bin.000001 # Query # # BEGIN
407 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
408 master-bin.000001 # Xid # # COMMIT /* XID */
409 -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-
410
411 SET @commands= 'B T Drop-Temp-If-NXe-Temp C';
412 BEGIN;
413 INSERT INTO tt_xx_1() VALUES (1);
414 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
415 Warnings:
416 Note 1051 Unknown table 'test.tt_1'
417 COMMIT;
418 -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-
419 include/show_binlog_events.inc
420 Log_name Pos Event_type Server_id End_log_pos Info
421 master-bin.000001 # Query # # BEGIN
422 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
423 master-bin.000001 # Query # # COMMIT
424 master-bin.000001 # Query # # BEGIN
425 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
426 master-bin.000001 # Xid # # COMMIT /* XID */
427 -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-
428
429 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C';
430 BEGIN;
431 INSERT INTO tt_xx_1() VALUES (1);
432 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
433 Warnings:
434 Note 1051 Unknown table 'test.tt_1'
435 INSERT INTO nt_xx_1() VALUES (1);
436 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1;
437 Warnings:
438 Note 1051 Unknown table 'test.tt_1'
439 COMMIT;
440 -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-
441 include/show_binlog_events.inc
442 Log_name Pos Event_type Server_id End_log_pos Info
443 master-bin.000001 # Query # # BEGIN
444 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
445 master-bin.000001 # Query # # COMMIT
446 master-bin.000001 # Query # # BEGIN
447 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
448 master-bin.000001 # Query # # COMMIT
449 master-bin.000001 # Query # # BEGIN
450 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
451 master-bin.000001 # Query # # COMMIT
452 master-bin.000001 # Query # # BEGIN
453 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
454 master-bin.000001 # Xid # # COMMIT /* XID */
455 -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-
456
457 SET @commands= 'B T Drop-Temp-TN-Temp C';
458 BEGIN;
459 INSERT INTO tt_xx_1() VALUES (1);
460 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
461 COMMIT;
462 -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-
463 include/show_binlog_events.inc
464 Log_name Pos Event_type Server_id End_log_pos Info
465 master-bin.000001 # Query # # BEGIN
466 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
467 master-bin.000001 # Query # # COMMIT
468 master-bin.000001 # Query # # BEGIN
469 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
470 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
471 master-bin.000001 # Xid # # COMMIT /* XID */
472 -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-
473
474 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C';
475 BEGIN;
476 INSERT INTO tt_xx_1() VALUES (1);
477 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
478 INSERT INTO nt_xx_1() VALUES (1);
479 DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1;
480 COMMIT;
481 -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-
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 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
486 master-bin.000001 # Query # # COMMIT
487 master-bin.000001 # Query # # BEGIN
488 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
489 master-bin.000001 # Query # # COMMIT
490 master-bin.000001 # Query # # BEGIN
491 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
492 master-bin.000001 # Query # # COMMIT
493 master-bin.000001 # Query # # BEGIN
494 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
495 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
496 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
497 master-bin.000001 # Xid # # COMMIT /* XID */
498 -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-
499
500 SET @commands= 'B T Drop-Temp-TT-Temp C';
501 BEGIN;
502 INSERT INTO tt_xx_1() VALUES (1);
503 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
504 COMMIT;
505 -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-
506 include/show_binlog_events.inc
507 Log_name Pos Event_type Server_id End_log_pos Info
508 master-bin.000001 # Query # # BEGIN
509 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
510 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
511 master-bin.000001 # Xid # # COMMIT /* XID */
512 -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-
513
514 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C';
515 BEGIN;
516 INSERT INTO tt_xx_1() VALUES (1);
517 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
518 INSERT INTO nt_xx_1() VALUES (1);
519 COMMIT;
520 -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-
521 include/show_binlog_events.inc
522 Log_name Pos Event_type Server_id End_log_pos Info
523 master-bin.000001 # Query # # BEGIN
524 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (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 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
529 master-bin.000001 # Xid # # COMMIT /* XID */
530 -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-
531
532 SET @commands= 'B T Drop-Temp-NN-Temp C';
533 BEGIN;
534 INSERT INTO tt_xx_1() VALUES (1);
535 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
536 COMMIT;
537 -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-
538 include/show_binlog_events.inc
539 Log_name Pos Event_type Server_id End_log_pos Info
540 master-bin.000001 # Query # # BEGIN
541 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
542 master-bin.000001 # Query # # COMMIT
543 master-bin.000001 # Query # # BEGIN
544 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
545 master-bin.000001 # Xid # # COMMIT /* XID */
546 -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-
547
548 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C';
549 BEGIN;
550 INSERT INTO tt_xx_1() VALUES (1);
551 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
552 INSERT INTO nt_xx_1() VALUES (1);
553 COMMIT;
554 -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-
555 include/show_binlog_events.inc
556 Log_name Pos Event_type Server_id End_log_pos Info
557 master-bin.000001 # Query # # BEGIN
558 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
559 master-bin.000001 # Query # # COMMIT
560 master-bin.000001 # Query # # BEGIN
561 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
562 master-bin.000001 # Query # # COMMIT
563 master-bin.000001 # Query # # BEGIN
564 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
565 master-bin.000001 # Xid # # COMMIT /* XID */
566 -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-
567
568 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne C';
569 BEGIN;
570 INSERT INTO tt_xx_1() VALUES (1);
571 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
572 INSERT INTO nt_xx_1() VALUES (1);
573 INSERT INTO nt_error_1() VALUES (1), (1);
574 ERROR 23000: Duplicate entry '1' for key 'nt_error_1.PRIMARY'
575 COMMIT;
576 -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-
577 include/show_binlog_events.inc
578 Log_name Pos Event_type Server_id End_log_pos Info
579 master-bin.000001 # Query # # BEGIN
580 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
581 master-bin.000001 # Query # # COMMIT
582 master-bin.000001 # Query # # BEGIN
583 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
584 master-bin.000001 # Query # # COMMIT
585 master-bin.000001 # Query # # BEGIN
586 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (1), (1)
587 master-bin.000001 # Query # # COMMIT
588 master-bin.000001 # Query # # BEGIN
589 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
590 master-bin.000001 # Xid # # COMMIT /* XID */
591 -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-
592
593 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C';
594 BEGIN;
595 INSERT INTO tt_xx_1() VALUES (1);
596 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
597 INSERT INTO nt_xx_1() VALUES (1);
598 INSERT INTO tt_error_1() VALUES (1), (1);
599 ERROR 23000: Duplicate entry '1' for key 'tt_error_1.PRIMARY'
600 COMMIT;
601 -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-
602 include/show_binlog_events.inc
603 Log_name Pos Event_type Server_id End_log_pos Info
604 master-bin.000001 # Query # # BEGIN
605 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
606 master-bin.000001 # Query # # COMMIT
607 master-bin.000001 # Query # # BEGIN
608 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
609 master-bin.000001 # Query # # COMMIT
610 master-bin.000001 # Query # # BEGIN
611 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
612 master-bin.000001 # Xid # # COMMIT /* XID */
613 -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-
614
615 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C';
616 BEGIN;
617 INSERT INTO tt_xx_1() VALUES (1);
618 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
619 INSERT INTO nt_xx_1() VALUES (1);
620 INSERT INTO nt_error_1() VALUES (2), (2);
621 ERROR 23000: Duplicate entry '2' for key 'nt_error_1.PRIMARY'
622 COMMIT;
623 -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-
624 include/show_binlog_events.inc
625 Log_name Pos Event_type Server_id End_log_pos Info
626 master-bin.000001 # Query # # BEGIN
627 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
628 master-bin.000001 # Query # # COMMIT
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 master-bin.000001 # Query # # BEGIN
633 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (2), (2)
634 master-bin.000001 # Query # # COMMIT
635 master-bin.000001 # Query # # BEGIN
636 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
637 master-bin.000001 # Xid # # COMMIT /* XID */
638 -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-
639
640
641 #
642 #3) Generates in the binlog what follows:
643 #
644 SET @commands= 'B T Drop-Temp-T-Temp R';
645 BEGIN;
646 INSERT INTO tt_xx_1() VALUES (1);
647 DROP TEMPORARY TABLE tt_tmp_2;
648 ROLLBACK;
649 Warnings:
650 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
651 -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-
652 include/show_binlog_events.inc
653 Log_name Pos Event_type Server_id End_log_pos Info
654 master-bin.000001 # Query # # BEGIN
655 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
656 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
657 master-bin.000001 # Query # # ROLLBACK
658 -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-
659
660 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R';
661 BEGIN;
662 INSERT INTO tt_xx_1() VALUES (1);
663 DROP TEMPORARY TABLE tt_tmp_2;
664 INSERT INTO nt_xx_1() VALUES (1);
665 DROP TEMPORARY TABLE tt_tmp_1;
666 ROLLBACK;
667 Warnings:
668 Warning # Some non-transactional changed tables couldn't be rolled back
669 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
670 -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-
671 include/show_binlog_events.inc
672 Log_name Pos Event_type Server_id End_log_pos Info
673 master-bin.000001 # Query # # BEGIN
674 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
675 master-bin.000001 # Query # # COMMIT
676 master-bin.000001 # Query # # BEGIN
677 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
678 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
679 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
680 master-bin.000001 # Query # # ROLLBACK
681 -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-
682
683 SET @commands= 'B T Drop-Temp-N-Temp R';
684 BEGIN;
685 INSERT INTO tt_xx_1() VALUES (1);
686 DROP TEMPORARY TABLE nt_tmp_2;
687 ROLLBACK;
688 Warnings:
689 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
690 -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-
691 include/show_binlog_events.inc
692 Log_name Pos Event_type Server_id End_log_pos Info
693 master-bin.000001 # Query # # BEGIN
694 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
695 master-bin.000001 # Query # # COMMIT
696 -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-
697
698 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R';
699 BEGIN;
700 INSERT INTO tt_xx_1() VALUES (1);
701 DROP TEMPORARY TABLE nt_tmp_2;
702 INSERT INTO nt_xx_1() VALUES (1);
703 DROP TEMPORARY TABLE nt_tmp_1;
704 ROLLBACK;
705 Warnings:
706 Warning # Some non-transactional changed tables couldn't be rolled back
707 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
708 -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-
709 include/show_binlog_events.inc
710 Log_name Pos Event_type Server_id End_log_pos Info
711 master-bin.000001 # Query # # BEGIN
712 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
713 master-bin.000001 # Query # # COMMIT
714 master-bin.000001 # Query # # BEGIN
715 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
716 master-bin.000001 # Query # # COMMIT
717 master-bin.000001 # Query # # BEGIN
718 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
719 master-bin.000001 # Query # # COMMIT
720 -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-
721
722 SET @commands= 'B T Drop-Temp-Xe-Temp R';
723 BEGIN;
724 INSERT INTO tt_xx_1() VALUES (1);
725 DROP TEMPORARY TABLE tt_xx_1;
726 ERROR 42S02: Unknown table 'test.tt_xx_1'
727 ROLLBACK;
728 -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-
729 include/show_binlog_events.inc
730 -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-
731
732 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R';
733 BEGIN;
734 INSERT INTO tt_xx_1() VALUES (1);
735 DROP TEMPORARY TABLE tt_xx_1;
736 ERROR 42S02: Unknown table 'test.tt_xx_1'
737 INSERT INTO nt_xx_1() VALUES (1);
738 DROP TEMPORARY TABLE tt_xx_1;
739 ERROR 42S02: Unknown table 'test.tt_xx_1'
740 ROLLBACK;
741 Warnings:
742 Warning # Some non-transactional changed tables couldn't be rolled back
743 -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-
744 include/show_binlog_events.inc
745 Log_name Pos Event_type Server_id End_log_pos Info
746 master-bin.000001 # Query # # BEGIN
747 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
748 master-bin.000001 # Query # # COMMIT
749 -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-
750
751 SET @commands= 'B T Drop-Temp-If-Xe-Temp R';
752 BEGIN;
753 INSERT INTO tt_xx_1() VALUES (1);
754 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
755 Warnings:
756 Note 1051 Unknown table 'test.tt_xx_1'
757 ROLLBACK;
758 -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-
759 include/show_binlog_events.inc
760 -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-
761
762 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R';
763 BEGIN;
764 INSERT INTO tt_xx_1() VALUES (1);
765 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
766 Warnings:
767 Note 1051 Unknown table 'test.tt_xx_1'
768 INSERT INTO nt_xx_1() VALUES (1);
769 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
770 Warnings:
771 Note 1051 Unknown table 'test.tt_xx_1'
772 ROLLBACK;
773 Warnings:
774 Warning # Some non-transactional changed tables couldn't be rolled back
775 -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-
776 include/show_binlog_events.inc
777 Log_name Pos Event_type Server_id End_log_pos Info
778 master-bin.000001 # Query # # BEGIN
779 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
780 master-bin.000001 # Query # # COMMIT
781 -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-
782
783 SET @commands= 'B T Drop-Temp-TXe-Temp R';
784 BEGIN;
785 INSERT INTO tt_xx_1() VALUES (1);
786 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
787 ERROR 42S02: Unknown table 'test.tt_1'
788 ROLLBACK;
789 -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-
790 include/show_binlog_events.inc
791 -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-
792
793 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R';
794 BEGIN;
795 INSERT INTO tt_xx_1() VALUES (1);
796 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
797 ERROR 42S02: Unknown table 'test.tt_1'
798 INSERT INTO nt_xx_1() VALUES (1);
799 DROP TEMPORARY TABLE tt_tmp_1, tt_1;
800 ERROR 42S02: Unknown table 'test.tt_1'
801 ROLLBACK;
802 Warnings:
803 Warning # Some non-transactional changed tables couldn't be rolled back
804 -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-
805 include/show_binlog_events.inc
806 Log_name Pos Event_type Server_id End_log_pos Info
807 master-bin.000001 # Query # # BEGIN
808 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
809 master-bin.000001 # Query # # COMMIT
810 -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-
811
812 SET @commands= 'B T Drop-Temp-If-TXe-Temp R';
813 BEGIN;
814 INSERT INTO tt_xx_1() VALUES (1);
815 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
816 Warnings:
817 Note 1051 Unknown table 'test.tt_1'
818 ROLLBACK;
819 Warnings:
820 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
821 -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-
822 include/show_binlog_events.inc
823 Log_name Pos Event_type Server_id End_log_pos Info
824 master-bin.000001 # Query # # BEGIN
825 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
826 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
827 master-bin.000001 # Query # # ROLLBACK
828 -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-
829
830 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R';
831 BEGIN;
832 INSERT INTO tt_xx_1() VALUES (1);
833 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
834 Warnings:
835 Note 1051 Unknown table 'test.tt_1'
836 INSERT INTO nt_xx_1() VALUES (1);
837 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1;
838 Warnings:
839 Note 1051 Unknown table 'test.tt_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-If-TXe-Temp N Drop-Temp-If-TXe-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 master-bin.000001 # Query # # BEGIN
851 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
852 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */
853 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */
854 master-bin.000001 # Query # # ROLLBACK
855 -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-
856
857 SET @commands= 'B T Drop-Temp-NXe-Temp R';
858 BEGIN;
859 INSERT INTO tt_xx_1() VALUES (1);
860 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
861 ERROR 42S02: Unknown table 'test.tt_1'
862 ROLLBACK;
863 -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-
864 include/show_binlog_events.inc
865 -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-
866
867 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R';
868 BEGIN;
869 INSERT INTO tt_xx_1() VALUES (1);
870 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
871 ERROR 42S02: Unknown table 'test.tt_1'
872 INSERT INTO nt_xx_1() VALUES (1);
873 DROP TEMPORARY TABLE nt_tmp_1, tt_1;
874 ERROR 42S02: Unknown table 'test.tt_1'
875 ROLLBACK;
876 Warnings:
877 Warning # Some non-transactional changed tables couldn't be rolled back
878 -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-
879 include/show_binlog_events.inc
880 Log_name Pos Event_type Server_id End_log_pos Info
881 master-bin.000001 # Query # # BEGIN
882 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
883 master-bin.000001 # Query # # COMMIT
884 -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-
885
886 SET @commands= 'B T Drop-Temp-If-NXe-Temp R';
887 BEGIN;
888 INSERT INTO tt_xx_1() VALUES (1);
889 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
890 Warnings:
891 Note 1051 Unknown table 'test.tt_1'
892 ROLLBACK;
893 Warnings:
894 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
895 -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-
896 include/show_binlog_events.inc
897 Log_name Pos Event_type Server_id End_log_pos Info
898 master-bin.000001 # Query # # BEGIN
899 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
900 master-bin.000001 # Query # # COMMIT
901 -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-
902
903 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R';
904 BEGIN;
905 INSERT INTO tt_xx_1() VALUES (1);
906 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
907 Warnings:
908 Note 1051 Unknown table 'test.tt_1'
909 INSERT INTO nt_xx_1() VALUES (1);
910 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1;
911 Warnings:
912 Note 1051 Unknown table 'test.tt_1'
913 ROLLBACK;
914 Warnings:
915 Warning # Some non-transactional changed tables couldn't be rolled back
916 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
917 -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-
918 include/show_binlog_events.inc
919 Log_name Pos Event_type Server_id End_log_pos Info
920 master-bin.000001 # Query # # BEGIN
921 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
922 master-bin.000001 # Query # # COMMIT
923 master-bin.000001 # Query # # BEGIN
924 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
925 master-bin.000001 # Query # # COMMIT
926 master-bin.000001 # Query # # BEGIN
927 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
928 master-bin.000001 # Query # # COMMIT
929 -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-
930
931 SET @commands= 'B T Drop-Temp-TN-Temp R';
932 BEGIN;
933 INSERT INTO tt_xx_1() VALUES (1);
934 DROP TEMPORARY TABLE tt_tmp_2, 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-TN-Temp R << -b-b-b-b-b-b-b-b-b-b-b-
939 include/show_binlog_events.inc
940 Log_name Pos Event_type Server_id End_log_pos Info
941 master-bin.000001 # Query # # BEGIN
942 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
943 master-bin.000001 # Query # # COMMIT
944 master-bin.000001 # Query # # BEGIN
945 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
946 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
947 master-bin.000001 # Query # # ROLLBACK
948 -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-
949
950 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R';
951 BEGIN;
952 INSERT INTO tt_xx_1() VALUES (1);
953 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
954 INSERT INTO nt_xx_1() VALUES (1);
955 DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1;
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-TN-Temp N Drop-Temp-TN-Temp 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`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
965 master-bin.000001 # Query # # COMMIT
966 master-bin.000001 # Query # # BEGIN
967 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
968 master-bin.000001 # Query # # COMMIT
969 master-bin.000001 # Query # # BEGIN
970 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
971 master-bin.000001 # Query # # COMMIT
972 master-bin.000001 # Query # # BEGIN
973 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
974 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
975 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
976 master-bin.000001 # Query # # ROLLBACK
977 -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-
978
979 SET @commands= 'B T Drop-Temp-TT-Temp R';
980 BEGIN;
981 INSERT INTO tt_xx_1() VALUES (1);
982 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
983 ROLLBACK;
984 Warnings:
985 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
986 -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-
987 include/show_binlog_events.inc
988 Log_name Pos Event_type Server_id End_log_pos Info
989 master-bin.000001 # Query # # BEGIN
990 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
991 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
992 master-bin.000001 # Query # # ROLLBACK
993 -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-
994
995 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R';
996 BEGIN;
997 INSERT INTO tt_xx_1() VALUES (1);
998 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
999 INSERT INTO nt_xx_1() VALUES (1);
1000 ROLLBACK;
1001 Warnings:
1002 Warning # Some non-transactional changed tables couldn't be rolled back
1003 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1004 -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-
1005 include/show_binlog_events.inc
1006 Log_name Pos Event_type Server_id End_log_pos Info
1007 master-bin.000001 # Query # # BEGIN
1008 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1009 master-bin.000001 # Query # # COMMIT
1010 master-bin.000001 # Query # # BEGIN
1011 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1012 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
1013 master-bin.000001 # Query # # ROLLBACK
1014 -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-
1015
1016 SET @commands= 'B T Drop-Temp-NN-Temp R';
1017 BEGIN;
1018 INSERT INTO tt_xx_1() VALUES (1);
1019 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1020 ROLLBACK;
1021 Warnings:
1022 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1023 -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-
1024 include/show_binlog_events.inc
1025 Log_name Pos Event_type Server_id End_log_pos Info
1026 master-bin.000001 # Query # # BEGIN
1027 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1028 master-bin.000001 # Query # # COMMIT
1029 -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-
1030
1031 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R';
1032 BEGIN;
1033 INSERT INTO tt_xx_1() VALUES (1);
1034 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1035 INSERT INTO nt_xx_1() VALUES (1);
1036 ROLLBACK;
1037 Warnings:
1038 Warning # Some non-transactional changed tables couldn't be rolled back
1039 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1040 -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-
1041 include/show_binlog_events.inc
1042 Log_name Pos Event_type Server_id End_log_pos Info
1043 master-bin.000001 # Query # # BEGIN
1044 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1045 master-bin.000001 # Query # # COMMIT
1046 master-bin.000001 # Query # # BEGIN
1047 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1048 master-bin.000001 # Query # # COMMIT
1049 -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-
1050
1051 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R';
1052 BEGIN;
1053 INSERT INTO tt_xx_1() VALUES (1);
1054 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1055 INSERT INTO nt_xx_1() VALUES (1);
1056 INSERT INTO nt_error_1() VALUES (3), (3);
1057 ERROR 23000: Duplicate entry '3' for key 'nt_error_1.PRIMARY'
1058 ROLLBACK;
1059 Warnings:
1060 Warning # Some non-transactional changed tables couldn't be rolled back
1061 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1062 -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-
1063 include/show_binlog_events.inc
1064 Log_name Pos Event_type Server_id End_log_pos Info
1065 master-bin.000001 # Query # # BEGIN
1066 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1067 master-bin.000001 # Query # # COMMIT
1068 master-bin.000001 # Query # # BEGIN
1069 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1070 master-bin.000001 # Query # # COMMIT
1071 master-bin.000001 # Query # # BEGIN
1072 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (3), (3)
1073 master-bin.000001 # Query # # COMMIT
1074 -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-
1075
1076 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R';
1077 BEGIN;
1078 INSERT INTO tt_xx_1() VALUES (1);
1079 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1080 INSERT INTO nt_xx_1() VALUES (1);
1081 INSERT INTO tt_error_1() VALUES (2), (2);
1082 ERROR 23000: Duplicate entry '2' for key 'tt_error_1.PRIMARY'
1083 ROLLBACK;
1084 Warnings:
1085 Warning # Some non-transactional changed tables couldn't be rolled back
1086 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1087 -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-
1088 include/show_binlog_events.inc
1089 Log_name Pos Event_type Server_id End_log_pos Info
1090 master-bin.000001 # Query # # BEGIN
1091 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1092 master-bin.000001 # Query # # COMMIT
1093 master-bin.000001 # Query # # BEGIN
1094 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1095 master-bin.000001 # Query # # COMMIT
1096 -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-
1097
1098 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R';
1099 BEGIN;
1100 INSERT INTO tt_xx_1() VALUES (1);
1101 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1102 INSERT INTO nt_xx_1() VALUES (1);
1103 INSERT INTO nt_error_1() VALUES (4), (4);
1104 ERROR 23000: Duplicate entry '4' for key 'nt_error_1.PRIMARY'
1105 ROLLBACK;
1106 Warnings:
1107 Warning # Some non-transactional changed tables couldn't be rolled back
1108 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1109 -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-
1110 include/show_binlog_events.inc
1111 Log_name Pos Event_type Server_id End_log_pos Info
1112 master-bin.000001 # Query # # BEGIN
1113 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1114 master-bin.000001 # Query # # COMMIT
1115 master-bin.000001 # Query # # BEGIN
1116 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1117 master-bin.000001 # Query # # COMMIT
1118 master-bin.000001 # Query # # BEGIN
1119 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (4), (4)
1120 master-bin.000001 # Query # # COMMIT
1121 -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-
1122
1123 #########################################################################
1124 # 2 - Tables dropped by "DROP TABLE"
1125 #########################################################################
1126
1127 #
1128 #1) Generates in the binlog what follows:
1129 #
1130 SET @commands= 'Drop-T';
1131 DROP TABLE tt_2;
1132 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-T << -b-b-b-b-b-b-b-b-b-b-b-
1133 include/show_binlog_events.inc
1134 Log_name Pos Event_type Server_id End_log_pos Info
1135 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1136 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-T << -e-e-e-e-e-e-e-e-e-e-e-
1137
1138 SET @commands= 'Drop-N';
1139 DROP TABLE nt_2;
1140 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-N << -b-b-b-b-b-b-b-b-b-b-b-
1141 include/show_binlog_events.inc
1142 Log_name Pos Event_type Server_id End_log_pos Info
1143 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1144 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-N << -e-e-e-e-e-e-e-e-e-e-e-
1145
1146 SET @commands= 'Drop-Xe';
1147 DROP TABLE xx_1;
1148 ERROR 42S02: Unknown table 'test.xx_1'
1149 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Xe << -b-b-b-b-b-b-b-b-b-b-b-
1150 include/show_binlog_events.inc
1151 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Xe << -e-e-e-e-e-e-e-e-e-e-e-
1152
1153 SET @commands= 'Drop-If-Xe';
1154 DROP TABLE IF EXISTS xx_1;
1155 Warnings:
1156 Note 1051 Unknown table 'test.xx_1'
1157 -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-
1158 include/show_binlog_events.inc
1159 Log_name Pos Event_type Server_id End_log_pos Info
1160 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1161 -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-
1162
1163 SET @commands= 'Drop-TXe';
1164 DROP TABLE tt_2, xx_1;
1165 ERROR 42S02: Unknown table 'test.xx_1'
1166 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b-
1167 include/show_binlog_events.inc
1168 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e-
1169
1170 SET @commands= 'Drop-If-TXe';
1171 DROP TABLE IF EXISTS tt_2, xx_1;
1172 Warnings:
1173 Note 1051 Unknown table 'test.xx_1'
1174 -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-
1175 include/show_binlog_events.inc
1176 Log_name Pos Event_type Server_id End_log_pos Info
1177 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */
1178 -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-
1179
1180 SET @commands= 'Drop-NXe';
1181 DROP TABLE nt_2, xx_1;
1182 ERROR 42S02: Unknown table 'test.xx_1'
1183 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-NXe << -b-b-b-b-b-b-b-b-b-b-b-
1184 include/show_binlog_events.inc
1185 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-NXe << -e-e-e-e-e-e-e-e-e-e-e-
1186
1187 SET @commands= 'Drop-If-NXe';
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- >> 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 # # use `test`; DROP TABLE IF EXISTS `nt_2` /* generated by server */
1195 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1196 -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-
1197
1198 SET @commands= 'Drop-TN';
1199 DROP TABLE tt_2, nt_2;
1200 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TN << -b-b-b-b-b-b-b-b-b-b-b-
1201 include/show_binlog_events.inc
1202 Log_name Pos Event_type Server_id End_log_pos Info
1203 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1204 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1205 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TN << -e-e-e-e-e-e-e-e-e-e-e-
1206
1207 SET @commands= 'Drop-TT';
1208 DROP TABLE tt_1, tt_2;
1209 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TT << -b-b-b-b-b-b-b-b-b-b-b-
1210 include/show_binlog_events.inc
1211 Log_name Pos Event_type Server_id End_log_pos Info
1212 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */
1213 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TT << -e-e-e-e-e-e-e-e-e-e-e-
1214
1215 SET @commands= 'Drop-NN';
1216 DROP TABLE nt_1, nt_2;
1217 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-NN << -b-b-b-b-b-b-b-b-b-b-b-
1218 include/show_binlog_events.inc
1219 Log_name Pos Event_type Server_id End_log_pos Info
1220 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1` /* generated by server */
1221 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1222 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-NN << -e-e-e-e-e-e-e-e-e-e-e-
1223
1224 SET @commands= 'Drop-N-TN-Temp';
1225 DROP TABLE tt_tmp_2, nt_tmp_2, nt_2;
1226 -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-
1227 include/show_binlog_events.inc
1228 Log_name Pos Event_type Server_id End_log_pos Info
1229 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1230 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1231 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1232 -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-
1233
1234 SET @commands= 'Drop-TN-Temp';
1235 DROP TABLE tt_tmp_2, nt_tmp_2;
1236 -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-
1237 include/show_binlog_events.inc
1238 Log_name Pos Event_type Server_id End_log_pos Info
1239 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1240 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1241 -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-
1242
1243
1244 #
1245 #2) Generates in the binlog what follows:
1246 #
1247 SET @commands= 'B T Drop-T';
1248 BEGIN;
1249 INSERT INTO tt_xx_1() VALUES (1);
1250 DROP TABLE tt_2;
1251 -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-
1252 include/show_binlog_events.inc
1253 Log_name Pos Event_type Server_id End_log_pos Info
1254 master-bin.000001 # Query # # BEGIN
1255 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1256 master-bin.000001 # Xid # # COMMIT /* XID */
1257 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1258 -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-
1259
1260 SET @commands= 'B T Drop-N';
1261 BEGIN;
1262 INSERT INTO tt_xx_1() VALUES (1);
1263 DROP TABLE nt_2;
1264 -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-
1265 include/show_binlog_events.inc
1266 Log_name Pos Event_type Server_id End_log_pos Info
1267 master-bin.000001 # Query # # BEGIN
1268 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1269 master-bin.000001 # Xid # # COMMIT /* XID */
1270 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1271 -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-
1272
1273 SET @commands= 'B T Drop-Xe';
1274 BEGIN;
1275 INSERT INTO tt_xx_1() VALUES (1);
1276 DROP TABLE xx_1;
1277 ERROR 42S02: Unknown table 'test.xx_1'
1278 -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-
1279 include/show_binlog_events.inc
1280 Log_name Pos Event_type Server_id End_log_pos Info
1281 master-bin.000001 # Query # # BEGIN
1282 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1283 master-bin.000001 # Xid # # COMMIT /* XID */
1284 -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-
1285
1286 SET @commands= 'B T Drop-If-Xe';
1287 BEGIN;
1288 INSERT INTO tt_xx_1() VALUES (1);
1289 DROP TABLE IF EXISTS xx_1;
1290 Warnings:
1291 Note 1051 Unknown table 'test.xx_1'
1292 -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-
1293 include/show_binlog_events.inc
1294 Log_name Pos Event_type Server_id End_log_pos Info
1295 master-bin.000001 # Query # # BEGIN
1296 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1297 master-bin.000001 # Xid # # COMMIT /* XID */
1298 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1299 -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-
1300
1301 SET @commands= 'B T Drop-TXe';
1302 BEGIN;
1303 INSERT INTO tt_xx_1() VALUES (1);
1304 DROP TABLE tt_2, xx_1;
1305 ERROR 42S02: Unknown table 'test.xx_1'
1306 -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-
1307 include/show_binlog_events.inc
1308 Log_name Pos Event_type Server_id End_log_pos Info
1309 master-bin.000001 # Query # # BEGIN
1310 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1311 master-bin.000001 # Xid # # COMMIT /* XID */
1312 -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-
1313
1314 SET @commands= 'B T Drop-If-TXe';
1315 BEGIN;
1316 INSERT INTO tt_xx_1() VALUES (1);
1317 DROP TABLE IF EXISTS tt_2, xx_1;
1318 Warnings:
1319 Note 1051 Unknown table 'test.xx_1'
1320 -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-
1321 include/show_binlog_events.inc
1322 Log_name Pos Event_type Server_id End_log_pos Info
1323 master-bin.000001 # Query # # BEGIN
1324 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1325 master-bin.000001 # Xid # # COMMIT /* XID */
1326 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */
1327 -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-
1328
1329 SET @commands= 'B T Drop-NXe';
1330 BEGIN;
1331 INSERT INTO tt_xx_1() VALUES (1);
1332 DROP TABLE nt_2, xx_1;
1333 ERROR 42S02: Unknown table 'test.xx_1'
1334 -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-
1335 include/show_binlog_events.inc
1336 Log_name Pos Event_type Server_id End_log_pos Info
1337 master-bin.000001 # Query # # BEGIN
1338 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1339 master-bin.000001 # Xid # # COMMIT /* XID */
1340 -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-
1341
1342 SET @commands= 'B T Drop-If-NXe';
1343 BEGIN;
1344 INSERT INTO tt_xx_1() VALUES (1);
1345 DROP TABLE IF EXISTS nt_2, xx_1;
1346 Warnings:
1347 Note 1051 Unknown table 'test.xx_1'
1348 -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-
1349 include/show_binlog_events.inc
1350 Log_name Pos Event_type Server_id End_log_pos Info
1351 master-bin.000001 # Query # # BEGIN
1352 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1353 master-bin.000001 # Xid # # COMMIT /* XID */
1354 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `nt_2` /* generated by server */
1355 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1356 -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-
1357
1358 SET @commands= 'B T Drop-TN';
1359 BEGIN;
1360 INSERT INTO tt_xx_1() VALUES (1);
1361 DROP TABLE tt_2, nt_2;
1362 -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-
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 tt_xx_1() VALUES (1)
1367 master-bin.000001 # Xid # # COMMIT /* XID */
1368 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1369 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1370 -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-
1371
1372 SET @commands= 'B T Drop-TT';
1373 BEGIN;
1374 INSERT INTO tt_xx_1() VALUES (1);
1375 DROP TABLE tt_1, tt_2;
1376 -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-
1377 include/show_binlog_events.inc
1378 Log_name Pos Event_type Server_id End_log_pos Info
1379 master-bin.000001 # Query # # BEGIN
1380 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1381 master-bin.000001 # Xid # # COMMIT /* XID */
1382 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */
1383 -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-
1384
1385 SET @commands= 'B T Drop-NN';
1386 BEGIN;
1387 INSERT INTO tt_xx_1() VALUES (1);
1388 DROP TABLE nt_1, nt_2;
1389 -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-
1390 include/show_binlog_events.inc
1391 Log_name Pos Event_type Server_id End_log_pos Info
1392 master-bin.000001 # Query # # BEGIN
1393 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1394 master-bin.000001 # Xid # # COMMIT /* XID */
1395 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1` /* generated by server */
1396 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1397 -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-
1398
1399 SET @commands= 'B T Drop-N-TN-Temp';
1400 BEGIN;
1401 INSERT INTO tt_xx_1() VALUES (1);
1402 DROP TABLE tt_tmp_2, nt_tmp_2, nt_2;
1403 -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-
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 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1408 master-bin.000001 # Xid # # COMMIT /* XID */
1409 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1410 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1411 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1412 -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-
1413
1414 SET @commands= 'B T Drop-TN-Temp';
1415 BEGIN;
1416 INSERT INTO tt_xx_1() VALUES (1);
1417 DROP TABLE tt_tmp_2, nt_tmp_2;
1418 -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-
1419 include/show_binlog_events.inc
1420 Log_name Pos Event_type Server_id End_log_pos Info
1421 master-bin.000001 # Query # # BEGIN
1422 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1423 master-bin.000001 # Xid # # COMMIT /* XID */
1424 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1425 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1426 -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-
1427
1428 #########################################################################
1429 # 3 - CREATE TEMPORARY TABLE
1430 #########################################################################
1431
1432 #
1433 #1) Generates in the binlog what follows:
1434 #
1435 SET @commands= 'Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp';
1436 DROP TEMPORARY TABLE nt_tmp_2;
1437 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1438 DROP TEMPORARY TABLE nt_tmp_1;
1439 DROP TEMPORARY TABLE nt_tmp_2;
1440 -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-
1441 include/show_binlog_events.inc
1442 Log_name Pos Event_type Server_id End_log_pos Info
1443 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1444 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam
1445 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
1446 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1447 -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-
1448
1449 SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp';
1450 DROP TEMPORARY TABLE tt_tmp_2;
1451 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1452 DROP TEMPORARY TABLE tt_tmp_1;
1453 DROP TEMPORARY TABLE tt_tmp_2;
1454 -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-
1455 include/show_binlog_events.inc
1456 Log_name Pos Event_type Server_id End_log_pos Info
1457 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1458 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1459 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1460 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1461 -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-
1462
1463
1464 #
1465 #2) Generates in the binlog what follows:
1466 #
1467 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C';
1468 BEGIN;
1469 INSERT INTO tt_xx_1() VALUES (1);
1470 DROP TEMPORARY TABLE nt_tmp_2;
1471 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1472 DROP TEMPORARY TABLE nt_tmp_1;
1473 DROP TEMPORARY TABLE nt_tmp_2;
1474 COMMIT;
1475 -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-
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`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1480 master-bin.000001 # Query # # COMMIT
1481 master-bin.000001 # Query # # BEGIN
1482 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam
1483 master-bin.000001 # Query # # COMMIT
1484 master-bin.000001 # Query # # BEGIN
1485 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
1486 master-bin.000001 # Query # # COMMIT
1487 master-bin.000001 # Query # # BEGIN
1488 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1489 master-bin.000001 # Query # # COMMIT
1490 master-bin.000001 # Query # # BEGIN
1491 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1492 master-bin.000001 # Xid # # COMMIT /* XID */
1493 -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-
1494
1495 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C';
1496 BEGIN;
1497 DROP TEMPORARY TABLE tt_tmp_2;
1498 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1499 DROP TEMPORARY TABLE tt_tmp_1;
1500 DROP TEMPORARY TABLE tt_tmp_2;
1501 COMMIT;
1502 -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-
1503 include/show_binlog_events.inc
1504 Log_name Pos Event_type Server_id End_log_pos Info
1505 master-bin.000001 # Query # # BEGIN
1506 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1507 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1508 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1509 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1510 master-bin.000001 # Query # # COMMIT
1511 -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-
1512
1513 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C';
1514 BEGIN;
1515 DROP TEMPORARY TABLE tt_tmp_2;
1516 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1517 DROP TEMPORARY TABLE tt_tmp_1;
1518 DROP TEMPORARY TABLE tt_tmp_2;
1519 INSERT INTO nt_error_1() VALUES (5), (5);
1520 ERROR 23000: Duplicate entry '5' for key 'nt_error_1.PRIMARY'
1521 COMMIT;
1522 -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-
1523 include/show_binlog_events.inc
1524 Log_name Pos Event_type Server_id End_log_pos Info
1525 master-bin.000001 # Query # # BEGIN
1526 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (5), (5)
1527 master-bin.000001 # Query # # COMMIT
1528 master-bin.000001 # Query # # BEGIN
1529 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1530 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1531 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1532 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
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 Ne C << -e-e-e-e-e-e-e-e-e-e-e-
1535
1536 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C';
1537 BEGIN;
1538 DROP TEMPORARY TABLE tt_tmp_2;
1539 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1540 DROP TEMPORARY TABLE tt_tmp_1;
1541 DROP TEMPORARY TABLE tt_tmp_2;
1542 INSERT INTO tt_error_1() VALUES (3), (3);
1543 ERROR 23000: Duplicate entry '3' for key 'tt_error_1.PRIMARY'
1544 COMMIT;
1545 -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-
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`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1550 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1551 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1552 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1553 master-bin.000001 # Query # # COMMIT
1554 -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-
1555
1556 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C';
1557 BEGIN;
1558 DROP TEMPORARY TABLE tt_tmp_2;
1559 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1560 DROP TEMPORARY TABLE tt_tmp_1;
1561 DROP TEMPORARY TABLE tt_tmp_2;
1562 INSERT INTO nt_error_1() VALUES (6), (6);
1563 ERROR 23000: Duplicate entry '6' for key 'nt_error_1.PRIMARY'
1564 COMMIT;
1565 -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-
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_error_1() VALUES (6), (6)
1570 master-bin.000001 # Query # # COMMIT
1571 master-bin.000001 # Query # # BEGIN
1572 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1573 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1574 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1575 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1576 master-bin.000001 # Query # # COMMIT
1577 -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-
1578
1579
1580 #
1581 #3) Generates in the binlog what follows:
1582 #
1583 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R';
1584 BEGIN;
1585 INSERT INTO tt_xx_1() VALUES (1);
1586 DROP TEMPORARY TABLE nt_tmp_2;
1587 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1588 DROP TEMPORARY TABLE nt_tmp_1;
1589 DROP TEMPORARY TABLE nt_tmp_2;
1590 ROLLBACK;
1591 Warnings:
1592 Warning # The creation of some temporary tables could not be rolled back.
1593 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1594 -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-
1595 include/show_binlog_events.inc
1596 Log_name Pos Event_type Server_id End_log_pos Info
1597 master-bin.000001 # Query # # BEGIN
1598 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1599 master-bin.000001 # Query # # COMMIT
1600 master-bin.000001 # Query # # BEGIN
1601 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam
1602 master-bin.000001 # Query # # COMMIT
1603 master-bin.000001 # Query # # BEGIN
1604 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
1605 master-bin.000001 # Query # # COMMIT
1606 master-bin.000001 # Query # # BEGIN
1607 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1608 master-bin.000001 # Query # # COMMIT
1609 -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-
1610
1611 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R';
1612 BEGIN;
1613 DROP TEMPORARY TABLE tt_tmp_2;
1614 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1615 DROP TEMPORARY TABLE tt_tmp_1;
1616 DROP TEMPORARY TABLE tt_tmp_2;
1617 ROLLBACK;
1618 Warnings:
1619 Warning # The creation of some temporary tables could not be rolled back.
1620 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1621 -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-
1622 include/show_binlog_events.inc
1623 Log_name Pos Event_type Server_id End_log_pos Info
1624 master-bin.000001 # Query # # BEGIN
1625 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1626 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1627 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1628 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1629 master-bin.000001 # Query # # ROLLBACK
1630 -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-
1631
1632 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R';
1633 BEGIN;
1634 DROP TEMPORARY TABLE tt_tmp_2;
1635 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1636 DROP TEMPORARY TABLE tt_tmp_1;
1637 DROP TEMPORARY TABLE tt_tmp_2;
1638 INSERT INTO nt_error_1() VALUES (7), (7);
1639 ERROR 23000: Duplicate entry '7' for key 'nt_error_1.PRIMARY'
1640 ROLLBACK;
1641 Warnings:
1642 Warning # Some non-transactional changed tables couldn't be rolled back
1643 Warning # The creation of some temporary tables could not be rolled back.
1644 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1645 -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-
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_error_1() VALUES (7), (7)
1650 master-bin.000001 # Query # # COMMIT
1651 master-bin.000001 # Query # # BEGIN
1652 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1653 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1654 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1655 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1656 master-bin.000001 # Query # # ROLLBACK
1657 -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-
1658
1659 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R';
1660 BEGIN;
1661 DROP TEMPORARY TABLE tt_tmp_2;
1662 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1663 DROP TEMPORARY TABLE tt_tmp_1;
1664 DROP TEMPORARY TABLE tt_tmp_2;
1665 INSERT INTO tt_error_1() VALUES (4), (4);
1666 ERROR 23000: Duplicate entry '4' for key 'tt_error_1.PRIMARY'
1667 ROLLBACK;
1668 Warnings:
1669 Warning # The creation of some temporary tables could not be rolled back.
1670 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1671 -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-
1672 include/show_binlog_events.inc
1673 Log_name Pos Event_type Server_id End_log_pos Info
1674 master-bin.000001 # Query # # BEGIN
1675 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1676 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1677 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1678 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1679 master-bin.000001 # Query # # ROLLBACK
1680 -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-
1681
1682 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R';
1683 BEGIN;
1684 DROP TEMPORARY TABLE tt_tmp_2;
1685 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1686 DROP TEMPORARY TABLE tt_tmp_1;
1687 DROP TEMPORARY TABLE tt_tmp_2;
1688 INSERT INTO nt_error_1() VALUES (8), (8);
1689 ERROR 23000: Duplicate entry '8' for key 'nt_error_1.PRIMARY'
1690 ROLLBACK;
1691 Warnings:
1692 Warning # Some non-transactional changed tables couldn't be rolled back
1693 Warning # The creation of some temporary tables could not be rolled back.
1694 Warning # Some temporary tables were dropped, but these operations could not be rolled back.
1695 -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-
1696 include/show_binlog_events.inc
1697 Log_name Pos Event_type Server_id End_log_pos Info
1698 master-bin.000001 # Query # # BEGIN
1699 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (8), (8)
1700 master-bin.000001 # Query # # COMMIT
1701 master-bin.000001 # Query # # BEGIN
1702 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1703 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1704 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1705 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1706 master-bin.000001 # Query # # ROLLBACK
1707 -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-
1708
1709 #########################################################################
1710 # 4 - CHANGING TEMPORARY TABLES
1711 #########################################################################
1712
1713 #
1714 #1) Generates in the binlog what follows:
1715 #
1716 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp C';
1717 BEGIN;
1718 INSERT INTO nt_xx_1() VALUES (1);
1719 INSERT INTO nt_tmp_xx_1() VALUES (1);
1720 INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1;
1721 INSERT INTO nt_tmp_xx_1() VALUES (1);
1722 COMMIT;
1723 -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-
1724 include/show_binlog_events.inc
1725 Log_name Pos Event_type Server_id End_log_pos Info
1726 master-bin.000001 # Query # # BEGIN
1727 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1728 master-bin.000001 # Query # # COMMIT
1729 master-bin.000001 # Query # # BEGIN
1730 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1731 master-bin.000001 # Query # # COMMIT
1732 master-bin.000001 # Query # # BEGIN
1733 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1
1734 master-bin.000001 # Query # # COMMIT
1735 master-bin.000001 # Query # # BEGIN
1736 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1737 master-bin.000001 # Query # # COMMIT
1738 -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-
1739
1740 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp C';
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 nt_tmp_xx_1;
1745 Warnings:
1746 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
1747 INSERT INTO nt_tmp_xx_1() VALUES (1);
1748 COMMIT;
1749 -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-
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 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1754 master-bin.000001 # Query # # COMMIT
1755 master-bin.000001 # Query # # BEGIN
1756 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1757 master-bin.000001 # Query # # COMMIT
1758 master-bin.000001 # Query # # BEGIN
1759 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1760 master-bin.000001 # Query # # COMMIT
1761 master-bin.000001 # Query # # BEGIN
1762 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1
1763 master-bin.000001 # Xid # # COMMIT /* XID */
1764 -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-
1765
1766 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp C';
1767 BEGIN;
1768 INSERT INTO nt_xx_1() VALUES (1);
1769 INSERT INTO nt_tmp_xx_1() VALUES (1);
1770 INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1;
1771 INSERT INTO nt_tmp_xx_1() VALUES (1);
1772 COMMIT;
1773 -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-
1774 include/show_binlog_events.inc
1775 Log_name Pos Event_type Server_id End_log_pos Info
1776 master-bin.000001 # Query # # BEGIN
1777 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1778 master-bin.000001 # Query # # COMMIT
1779 master-bin.000001 # Query # # BEGIN
1780 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1781 master-bin.000001 # Query # # COMMIT
1782 master-bin.000001 # Query # # BEGIN
1783 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1
1784 master-bin.000001 # Query # # COMMIT
1785 master-bin.000001 # Query # # BEGIN
1786 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1787 master-bin.000001 # Query # # COMMIT
1788 -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-
1789
1790 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp C';
1791 BEGIN;
1792 INSERT INTO nt_xx_1() VALUES (1);
1793 INSERT INTO nt_tmp_xx_1() VALUES (1);
1794 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1795 INSERT INTO nt_tmp_xx_1() VALUES (1);
1796 COMMIT;
1797 -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-
1798 include/show_binlog_events.inc
1799 Log_name Pos Event_type Server_id End_log_pos Info
1800 master-bin.000001 # Query # # BEGIN
1801 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1802 master-bin.000001 # Query # # COMMIT
1803 master-bin.000001 # Query # # BEGIN
1804 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1805 master-bin.000001 # Query # # COMMIT
1806 master-bin.000001 # Query # # BEGIN
1807 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1808 master-bin.000001 # Query # # COMMIT
1809 master-bin.000001 # Query # # BEGIN
1810 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1
1811 master-bin.000001 # Query # # COMMIT
1812 -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-
1813
1814 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne C';
1815 BEGIN;
1816 INSERT INTO nt_xx_1() VALUES (1);
1817 INSERT INTO nt_tmp_xx_1() VALUES (1);
1818 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1819 INSERT INTO nt_tmp_xx_1() VALUES (1);
1820 INSERT INTO nt_error_1() VALUES (9), (9);
1821 ERROR 23000: Duplicate entry '9' for key 'nt_error_1.PRIMARY'
1822 COMMIT;
1823 -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-
1824 include/show_binlog_events.inc
1825 Log_name Pos Event_type Server_id End_log_pos Info
1826 master-bin.000001 # Query # # BEGIN
1827 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1828 master-bin.000001 # Query # # COMMIT
1829 master-bin.000001 # Query # # BEGIN
1830 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1831 master-bin.000001 # Query # # COMMIT
1832 master-bin.000001 # Query # # BEGIN
1833 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1834 master-bin.000001 # Query # # COMMIT
1835 master-bin.000001 # Query # # BEGIN
1836 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (9), (9)
1837 master-bin.000001 # Query # # COMMIT
1838 master-bin.000001 # Query # # BEGIN
1839 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1
1840 master-bin.000001 # Query # # COMMIT
1841 -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-
1842
1843 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te C';
1844 BEGIN;
1845 INSERT INTO nt_xx_1() VALUES (1);
1846 INSERT INTO nt_tmp_xx_1() VALUES (1);
1847 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1848 INSERT INTO nt_tmp_xx_1() VALUES (1);
1849 INSERT INTO tt_error_1() VALUES (5), (5);
1850 ERROR 23000: Duplicate entry '5' for key 'tt_error_1.PRIMARY'
1851 COMMIT;
1852 -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-
1853 include/show_binlog_events.inc
1854 Log_name Pos Event_type Server_id End_log_pos Info
1855 master-bin.000001 # Query # # BEGIN
1856 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1857 master-bin.000001 # Query # # COMMIT
1858 master-bin.000001 # Query # # BEGIN
1859 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1860 master-bin.000001 # Query # # COMMIT
1861 master-bin.000001 # Query # # BEGIN
1862 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1863 master-bin.000001 # Query # # COMMIT
1864 master-bin.000001 # Query # # BEGIN
1865 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1
1866 master-bin.000001 # Query # # COMMIT
1867 -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-
1868
1869 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C';
1870 BEGIN;
1871 INSERT INTO nt_xx_1() VALUES (1);
1872 INSERT INTO nt_tmp_xx_1() VALUES (1);
1873 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1874 INSERT INTO nt_tmp_xx_1() VALUES (1);
1875 INSERT INTO nt_error_1() VALUES (10), (10);
1876 ERROR 23000: Duplicate entry '10' for key 'nt_error_1.PRIMARY'
1877 COMMIT;
1878 -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-
1879 include/show_binlog_events.inc
1880 Log_name Pos Event_type Server_id End_log_pos Info
1881 master-bin.000001 # Query # # BEGIN
1882 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1883 master-bin.000001 # Query # # COMMIT
1884 master-bin.000001 # Query # # BEGIN
1885 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1886 master-bin.000001 # Query # # COMMIT
1887 master-bin.000001 # Query # # BEGIN
1888 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1889 master-bin.000001 # Query # # COMMIT
1890 master-bin.000001 # Query # # BEGIN
1891 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (10), (10)
1892 master-bin.000001 # Query # # COMMIT
1893 master-bin.000001 # Query # # BEGIN
1894 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1
1895 master-bin.000001 # Query # # COMMIT
1896 -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-
1897
1898
1899
1900 #
1901 #2) Generates in the binlog what follows:
1902 #
1903 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp R';
1904 BEGIN;
1905 INSERT INTO nt_xx_1() VALUES (1);
1906 INSERT INTO nt_tmp_xx_1() VALUES (1);
1907 INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1;
1908 INSERT INTO nt_tmp_xx_1() VALUES (1);
1909 ROLLBACK;
1910 Warnings:
1911 Warning # Some non-transactional changed tables couldn't be rolled back
1912 -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-
1913 include/show_binlog_events.inc
1914 Log_name Pos Event_type Server_id End_log_pos Info
1915 master-bin.000001 # Query # # BEGIN
1916 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1917 master-bin.000001 # Query # # COMMIT
1918 master-bin.000001 # Query # # BEGIN
1919 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1920 master-bin.000001 # Query # # COMMIT
1921 master-bin.000001 # Query # # BEGIN
1922 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1
1923 master-bin.000001 # Query # # COMMIT
1924 master-bin.000001 # Query # # BEGIN
1925 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1926 master-bin.000001 # Query # # COMMIT
1927 -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-
1928
1929 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp R';
1930 BEGIN;
1931 INSERT INTO nt_xx_1() VALUES (1);
1932 INSERT INTO nt_tmp_xx_1() VALUES (1);
1933 INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1;
1934 Warnings:
1935 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.
1936 INSERT INTO nt_tmp_xx_1() VALUES (1);
1937 ROLLBACK;
1938 Warnings:
1939 Warning # Some non-transactional changed tables couldn't be rolled back
1940 -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-
1941 include/show_binlog_events.inc
1942 Log_name Pos Event_type Server_id End_log_pos Info
1943 master-bin.000001 # Query # # BEGIN
1944 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1945 master-bin.000001 # Query # # COMMIT
1946 master-bin.000001 # Query # # BEGIN
1947 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1948 master-bin.000001 # Query # # COMMIT
1949 master-bin.000001 # Query # # BEGIN
1950 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1951 master-bin.000001 # Query # # COMMIT
1952 -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-
1953
1954 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp R';
1955 BEGIN;
1956 INSERT INTO nt_xx_1() VALUES (1);
1957 INSERT INTO nt_tmp_xx_1() VALUES (1);
1958 INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1;
1959 INSERT INTO nt_tmp_xx_1() VALUES (1);
1960 ROLLBACK;
1961 Warnings:
1962 Warning # Some non-transactional changed tables couldn't be rolled back
1963 -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-
1964 include/show_binlog_events.inc
1965 Log_name Pos Event_type Server_id End_log_pos Info
1966 master-bin.000001 # Query # # BEGIN
1967 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1968 master-bin.000001 # Query # # COMMIT
1969 master-bin.000001 # Query # # BEGIN
1970 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1971 master-bin.000001 # Query # # COMMIT
1972 master-bin.000001 # Query # # BEGIN
1973 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1
1974 master-bin.000001 # Query # # COMMIT
1975 master-bin.000001 # Query # # BEGIN
1976 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1977 master-bin.000001 # Query # # COMMIT
1978 -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-
1979
1980 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp R';
1981 BEGIN;
1982 INSERT INTO nt_xx_1() VALUES (1);
1983 INSERT INTO nt_tmp_xx_1() VALUES (1);
1984 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1985 INSERT INTO nt_tmp_xx_1() VALUES (1);
1986 ROLLBACK;
1987 Warnings:
1988 Warning # Some non-transactional changed tables couldn't be rolled back
1989 -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-
1990 include/show_binlog_events.inc
1991 Log_name Pos Event_type Server_id End_log_pos Info
1992 master-bin.000001 # Query # # BEGIN
1993 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1994 master-bin.000001 # Query # # COMMIT
1995 master-bin.000001 # Query # # BEGIN
1996 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1997 master-bin.000001 # Query # # COMMIT
1998 master-bin.000001 # Query # # BEGIN
1999 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
2000 master-bin.000001 # Query # # COMMIT
2001 -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-
2002
2003 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne R';
2004 BEGIN;
2005 INSERT INTO nt_xx_1() VALUES (1);
2006 INSERT INTO nt_tmp_xx_1() VALUES (1);
2007 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
2008 INSERT INTO nt_tmp_xx_1() VALUES (1);
2009 INSERT INTO nt_error_1() VALUES (11), (11);
2010 ERROR 23000: Duplicate entry '11' for key 'nt_error_1.PRIMARY'
2011 ROLLBACK;
2012 Warnings:
2013 Warning # Some non-transactional changed tables couldn't be rolled back
2014 -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-
2015 include/show_binlog_events.inc
2016 Log_name Pos Event_type Server_id End_log_pos Info
2017 master-bin.000001 # Query # # BEGIN
2018 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
2019 master-bin.000001 # Query # # COMMIT
2020 master-bin.000001 # Query # # BEGIN
2021 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
2022 master-bin.000001 # Query # # COMMIT
2023 master-bin.000001 # Query # # BEGIN
2024 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
2025 master-bin.000001 # Query # # COMMIT
2026 master-bin.000001 # Query # # BEGIN
2027 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (11), (11)
2028 master-bin.000001 # Query # # COMMIT
2029 -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-
2030
2031 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te R';
2032 BEGIN;
2033 INSERT INTO nt_xx_1() VALUES (1);
2034 INSERT INTO nt_tmp_xx_1() VALUES (1);
2035 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
2036 INSERT INTO nt_tmp_xx_1() VALUES (1);
2037 INSERT INTO tt_error_1() VALUES (6), (6);
2038 ERROR 23000: Duplicate entry '6' for key 'tt_error_1.PRIMARY'
2039 ROLLBACK;
2040 Warnings:
2041 Warning # Some non-transactional changed tables couldn't be rolled back
2042 -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-
2043 include/show_binlog_events.inc
2044 Log_name Pos Event_type Server_id End_log_pos Info
2045 master-bin.000001 # Query # # BEGIN
2046 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
2047 master-bin.000001 # Query # # COMMIT
2048 master-bin.000001 # Query # # BEGIN
2049 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
2050 master-bin.000001 # Query # # COMMIT
2051 master-bin.000001 # Query # # BEGIN
2052 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
2053 master-bin.000001 # Query # # COMMIT
2054 -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-
2055
2056 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R';
2057 BEGIN;
2058 INSERT INTO nt_xx_1() VALUES (1);
2059 INSERT INTO nt_tmp_xx_1() VALUES (1);
2060 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
2061 INSERT INTO nt_tmp_xx_1() VALUES (1);
2062 INSERT INTO nt_error_1() VALUES (12), (12);
2063 ERROR 23000: Duplicate entry '12' for key 'nt_error_1.PRIMARY'
2064 ROLLBACK;
2065 Warnings:
2066 Warning # Some non-transactional changed tables couldn't be rolled back
2067 -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-
2068 include/show_binlog_events.inc
2069 Log_name Pos Event_type Server_id End_log_pos Info
2070 master-bin.000001 # Query # # BEGIN
2071 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
2072 master-bin.000001 # Query # # COMMIT
2073 master-bin.000001 # Query # # BEGIN
2074 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
2075 master-bin.000001 # Query # # COMMIT
2076 master-bin.000001 # Query # # BEGIN
2077 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
2078 master-bin.000001 # Query # # COMMIT
2079 master-bin.000001 # Query # # BEGIN
2080 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (12), (12)
2081 master-bin.000001 # Query # # COMMIT
2082 -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-
2083
2084 ###################################################################################
2085 # CHECK CONSISTENCY
2086 ###################################################################################
2087 #########################################################################
2088 # CLEAN
2089 #########################################################################
2090 SET @commands= 'clean';
2091 DROP TABLE IF EXISTS tt_xx_1;
2092 DROP TABLE IF EXISTS nt_xx_1;
2093 DROP TABLE IF EXISTS tt_error_1;
2094 DROP TABLE IF EXISTS nt_error_1;
2095 DROP TABLE IF EXISTS tt_error_2;
2096 DROP TABLE IF EXISTS nt_error_2;
2097 DROP TEMPORARY TABLE IF EXISTS tt_tmp_xx_1;
2098 DROP TEMPORARY TABLE IF EXISTS nt_tmp_xx_1;
2099 DROP TABLE IF EXISTS nt_2;
2100 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2;
2101 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2;
2102 DROP TABLE IF EXISTS nt_1;
2103 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1;
2104 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1;
2105 DROP TABLE IF EXISTS tt_2;
2106 DROP TABLE IF EXISTS tt_1;
2107 SET @commands= '';
2108 include/rpl_end.inc