Debian Codegraph @

mysql-test/suite/rpl/r/rpl_mixed_drop_create_temp_table.result

raw
1 include/master-slave.inc
2 [connection master]
3 #########################################################################
4 # CONFIGURATION
5 #########################################################################
6 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.");
7 SET @commands= 'configure';
8 connection master;
9 CREATE TABLE tt_xx_1 ( id INT ) ENGINE = Innodb;
10 CREATE TABLE nt_xx_1 ( id INT ) ENGINE = MyIsam;
11 CREATE TABLE tt_error_1 ( id INT, PRIMARY KEY (id) ) ENGINE = Innodb;
12 CREATE TABLE nt_error_1 ( id INT, PRIMARY KEY (id) ) ENGINE = MyIsam;
13 CREATE TABLE tt_error_2 ( id INT, PRIMARY KEY (id) ) ENGINE = Innodb;
14 CREATE TABLE nt_error_2 ( id INT, PRIMARY KEY (id) ) ENGINE = MyIsam;
15 CREATE TRIGGER tr_i_nt_2_to_tt_2 AFTER INSERT ON nt_error_2 FOR EACH ROW
16 BEGIN
17 DECLARE in_stmt_id INTEGER;
18 INSERT INTO tt_error_2(id) VALUES (NEW.id);
19 END|
20 CREATE TEMPORARY TABLE nt_tmp_xx_1 ( id INT ) ENGINE = MyIsam;
21 CREATE TEMPORARY TABLE tt_tmp_xx_1 ( id INT ) ENGINE = Innodb;
22 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2;
23 Warnings:
24 Note 1051 Unknown table 'test.nt_tmp_2'
25 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) ENGINE = MyIsam;
26 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1;
27 Warnings:
28 Note 1051 Unknown table 'test.nt_tmp_1'
29 CREATE TEMPORARY TABLE nt_tmp_1 ( id INT ) ENGINE = MyIsam;
30 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2;
31 Warnings:
32 Note 1051 Unknown table 'test.tt_tmp_2'
33 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) ENGINE = Innodb;
34 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1;
35 Warnings:
36 Note 1051 Unknown table 'test.tt_tmp_1'
37 CREATE TEMPORARY TABLE tt_tmp_1 ( id INT ) ENGINE = Innodb;
38 DROP TABLE IF EXISTS nt_2;
39 Warnings:
40 Note 1051 Unknown table 'test.nt_2'
41 CREATE TABLE nt_2 ( id INT ) ENGINE = MyIsam;
42 DROP TABLE IF EXISTS nt_1;
43 Warnings:
44 Note 1051 Unknown table 'test.nt_1'
45 CREATE TABLE nt_1 ( id INT ) ENGINE = MyIsam;
46 DROP TABLE IF EXISTS tt_2;
47 Warnings:
48 Note 1051 Unknown table 'test.tt_2'
49 CREATE TABLE tt_2 ( id INT ) ENGINE = Innodb;
50 DROP TABLE IF EXISTS tt_1;
51 Warnings:
52 Note 1051 Unknown table 'test.tt_1'
53 CREATE TABLE tt_1 ( id INT ) ENGINE = Innodb;
54 SET @commands= '';
55 #########################################################################
56 # 1 - Tables dropped by "DROP TEMPORARY TABLE"
57 #########################################################################
58 connection master;
59
60 #
61 #1) Generates in the binlog what follows:
62 #
63 SET @commands= 'Drop-Temp-T-Temp';
64 DROP TEMPORARY TABLE tt_tmp_2;
65 -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
66 include/show_binlog_events.inc
67 Log_name Pos Event_type Server_id End_log_pos Info
68 master-bin.000001 # Gtid # # GTID #-#-#
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 # Gtid # # GTID #-#-#
78 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
79 -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-
80
81 SET @commands= 'Drop-Temp-Xe-Temp';
82 DROP TEMPORARY TABLE tt_xx_1;
83 ERROR 42S02: Unknown table 'test.tt_xx_1'
84 -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-
85 include/show_binlog_events.inc
86 -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-
87
88 SET @commands= 'Drop-Temp-If-Xe-Temp';
89 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
90 Warnings:
91 Note 1051 Unknown table 'test.tt_xx_1'
92 -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-
93 include/show_binlog_events.inc
94 -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-
95
96 SET @commands= 'Drop-Temp-TXe-Temp';
97 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
98 ERROR 42S02: Unknown table 'test.tt_1'
99 -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-
100 include/show_binlog_events.inc
101 Log_name Pos Event_type Server_id End_log_pos Info
102 master-bin.000001 # Gtid # # GTID #-#-#
103 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
104 -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-
105
106 SET @commands= 'Drop-Temp-If-TXe-Temp';
107 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
108 Warnings:
109 Note 1051 Unknown table 'test.tt_1'
110 -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-
111 include/show_binlog_events.inc
112 Log_name Pos Event_type Server_id End_log_pos Info
113 master-bin.000001 # Gtid # # GTID #-#-#
114 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
115 -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-
116
117 SET @commands= 'Drop-Temp-NXe-Temp';
118 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
119 ERROR 42S02: Unknown table 'test.tt_1'
120 -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-
121 include/show_binlog_events.inc
122 Log_name Pos Event_type Server_id End_log_pos Info
123 master-bin.000001 # Gtid # # GTID #-#-#
124 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
125 -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-
126
127 SET @commands= 'Drop-Temp-If-NXe-Temp';
128 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
129 Warnings:
130 Note 1051 Unknown table 'test.tt_1'
131 -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-
132 include/show_binlog_events.inc
133 Log_name Pos Event_type Server_id End_log_pos Info
134 master-bin.000001 # Gtid # # GTID #-#-#
135 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
136 -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-
137
138 SET @commands= 'Drop-Temp-TN-Temp';
139 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
140 -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-
141 include/show_binlog_events.inc
142 Log_name Pos Event_type Server_id End_log_pos Info
143 master-bin.000001 # Gtid # # GTID #-#-#
144 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
145 master-bin.000001 # Gtid # # GTID #-#-#
146 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
147 -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-
148
149 SET @commands= 'Drop-Temp-TT-Temp';
150 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
151 -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-
152 include/show_binlog_events.inc
153 Log_name Pos Event_type Server_id End_log_pos Info
154 master-bin.000001 # Gtid # # GTID #-#-#
155 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
156 -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-
157
158 SET @commands= 'Drop-Temp-NN-Temp';
159 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
160 -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-
161 include/show_binlog_events.inc
162 Log_name Pos Event_type Server_id End_log_pos Info
163 master-bin.000001 # Gtid # # GTID #-#-#
164 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
165 -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-
166
167
168 #
169 #2) Generates in the binlog what follows:
170 #
171 SET @commands= 'B T Drop-Temp-T-Temp C';
172 BEGIN;
173 INSERT INTO tt_xx_1() VALUES (1);
174 DROP TEMPORARY TABLE tt_tmp_2;
175 COMMIT;
176 -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-
177 include/show_binlog_events.inc
178 Log_name Pos Event_type Server_id End_log_pos Info
179 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
180 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
181 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
182 master-bin.000001 # Xid # # COMMIT /* XID */
183 -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-
184
185 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp C';
186 BEGIN;
187 INSERT INTO tt_xx_1() VALUES (1);
188 DROP TEMPORARY TABLE tt_tmp_2;
189 INSERT INTO nt_xx_1() VALUES (1);
190 DROP TEMPORARY TABLE tt_tmp_1;
191 COMMIT;
192 -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-
193 include/show_binlog_events.inc
194 Log_name Pos Event_type Server_id End_log_pos Info
195 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
196 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
197 master-bin.000001 # Query # # COMMIT
198 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
199 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
200 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
201 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
202 master-bin.000001 # Xid # # COMMIT /* XID */
203 -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-
204
205 SET @commands= 'B T Drop-Temp-N-Temp C';
206 BEGIN;
207 INSERT INTO tt_xx_1() VALUES (1);
208 DROP TEMPORARY TABLE nt_tmp_2;
209 COMMIT;
210 -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-
211 include/show_binlog_events.inc
212 Log_name Pos Event_type Server_id End_log_pos Info
213 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
214 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
215 master-bin.000001 # Query # # COMMIT
216 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
217 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
218 master-bin.000001 # Xid # # COMMIT /* XID */
219 -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-
220
221 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp C';
222 BEGIN;
223 INSERT INTO tt_xx_1() VALUES (1);
224 DROP TEMPORARY TABLE nt_tmp_2;
225 INSERT INTO nt_xx_1() VALUES (1);
226 DROP TEMPORARY TABLE nt_tmp_1;
227 COMMIT;
228 -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-
229 include/show_binlog_events.inc
230 Log_name Pos Event_type Server_id End_log_pos Info
231 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
232 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
233 master-bin.000001 # Query # # COMMIT
234 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
235 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
236 master-bin.000001 # Query # # COMMIT
237 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
238 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
239 master-bin.000001 # Query # # COMMIT
240 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
241 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
242 master-bin.000001 # Xid # # COMMIT /* XID */
243 -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-
244
245 SET @commands= 'B T Drop-Temp-Xe-Temp C';
246 BEGIN;
247 INSERT INTO tt_xx_1() VALUES (1);
248 DROP TEMPORARY TABLE tt_xx_1;
249 ERROR 42S02: Unknown table 'test.tt_xx_1'
250 COMMIT;
251 -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-
252 include/show_binlog_events.inc
253 Log_name Pos Event_type Server_id End_log_pos Info
254 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
255 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
256 master-bin.000001 # Xid # # COMMIT /* XID */
257 -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-
258
259 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp C';
260 BEGIN;
261 INSERT INTO tt_xx_1() VALUES (1);
262 DROP TEMPORARY TABLE tt_xx_1;
263 ERROR 42S02: Unknown table 'test.tt_xx_1'
264 INSERT INTO nt_xx_1() VALUES (1);
265 DROP TEMPORARY TABLE tt_xx_1;
266 ERROR 42S02: Unknown table 'test.tt_xx_1'
267 COMMIT;
268 -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-
269 include/show_binlog_events.inc
270 Log_name Pos Event_type Server_id End_log_pos Info
271 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
272 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
273 master-bin.000001 # Query # # COMMIT
274 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
275 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
276 master-bin.000001 # Xid # # COMMIT /* XID */
277 -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-
278
279 SET @commands= 'B T Drop-Temp-If-Xe-Temp C';
280 BEGIN;
281 INSERT INTO tt_xx_1() VALUES (1);
282 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
283 Warnings:
284 Note 1051 Unknown table 'test.tt_xx_1'
285 COMMIT;
286 -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-
287 include/show_binlog_events.inc
288 Log_name Pos Event_type Server_id End_log_pos Info
289 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
290 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
291 master-bin.000001 # Xid # # COMMIT /* XID */
292 -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-
293
294 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp C';
295 BEGIN;
296 INSERT INTO tt_xx_1() VALUES (1);
297 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
298 Warnings:
299 Note 1051 Unknown table 'test.tt_xx_1'
300 INSERT INTO nt_xx_1() VALUES (1);
301 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
302 Warnings:
303 Note 1051 Unknown table 'test.tt_xx_1'
304 COMMIT;
305 -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-
306 include/show_binlog_events.inc
307 Log_name Pos Event_type Server_id End_log_pos Info
308 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
309 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
310 master-bin.000001 # Query # # COMMIT
311 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
312 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
313 master-bin.000001 # Xid # # COMMIT /* XID */
314 -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-
315
316 SET @commands= 'B T Drop-Temp-TXe-Temp C';
317 BEGIN;
318 INSERT INTO tt_xx_1() VALUES (1);
319 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
320 ERROR 42S02: Unknown table 'test.tt_1'
321 COMMIT;
322 -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-
323 include/show_binlog_events.inc
324 Log_name Pos Event_type Server_id End_log_pos Info
325 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
326 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
327 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
328 master-bin.000001 # Xid # # COMMIT /* XID */
329 -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-
330
331 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp C';
332 BEGIN;
333 INSERT INTO tt_xx_1() VALUES (1);
334 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
335 ERROR 42S02: Unknown table 'test.tt_1'
336 INSERT INTO nt_xx_1() VALUES (1);
337 DROP TEMPORARY TABLE tt_tmp_1, tt_1;
338 ERROR 42S02: Unknown table 'test.tt_1'
339 COMMIT;
340 -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-
341 include/show_binlog_events.inc
342 Log_name Pos Event_type Server_id End_log_pos Info
343 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
344 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
345 master-bin.000001 # Query # # COMMIT
346 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
347 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
348 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
349 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* 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-TXe-Temp N Drop-Temp-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 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 COMMIT;
360 -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-
361 include/show_binlog_events.inc
362 Log_name Pos Event_type Server_id End_log_pos Info
363 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
364 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
365 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
366 master-bin.000001 # Xid # # COMMIT /* XID */
367 -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-
368
369 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp C';
370 BEGIN;
371 INSERT INTO tt_xx_1() VALUES (1);
372 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
373 Warnings:
374 Note 1051 Unknown table 'test.tt_1'
375 INSERT INTO nt_xx_1() VALUES (1);
376 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1;
377 Warnings:
378 Note 1051 Unknown table 'test.tt_1'
379 COMMIT;
380 -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-
381 include/show_binlog_events.inc
382 Log_name Pos Event_type Server_id End_log_pos Info
383 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
384 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
385 master-bin.000001 # Query # # COMMIT
386 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
387 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
388 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
389 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
390 master-bin.000001 # Xid # # COMMIT /* XID */
391 -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-
392
393 SET @commands= 'B T Drop-Temp-NXe-Temp C';
394 BEGIN;
395 INSERT INTO tt_xx_1() VALUES (1);
396 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
397 ERROR 42S02: Unknown table 'test.tt_1'
398 COMMIT;
399 -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-
400 include/show_binlog_events.inc
401 Log_name Pos Event_type Server_id End_log_pos Info
402 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
403 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
404 master-bin.000001 # Query # # COMMIT
405 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
406 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
407 master-bin.000001 # Xid # # COMMIT /* XID */
408 -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-
409
410 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp C';
411 BEGIN;
412 INSERT INTO tt_xx_1() VALUES (1);
413 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
414 ERROR 42S02: Unknown table 'test.tt_1'
415 INSERT INTO nt_xx_1() VALUES (1);
416 DROP TEMPORARY TABLE nt_tmp_1, tt_1;
417 ERROR 42S02: Unknown table 'test.tt_1'
418 COMMIT;
419 -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-
420 include/show_binlog_events.inc
421 Log_name Pos Event_type Server_id End_log_pos Info
422 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
423 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
424 master-bin.000001 # Query # # COMMIT
425 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
426 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
427 master-bin.000001 # Query # # COMMIT
428 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
429 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
430 master-bin.000001 # Query # # COMMIT
431 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
432 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
433 master-bin.000001 # Xid # # COMMIT /* XID */
434 -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-
435
436 SET @commands= 'B T Drop-Temp-If-NXe-Temp C';
437 BEGIN;
438 INSERT INTO tt_xx_1() VALUES (1);
439 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
440 Warnings:
441 Note 1051 Unknown table 'test.tt_1'
442 COMMIT;
443 -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-
444 include/show_binlog_events.inc
445 Log_name Pos Event_type Server_id End_log_pos Info
446 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
447 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
448 master-bin.000001 # Query # # COMMIT
449 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
450 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
451 master-bin.000001 # Xid # # COMMIT /* XID */
452 -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-
453
454 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp C';
455 BEGIN;
456 INSERT INTO tt_xx_1() VALUES (1);
457 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
458 Warnings:
459 Note 1051 Unknown table 'test.tt_1'
460 INSERT INTO nt_xx_1() VALUES (1);
461 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1;
462 Warnings:
463 Note 1051 Unknown table 'test.tt_1'
464 COMMIT;
465 -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-
466 include/show_binlog_events.inc
467 Log_name Pos Event_type Server_id End_log_pos Info
468 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
469 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
470 master-bin.000001 # Query # # COMMIT
471 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
472 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
473 master-bin.000001 # Query # # COMMIT
474 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
475 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
476 master-bin.000001 # Query # # COMMIT
477 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
478 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
479 master-bin.000001 # Xid # # COMMIT /* XID */
480 -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-
481
482 SET @commands= 'B T Drop-Temp-TN-Temp C';
483 BEGIN;
484 INSERT INTO tt_xx_1() VALUES (1);
485 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
486 COMMIT;
487 -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-
488 include/show_binlog_events.inc
489 Log_name Pos Event_type Server_id End_log_pos Info
490 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
491 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
492 master-bin.000001 # Query # # COMMIT
493 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
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 # Xid # # COMMIT /* XID */
497 -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-
498
499 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp C';
500 BEGIN;
501 INSERT INTO tt_xx_1() VALUES (1);
502 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
503 INSERT INTO nt_xx_1() VALUES (1);
504 DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1;
505 COMMIT;
506 -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-
507 include/show_binlog_events.inc
508 Log_name Pos Event_type Server_id End_log_pos Info
509 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
510 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
511 master-bin.000001 # Query # # COMMIT
512 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
513 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
514 master-bin.000001 # Query # # COMMIT
515 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
516 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
517 master-bin.000001 # Query # # COMMIT
518 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
519 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
520 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
521 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
522 master-bin.000001 # Xid # # COMMIT /* XID */
523 -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-
524
525 SET @commands= 'B T Drop-Temp-TT-Temp C';
526 BEGIN;
527 INSERT INTO tt_xx_1() VALUES (1);
528 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
529 COMMIT;
530 -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-
531 include/show_binlog_events.inc
532 Log_name Pos Event_type Server_id End_log_pos Info
533 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
534 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
535 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
536 master-bin.000001 # Xid # # COMMIT /* XID */
537 -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-
538
539 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp C';
540 BEGIN;
541 INSERT INTO tt_xx_1() VALUES (1);
542 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
543 INSERT INTO nt_xx_1() VALUES (1);
544 COMMIT;
545 -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-
546 include/show_binlog_events.inc
547 Log_name Pos Event_type Server_id End_log_pos Info
548 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
549 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
550 master-bin.000001 # Query # # COMMIT
551 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
552 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
553 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
554 master-bin.000001 # Xid # # COMMIT /* XID */
555 -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-
556
557 SET @commands= 'B T Drop-Temp-NN-Temp C';
558 BEGIN;
559 INSERT INTO tt_xx_1() VALUES (1);
560 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
561 COMMIT;
562 -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-
563 include/show_binlog_events.inc
564 Log_name Pos Event_type Server_id End_log_pos Info
565 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
566 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
567 master-bin.000001 # Query # # COMMIT
568 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
569 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
570 master-bin.000001 # Xid # # COMMIT /* XID */
571 -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-
572
573 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp C';
574 BEGIN;
575 INSERT INTO tt_xx_1() VALUES (1);
576 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
577 INSERT INTO nt_xx_1() VALUES (1);
578 COMMIT;
579 -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-
580 include/show_binlog_events.inc
581 Log_name Pos Event_type Server_id End_log_pos Info
582 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
583 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
584 master-bin.000001 # Query # # COMMIT
585 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
586 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
587 master-bin.000001 # Query # # COMMIT
588 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
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 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 Ne 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 nt_error_1() VALUES (1), (1);
599 ERROR 23000: Duplicate entry '1' for key '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 Ne 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 # Gtid # # BEGIN GTID #-#-#
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 # Gtid # # BEGIN GTID #-#-#
608 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
609 master-bin.000001 # Query # # COMMIT
610 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
611 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (1), (1)
612 master-bin.000001 # Query # # COMMIT
613 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
614 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
615 master-bin.000001 # Xid # # COMMIT /* XID */
616 -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-
617
618 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te C';
619 BEGIN;
620 INSERT INTO tt_xx_1() VALUES (1);
621 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
622 INSERT INTO nt_xx_1() VALUES (1);
623 INSERT INTO tt_error_1() VALUES (1), (1);
624 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
625 COMMIT;
626 -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-
627 include/show_binlog_events.inc
628 Log_name Pos Event_type Server_id End_log_pos Info
629 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
630 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
631 master-bin.000001 # Query # # COMMIT
632 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
633 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
634 master-bin.000001 # Query # # COMMIT
635 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
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 Te C << -e-e-e-e-e-e-e-e-e-e-e-
639
640 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig C';
641 BEGIN;
642 INSERT INTO tt_xx_1() VALUES (1);
643 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
644 INSERT INTO nt_xx_1() VALUES (1);
645 INSERT INTO nt_error_1() VALUES (2), (2);
646 ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
647 COMMIT;
648 -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-
649 include/show_binlog_events.inc
650 Log_name Pos Event_type Server_id End_log_pos Info
651 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
652 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
653 master-bin.000001 # Query # # COMMIT
654 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
655 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
656 master-bin.000001 # Query # # COMMIT
657 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
658 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (2), (2)
659 master-bin.000001 # Query # # COMMIT
660 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
661 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
662 master-bin.000001 # Xid # # COMMIT /* XID */
663 -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-
664
665
666 #
667 #3) Generates in the binlog what follows:
668 #
669 SET @commands= 'B T Drop-Temp-T-Temp R';
670 BEGIN;
671 INSERT INTO tt_xx_1() VALUES (1);
672 DROP TEMPORARY TABLE tt_tmp_2;
673 ROLLBACK;
674 -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-
675 include/show_binlog_events.inc
676 Log_name Pos Event_type Server_id End_log_pos Info
677 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
678 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
679 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* 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 R << -e-e-e-e-e-e-e-e-e-e-e-
682
683 SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R';
684 BEGIN;
685 INSERT INTO tt_xx_1() VALUES (1);
686 DROP TEMPORARY TABLE tt_tmp_2;
687 INSERT INTO nt_xx_1() VALUES (1);
688 DROP TEMPORARY TABLE tt_tmp_1;
689 ROLLBACK;
690 Warnings:
691 Warning # Some non-transactional changed tables couldn't be rolled back
692 -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-
693 include/show_binlog_events.inc
694 Log_name Pos Event_type Server_id End_log_pos Info
695 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
696 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
697 master-bin.000001 # Query # # COMMIT
698 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
699 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
700 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
701 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
702 master-bin.000001 # Query # # ROLLBACK
703 -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-
704
705 SET @commands= 'B T Drop-Temp-N-Temp R';
706 BEGIN;
707 INSERT INTO tt_xx_1() VALUES (1);
708 DROP TEMPORARY TABLE nt_tmp_2;
709 ROLLBACK;
710 -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-
711 include/show_binlog_events.inc
712 Log_name Pos Event_type Server_id End_log_pos Info
713 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
714 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
715 master-bin.000001 # Query # # COMMIT
716 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
717 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
718 master-bin.000001 # Query # # ROLLBACK
719 -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-
720
721 SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R';
722 BEGIN;
723 INSERT INTO tt_xx_1() VALUES (1);
724 DROP TEMPORARY TABLE nt_tmp_2;
725 INSERT INTO nt_xx_1() VALUES (1);
726 DROP TEMPORARY TABLE nt_tmp_1;
727 ROLLBACK;
728 Warnings:
729 Warning # Some non-transactional changed tables couldn't be rolled back
730 -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-
731 include/show_binlog_events.inc
732 Log_name Pos Event_type Server_id End_log_pos Info
733 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
734 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
735 master-bin.000001 # Query # # COMMIT
736 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
737 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
738 master-bin.000001 # Query # # COMMIT
739 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
740 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
741 master-bin.000001 # Query # # COMMIT
742 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
743 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
744 master-bin.000001 # Query # # ROLLBACK
745 -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-
746
747 SET @commands= 'B T Drop-Temp-Xe-Temp R';
748 BEGIN;
749 INSERT INTO tt_xx_1() VALUES (1);
750 DROP TEMPORARY TABLE tt_xx_1;
751 ERROR 42S02: Unknown table 'test.tt_xx_1'
752 ROLLBACK;
753 -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-
754 include/show_binlog_events.inc
755 Log_name Pos Event_type Server_id End_log_pos Info
756 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
757 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
758 master-bin.000001 # Query # # ROLLBACK
759 -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-
760
761 SET @commands= 'B T Drop-Temp-Xe-Temp N Drop-Temp-Xe-Temp R';
762 BEGIN;
763 INSERT INTO tt_xx_1() VALUES (1);
764 DROP TEMPORARY TABLE tt_xx_1;
765 ERROR 42S02: Unknown table 'test.tt_xx_1'
766 INSERT INTO nt_xx_1() VALUES (1);
767 DROP TEMPORARY TABLE tt_xx_1;
768 ERROR 42S02: Unknown table 'test.tt_xx_1'
769 ROLLBACK;
770 Warnings:
771 Warning # Some non-transactional changed tables couldn't be rolled back
772 -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-
773 include/show_binlog_events.inc
774 Log_name Pos Event_type Server_id End_log_pos Info
775 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
776 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
777 master-bin.000001 # Query # # COMMIT
778 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
779 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
780 master-bin.000001 # Query # # ROLLBACK
781 -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-
782
783 SET @commands= 'B T Drop-Temp-If-Xe-Temp R';
784 BEGIN;
785 INSERT INTO tt_xx_1() VALUES (1);
786 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
787 Warnings:
788 Note 1051 Unknown table 'test.tt_xx_1'
789 ROLLBACK;
790 -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-
791 include/show_binlog_events.inc
792 Log_name Pos Event_type Server_id End_log_pos Info
793 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
794 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
795 master-bin.000001 # Query # # ROLLBACK
796 -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-
797
798 SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R';
799 BEGIN;
800 INSERT INTO tt_xx_1() VALUES (1);
801 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
802 Warnings:
803 Note 1051 Unknown table 'test.tt_xx_1'
804 INSERT INTO nt_xx_1() VALUES (1);
805 DROP TEMPORARY TABLE IF EXISTS tt_xx_1;
806 Warnings:
807 Note 1051 Unknown table 'test.tt_xx_1'
808 ROLLBACK;
809 Warnings:
810 Warning # Some non-transactional changed tables couldn't be rolled back
811 -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-
812 include/show_binlog_events.inc
813 Log_name Pos Event_type Server_id End_log_pos Info
814 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
815 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
816 master-bin.000001 # Query # # COMMIT
817 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
818 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
819 master-bin.000001 # Query # # ROLLBACK
820 -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-
821
822 SET @commands= 'B T Drop-Temp-TXe-Temp R';
823 BEGIN;
824 INSERT INTO tt_xx_1() VALUES (1);
825 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
826 ERROR 42S02: Unknown table 'test.tt_1'
827 ROLLBACK;
828 -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-
829 include/show_binlog_events.inc
830 Log_name Pos Event_type Server_id End_log_pos Info
831 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
832 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
833 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
834 master-bin.000001 # Query # # ROLLBACK
835 -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-
836
837 SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R';
838 BEGIN;
839 INSERT INTO tt_xx_1() VALUES (1);
840 DROP TEMPORARY TABLE tt_tmp_2, tt_1;
841 ERROR 42S02: Unknown table 'test.tt_1'
842 INSERT INTO nt_xx_1() VALUES (1);
843 DROP TEMPORARY TABLE tt_tmp_1, tt_1;
844 ERROR 42S02: Unknown table 'test.tt_1'
845 ROLLBACK;
846 Warnings:
847 Warning # Some non-transactional changed tables couldn't be rolled back
848 -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-
849 include/show_binlog_events.inc
850 Log_name Pos Event_type Server_id End_log_pos Info
851 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
852 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
853 master-bin.000001 # Query # # COMMIT
854 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
855 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
856 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
857 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
858 master-bin.000001 # Query # # ROLLBACK
859 -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-
860
861 SET @commands= 'B T Drop-Temp-If-TXe-Temp R';
862 BEGIN;
863 INSERT INTO tt_xx_1() VALUES (1);
864 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
865 Warnings:
866 Note 1051 Unknown table 'test.tt_1'
867 ROLLBACK;
868 -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-
869 include/show_binlog_events.inc
870 Log_name Pos Event_type Server_id End_log_pos Info
871 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
872 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
873 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
874 master-bin.000001 # Query # # ROLLBACK
875 -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-
876
877 SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R';
878 BEGIN;
879 INSERT INTO tt_xx_1() VALUES (1);
880 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2, tt_1;
881 Warnings:
882 Note 1051 Unknown table 'test.tt_1'
883 INSERT INTO nt_xx_1() VALUES (1);
884 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1, tt_1;
885 Warnings:
886 Note 1051 Unknown table 'test.tt_1'
887 ROLLBACK;
888 Warnings:
889 Warning # Some non-transactional changed tables couldn't be rolled back
890 -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-
891 include/show_binlog_events.inc
892 Log_name Pos Event_type Server_id End_log_pos Info
893 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
894 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
895 master-bin.000001 # Query # # COMMIT
896 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
897 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
898 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2` /* generated by server */
899 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1` /* generated by server */
900 master-bin.000001 # Query # # ROLLBACK
901 -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-
902
903 SET @commands= 'B T Drop-Temp-NXe-Temp R';
904 BEGIN;
905 INSERT INTO tt_xx_1() VALUES (1);
906 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
907 ERROR 42S02: Unknown table 'test.tt_1'
908 ROLLBACK;
909 -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-
910 include/show_binlog_events.inc
911 Log_name Pos Event_type Server_id End_log_pos Info
912 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
913 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
914 master-bin.000001 # Query # # COMMIT
915 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
916 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
917 master-bin.000001 # Query # # ROLLBACK
918 -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-
919
920 SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R';
921 BEGIN;
922 INSERT INTO tt_xx_1() VALUES (1);
923 DROP TEMPORARY TABLE nt_tmp_2, tt_1;
924 ERROR 42S02: Unknown table 'test.tt_1'
925 INSERT INTO nt_xx_1() VALUES (1);
926 DROP TEMPORARY TABLE nt_tmp_1, tt_1;
927 ERROR 42S02: Unknown table 'test.tt_1'
928 ROLLBACK;
929 Warnings:
930 Warning # Some non-transactional changed tables couldn't be rolled back
931 -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-
932 include/show_binlog_events.inc
933 Log_name Pos Event_type Server_id End_log_pos Info
934 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
935 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
936 master-bin.000001 # Query # # COMMIT
937 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
938 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
939 master-bin.000001 # Query # # COMMIT
940 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
941 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
942 master-bin.000001 # Query # # COMMIT
943 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
944 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
945 master-bin.000001 # Query # # ROLLBACK
946 -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-
947
948 SET @commands= 'B T Drop-Temp-If-NXe-Temp R';
949 BEGIN;
950 INSERT INTO tt_xx_1() VALUES (1);
951 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
952 Warnings:
953 Note 1051 Unknown table 'test.tt_1'
954 ROLLBACK;
955 -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-
956 include/show_binlog_events.inc
957 Log_name Pos Event_type Server_id End_log_pos Info
958 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
959 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
960 master-bin.000001 # Query # # COMMIT
961 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
962 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
963 master-bin.000001 # Query # # ROLLBACK
964 -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-
965
966 SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R';
967 BEGIN;
968 INSERT INTO tt_xx_1() VALUES (1);
969 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2, tt_1;
970 Warnings:
971 Note 1051 Unknown table 'test.tt_1'
972 INSERT INTO nt_xx_1() VALUES (1);
973 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1, tt_1;
974 Warnings:
975 Note 1051 Unknown table 'test.tt_1'
976 ROLLBACK;
977 Warnings:
978 Warning # Some non-transactional changed tables couldn't be rolled back
979 -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-
980 include/show_binlog_events.inc
981 Log_name Pos Event_type Server_id End_log_pos Info
982 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
983 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
984 master-bin.000001 # Query # # COMMIT
985 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
986 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
987 master-bin.000001 # Query # # COMMIT
988 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
989 master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
990 master-bin.000001 # Query # # COMMIT
991 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
992 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
993 master-bin.000001 # Query # # ROLLBACK
994 -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-
995
996 SET @commands= 'B T Drop-Temp-TN-Temp R';
997 BEGIN;
998 INSERT INTO tt_xx_1() VALUES (1);
999 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
1000 ROLLBACK;
1001 -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-
1002 include/show_binlog_events.inc
1003 Log_name Pos Event_type Server_id End_log_pos Info
1004 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1005 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1006 master-bin.000001 # Query # # COMMIT
1007 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1008 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1009 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1010 master-bin.000001 # Query # # ROLLBACK
1011 -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-
1012
1013 SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R';
1014 BEGIN;
1015 INSERT INTO tt_xx_1() VALUES (1);
1016 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
1017 INSERT INTO nt_xx_1() VALUES (1);
1018 DROP TEMPORARY TABLE tt_tmp_1, nt_tmp_1;
1019 ROLLBACK;
1020 Warnings:
1021 Warning # Some non-transactional changed tables couldn't be rolled back
1022 -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-
1023 include/show_binlog_events.inc
1024 Log_name Pos Event_type Server_id End_log_pos Info
1025 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1026 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1027 master-bin.000001 # Query # # COMMIT
1028 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1029 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1030 master-bin.000001 # Query # # COMMIT
1031 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1032 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
1033 master-bin.000001 # Query # # COMMIT
1034 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1035 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1036 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1037 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1038 master-bin.000001 # Query # # ROLLBACK
1039 -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-
1040
1041 SET @commands= 'B T Drop-Temp-TT-Temp R';
1042 BEGIN;
1043 INSERT INTO tt_xx_1() VALUES (1);
1044 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
1045 ROLLBACK;
1046 -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-
1047 include/show_binlog_events.inc
1048 Log_name Pos Event_type Server_id End_log_pos Info
1049 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1050 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1051 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
1052 master-bin.000001 # Query # # ROLLBACK
1053 -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-
1054
1055 SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R';
1056 BEGIN;
1057 INSERT INTO tt_xx_1() VALUES (1);
1058 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
1059 INSERT INTO nt_xx_1() VALUES (1);
1060 ROLLBACK;
1061 Warnings:
1062 Warning # Some non-transactional changed tables couldn't be rolled back
1063 -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-
1064 include/show_binlog_events.inc
1065 Log_name Pos Event_type Server_id End_log_pos Info
1066 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1067 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1068 master-bin.000001 # Query # # COMMIT
1069 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1070 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1071 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1`,`tt_tmp_2` /* generated by server */
1072 master-bin.000001 # Query # # ROLLBACK
1073 -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-
1074
1075 SET @commands= 'B T Drop-Temp-NN-Temp R';
1076 BEGIN;
1077 INSERT INTO tt_xx_1() VALUES (1);
1078 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1079 ROLLBACK;
1080 -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-
1081 include/show_binlog_events.inc
1082 Log_name Pos Event_type Server_id End_log_pos Info
1083 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1084 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1085 master-bin.000001 # Query # # COMMIT
1086 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1087 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1088 master-bin.000001 # Query # # ROLLBACK
1089 -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-
1090
1091 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R';
1092 BEGIN;
1093 INSERT INTO tt_xx_1() VALUES (1);
1094 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1095 INSERT INTO nt_xx_1() VALUES (1);
1096 ROLLBACK;
1097 Warnings:
1098 Warning # Some non-transactional changed tables couldn't be rolled back
1099 -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-
1100 include/show_binlog_events.inc
1101 Log_name Pos Event_type Server_id End_log_pos Info
1102 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1103 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1104 master-bin.000001 # Query # # COMMIT
1105 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1106 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1107 master-bin.000001 # Query # # COMMIT
1108 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1109 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1110 master-bin.000001 # Query # # ROLLBACK
1111 -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-
1112
1113 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Ne R';
1114 BEGIN;
1115 INSERT INTO tt_xx_1() VALUES (1);
1116 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1117 INSERT INTO nt_xx_1() VALUES (1);
1118 INSERT INTO nt_error_1() VALUES (3), (3);
1119 ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
1120 ROLLBACK;
1121 Warnings:
1122 Warning # Some non-transactional changed tables couldn't be rolled back
1123 -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-
1124 include/show_binlog_events.inc
1125 Log_name Pos Event_type Server_id End_log_pos Info
1126 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1127 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1128 master-bin.000001 # Query # # COMMIT
1129 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1130 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1131 master-bin.000001 # Query # # COMMIT
1132 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1133 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (3), (3)
1134 master-bin.000001 # Query # # COMMIT
1135 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1136 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1137 master-bin.000001 # Query # # ROLLBACK
1138 -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-
1139
1140 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp Te R';
1141 BEGIN;
1142 INSERT INTO tt_xx_1() VALUES (1);
1143 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1144 INSERT INTO nt_xx_1() VALUES (1);
1145 INSERT INTO tt_error_1() VALUES (2), (2);
1146 ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
1147 ROLLBACK;
1148 Warnings:
1149 Warning # Some non-transactional changed tables couldn't be rolled back
1150 -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-
1151 include/show_binlog_events.inc
1152 Log_name Pos Event_type Server_id End_log_pos Info
1153 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1154 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1155 master-bin.000001 # Query # # COMMIT
1156 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1157 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1158 master-bin.000001 # Query # # COMMIT
1159 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1160 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1161 master-bin.000001 # Query # # ROLLBACK
1162 -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-
1163
1164 SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp NeT-trig R';
1165 BEGIN;
1166 INSERT INTO tt_xx_1() VALUES (1);
1167 DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2;
1168 INSERT INTO nt_xx_1() VALUES (1);
1169 INSERT INTO nt_error_1() VALUES (4), (4);
1170 ERROR 23000: Duplicate entry '4' for key 'PRIMARY'
1171 ROLLBACK;
1172 Warnings:
1173 Warning # Some non-transactional changed tables couldn't be rolled back
1174 -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-
1175 include/show_binlog_events.inc
1176 Log_name Pos Event_type Server_id End_log_pos Info
1177 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1178 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1`,`nt_tmp_2` /* generated by server */
1179 master-bin.000001 # Query # # COMMIT
1180 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1181 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1182 master-bin.000001 # Query # # COMMIT
1183 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1184 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (4), (4)
1185 master-bin.000001 # Query # # COMMIT
1186 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1187 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1188 master-bin.000001 # Query # # ROLLBACK
1189 -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-
1190
1191 #########################################################################
1192 # 2 - Tables dropped by "DROP TABLE"
1193 #########################################################################
1194 connection master;
1195
1196 #
1197 #1) Generates in the binlog what follows:
1198 #
1199 SET @commands= 'Drop-T';
1200 DROP TABLE tt_2;
1201 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-T << -b-b-b-b-b-b-b-b-b-b-b-
1202 include/show_binlog_events.inc
1203 Log_name Pos Event_type Server_id End_log_pos Info
1204 master-bin.000001 # Gtid # # GTID #-#-#
1205 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1206 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-T << -e-e-e-e-e-e-e-e-e-e-e-
1207
1208 SET @commands= 'Drop-N';
1209 DROP TABLE nt_2;
1210 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-N << -b-b-b-b-b-b-b-b-b-b-b-
1211 include/show_binlog_events.inc
1212 Log_name Pos Event_type Server_id End_log_pos Info
1213 master-bin.000001 # Gtid # # GTID #-#-#
1214 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1215 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-N << -e-e-e-e-e-e-e-e-e-e-e-
1216
1217 SET @commands= 'Drop-Xe';
1218 DROP TABLE xx_1;
1219 ERROR 42S02: Unknown table 'test.xx_1'
1220 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Xe << -b-b-b-b-b-b-b-b-b-b-b-
1221 include/show_binlog_events.inc
1222 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Xe << -e-e-e-e-e-e-e-e-e-e-e-
1223
1224 SET @commands= 'Drop-If-Xe';
1225 DROP TABLE IF EXISTS xx_1;
1226 Warnings:
1227 Note 1051 Unknown table 'test.xx_1'
1228 -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-
1229 include/show_binlog_events.inc
1230 Log_name Pos Event_type Server_id End_log_pos Info
1231 master-bin.000001 # Gtid # # GTID #-#-#
1232 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1233 -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-
1234
1235 SET @commands= 'Drop-TXe';
1236 DROP TABLE tt_2, xx_1;
1237 ERROR 42S02: Unknown table 'test.xx_1'
1238 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b-
1239 include/show_binlog_events.inc
1240 Log_name Pos Event_type Server_id End_log_pos Info
1241 master-bin.000001 # Gtid # # GTID #-#-#
1242 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2`,`xx_1` /* generated by server */
1243 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e-
1244
1245 SET @commands= 'Drop-If-TXe';
1246 DROP TABLE IF EXISTS tt_2, xx_1;
1247 Warnings:
1248 Note 1051 Unknown table 'test.xx_1'
1249 -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-
1250 include/show_binlog_events.inc
1251 Log_name Pos Event_type Server_id End_log_pos Info
1252 master-bin.000001 # Gtid # # GTID #-#-#
1253 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */
1254 -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-
1255
1256 SET @commands= 'Drop-NXe';
1257 DROP TABLE nt_2, xx_1;
1258 ERROR 42S02: Unknown table 'test.xx_1'
1259 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-NXe << -b-b-b-b-b-b-b-b-b-b-b-
1260 include/show_binlog_events.inc
1261 Log_name Pos Event_type Server_id End_log_pos Info
1262 master-bin.000001 # Gtid # # GTID #-#-#
1263 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2`,`xx_1` /* generated by server */
1264 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-NXe << -e-e-e-e-e-e-e-e-e-e-e-
1265
1266 SET @commands= 'Drop-If-NXe';
1267 DROP TABLE IF EXISTS nt_2, xx_1;
1268 Warnings:
1269 Note 1051 Unknown table 'test.xx_1'
1270 -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-
1271 include/show_binlog_events.inc
1272 Log_name Pos Event_type Server_id End_log_pos Info
1273 master-bin.000001 # Gtid # # GTID #-#-#
1274 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `nt_2`,`xx_1` /* generated by server */
1275 -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-
1276
1277 SET @commands= 'Drop-TN';
1278 DROP TABLE tt_2, nt_2;
1279 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TN << -b-b-b-b-b-b-b-b-b-b-b-
1280 include/show_binlog_events.inc
1281 Log_name Pos Event_type Server_id End_log_pos Info
1282 master-bin.000001 # Gtid # # GTID #-#-#
1283 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2`,`nt_2` /* generated by server */
1284 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TN << -e-e-e-e-e-e-e-e-e-e-e-
1285
1286 SET @commands= 'Drop-TT';
1287 DROP TABLE tt_1, tt_2;
1288 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-TT << -b-b-b-b-b-b-b-b-b-b-b-
1289 include/show_binlog_events.inc
1290 Log_name Pos Event_type Server_id End_log_pos Info
1291 master-bin.000001 # Gtid # # GTID #-#-#
1292 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */
1293 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-TT << -e-e-e-e-e-e-e-e-e-e-e-
1294
1295 SET @commands= 'Drop-NN';
1296 DROP TABLE nt_1, nt_2;
1297 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-NN << -b-b-b-b-b-b-b-b-b-b-b-
1298 include/show_binlog_events.inc
1299 Log_name Pos Event_type Server_id End_log_pos Info
1300 master-bin.000001 # Gtid # # GTID #-#-#
1301 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1`,`nt_2` /* generated by server */
1302 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-NN << -e-e-e-e-e-e-e-e-e-e-e-
1303
1304 SET @commands= 'Drop-N-TN-Temp';
1305 DROP TABLE tt_tmp_2, nt_tmp_2, nt_2;
1306 -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-
1307 include/show_binlog_events.inc
1308 Log_name Pos Event_type Server_id End_log_pos Info
1309 master-bin.000001 # Gtid # # GTID #-#-#
1310 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1311 master-bin.000001 # Gtid # # GTID #-#-#
1312 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1313 master-bin.000001 # Gtid # # GTID #-#-#
1314 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1315 -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-
1316
1317 SET @commands= 'Drop-TN-Temp';
1318 DROP TABLE tt_tmp_2, nt_tmp_2;
1319 -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-
1320 include/show_binlog_events.inc
1321 Log_name Pos Event_type Server_id End_log_pos Info
1322 master-bin.000001 # Gtid # # GTID #-#-#
1323 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1324 master-bin.000001 # Gtid # # GTID #-#-#
1325 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1326 -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-
1327
1328
1329 #
1330 #2) Generates in the binlog what follows:
1331 #
1332 SET @commands= 'B T Drop-T';
1333 BEGIN;
1334 INSERT INTO tt_xx_1() VALUES (1);
1335 DROP TABLE tt_2;
1336 -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-
1337 include/show_binlog_events.inc
1338 Log_name Pos Event_type Server_id End_log_pos Info
1339 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1340 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1341 master-bin.000001 # Xid # # COMMIT /* XID */
1342 master-bin.000001 # Gtid # # GTID #-#-#
1343 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2` /* generated by server */
1344 -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-
1345
1346 SET @commands= 'B T Drop-N';
1347 BEGIN;
1348 INSERT INTO tt_xx_1() VALUES (1);
1349 DROP TABLE nt_2;
1350 -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-
1351 include/show_binlog_events.inc
1352 Log_name Pos Event_type Server_id End_log_pos Info
1353 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1354 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1355 master-bin.000001 # Xid # # COMMIT /* XID */
1356 master-bin.000001 # Gtid # # GTID #-#-#
1357 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1358 -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-
1359
1360 SET @commands= 'B T Drop-Xe';
1361 BEGIN;
1362 INSERT INTO tt_xx_1() VALUES (1);
1363 DROP TABLE xx_1;
1364 ERROR 42S02: Unknown table 'test.xx_1'
1365 -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-
1366 include/show_binlog_events.inc
1367 Log_name Pos Event_type Server_id End_log_pos Info
1368 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1369 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1370 master-bin.000001 # Xid # # COMMIT /* XID */
1371 -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-
1372
1373 SET @commands= 'B T Drop-If-Xe';
1374 BEGIN;
1375 INSERT INTO tt_xx_1() VALUES (1);
1376 DROP TABLE IF EXISTS xx_1;
1377 Warnings:
1378 Note 1051 Unknown table 'test.xx_1'
1379 -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-
1380 include/show_binlog_events.inc
1381 Log_name Pos Event_type Server_id End_log_pos Info
1382 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1383 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1384 master-bin.000001 # Xid # # COMMIT /* XID */
1385 master-bin.000001 # Gtid # # GTID #-#-#
1386 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
1387 -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-
1388
1389 SET @commands= 'B T Drop-TXe';
1390 BEGIN;
1391 INSERT INTO tt_xx_1() VALUES (1);
1392 DROP TABLE tt_2, xx_1;
1393 ERROR 42S02: Unknown table 'test.xx_1'
1394 -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-
1395 include/show_binlog_events.inc
1396 Log_name Pos Event_type Server_id End_log_pos Info
1397 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1398 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1399 master-bin.000001 # Xid # # COMMIT /* XID */
1400 master-bin.000001 # Gtid # # GTID #-#-#
1401 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2`,`xx_1` /* generated by server */
1402 -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-
1403
1404 SET @commands= 'B T Drop-If-TXe';
1405 BEGIN;
1406 INSERT INTO tt_xx_1() VALUES (1);
1407 DROP TABLE IF EXISTS tt_2, xx_1;
1408 Warnings:
1409 Note 1051 Unknown table 'test.xx_1'
1410 -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-
1411 include/show_binlog_events.inc
1412 Log_name Pos Event_type Server_id End_log_pos Info
1413 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1414 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1415 master-bin.000001 # Xid # # COMMIT /* XID */
1416 master-bin.000001 # Gtid # # GTID #-#-#
1417 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `tt_2`,`xx_1` /* generated by server */
1418 -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-
1419
1420 SET @commands= 'B T Drop-NXe';
1421 BEGIN;
1422 INSERT INTO tt_xx_1() VALUES (1);
1423 DROP TABLE nt_2, xx_1;
1424 ERROR 42S02: Unknown table 'test.xx_1'
1425 -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-
1426 include/show_binlog_events.inc
1427 Log_name Pos Event_type Server_id End_log_pos Info
1428 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1429 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1430 master-bin.000001 # Xid # # COMMIT /* XID */
1431 master-bin.000001 # Gtid # # GTID #-#-#
1432 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2`,`xx_1` /* generated by server */
1433 -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-
1434
1435 SET @commands= 'B T Drop-If-NXe';
1436 BEGIN;
1437 INSERT INTO tt_xx_1() VALUES (1);
1438 DROP TABLE IF EXISTS nt_2, xx_1;
1439 Warnings:
1440 Note 1051 Unknown table 'test.xx_1'
1441 -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-
1442 include/show_binlog_events.inc
1443 Log_name Pos Event_type Server_id End_log_pos Info
1444 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1445 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1446 master-bin.000001 # Xid # # COMMIT /* XID */
1447 master-bin.000001 # Gtid # # GTID #-#-#
1448 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `nt_2`,`xx_1` /* generated by server */
1449 -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-
1450
1451 SET @commands= 'B T Drop-TN';
1452 BEGIN;
1453 INSERT INTO tt_xx_1() VALUES (1);
1454 DROP TABLE tt_2, nt_2;
1455 -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-
1456 include/show_binlog_events.inc
1457 Log_name Pos Event_type Server_id End_log_pos Info
1458 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1459 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1460 master-bin.000001 # Xid # # COMMIT /* XID */
1461 master-bin.000001 # Gtid # # GTID #-#-#
1462 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2`,`nt_2` /* generated by server */
1463 -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-
1464
1465 SET @commands= 'B T Drop-TT';
1466 BEGIN;
1467 INSERT INTO tt_xx_1() VALUES (1);
1468 DROP TABLE tt_1, tt_2;
1469 -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-
1470 include/show_binlog_events.inc
1471 Log_name Pos Event_type Server_id End_log_pos Info
1472 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1473 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1474 master-bin.000001 # Xid # # COMMIT /* XID */
1475 master-bin.000001 # Gtid # # GTID #-#-#
1476 master-bin.000001 # Query # # use `test`; DROP TABLE `tt_1`,`tt_2` /* generated by server */
1477 -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-
1478
1479 SET @commands= 'B T Drop-NN';
1480 BEGIN;
1481 INSERT INTO tt_xx_1() VALUES (1);
1482 DROP TABLE nt_1, nt_2;
1483 -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-
1484 include/show_binlog_events.inc
1485 Log_name Pos Event_type Server_id End_log_pos Info
1486 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1487 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1488 master-bin.000001 # Xid # # COMMIT /* XID */
1489 master-bin.000001 # Gtid # # GTID #-#-#
1490 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_1`,`nt_2` /* generated by server */
1491 -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-
1492
1493 SET @commands= 'B T Drop-N-TN-Temp';
1494 BEGIN;
1495 INSERT INTO tt_xx_1() VALUES (1);
1496 DROP TABLE tt_tmp_2, nt_tmp_2, nt_2;
1497 -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-
1498 include/show_binlog_events.inc
1499 Log_name Pos Event_type Server_id End_log_pos Info
1500 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1501 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1502 master-bin.000001 # Xid # # COMMIT /* XID */
1503 master-bin.000001 # Gtid # # GTID #-#-#
1504 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1505 master-bin.000001 # Gtid # # GTID #-#-#
1506 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1507 master-bin.000001 # Gtid # # GTID #-#-#
1508 master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */
1509 -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-
1510
1511 SET @commands= 'B T Drop-TN-Temp';
1512 BEGIN;
1513 INSERT INTO tt_xx_1() VALUES (1);
1514 DROP TABLE tt_tmp_2, nt_tmp_2;
1515 -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-
1516 include/show_binlog_events.inc
1517 Log_name Pos Event_type Server_id End_log_pos Info
1518 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1519 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1520 master-bin.000001 # Xid # # COMMIT /* XID */
1521 master-bin.000001 # Gtid # # GTID #-#-#
1522 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1523 master-bin.000001 # Gtid # # GTID #-#-#
1524 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1525 -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-
1526
1527 #########################################################################
1528 # 3 - CREATE TEMPORARY TABLE
1529 #########################################################################
1530 connection master;
1531
1532 #
1533 #1) Generates in the binlog what follows:
1534 #
1535 SET @commands= 'Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp';
1536 DROP TEMPORARY TABLE nt_tmp_2;
1537 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1538 DROP TEMPORARY TABLE nt_tmp_1;
1539 DROP TEMPORARY TABLE nt_tmp_2;
1540 -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-
1541 include/show_binlog_events.inc
1542 Log_name Pos Event_type Server_id End_log_pos Info
1543 master-bin.000001 # Gtid # # GTID #-#-#
1544 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1545 master-bin.000001 # Gtid # # GTID #-#-#
1546 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam
1547 master-bin.000001 # Gtid # # GTID #-#-#
1548 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
1549 master-bin.000001 # Gtid # # GTID #-#-#
1550 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1551 -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-
1552
1553 SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp';
1554 DROP TEMPORARY TABLE tt_tmp_2;
1555 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1556 DROP TEMPORARY TABLE tt_tmp_1;
1557 DROP TEMPORARY TABLE tt_tmp_2;
1558 -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-
1559 include/show_binlog_events.inc
1560 Log_name Pos Event_type Server_id End_log_pos Info
1561 master-bin.000001 # Gtid # # GTID #-#-#
1562 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1563 master-bin.000001 # Gtid # # GTID #-#-#
1564 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1565 master-bin.000001 # Gtid # # GTID #-#-#
1566 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1567 master-bin.000001 # Gtid # # GTID #-#-#
1568 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1569 -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-
1570
1571
1572 #
1573 #2) Generates in the binlog what follows:
1574 #
1575 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp C';
1576 BEGIN;
1577 INSERT INTO tt_xx_1() VALUES (1);
1578 DROP TEMPORARY TABLE nt_tmp_2;
1579 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1580 DROP TEMPORARY TABLE nt_tmp_1;
1581 DROP TEMPORARY TABLE nt_tmp_2;
1582 COMMIT;
1583 -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-
1584 include/show_binlog_events.inc
1585 Log_name Pos Event_type Server_id End_log_pos Info
1586 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1587 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1588 master-bin.000001 # Query # # COMMIT
1589 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1590 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam
1591 master-bin.000001 # Query # # COMMIT
1592 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1593 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
1594 master-bin.000001 # Query # # COMMIT
1595 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1596 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1597 master-bin.000001 # Query # # COMMIT
1598 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1599 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1600 master-bin.000001 # Xid # # COMMIT /* XID */
1601 -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-
1602
1603 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp C';
1604 BEGIN;
1605 DROP TEMPORARY TABLE tt_tmp_2;
1606 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1607 DROP TEMPORARY TABLE tt_tmp_1;
1608 DROP TEMPORARY TABLE tt_tmp_2;
1609 COMMIT;
1610 -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-
1611 include/show_binlog_events.inc
1612 Log_name Pos Event_type Server_id End_log_pos Info
1613 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1614 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1615 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1616 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1617 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1618 master-bin.000001 # Query # # COMMIT
1619 -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-
1620
1621 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C';
1622 BEGIN;
1623 DROP TEMPORARY TABLE tt_tmp_2;
1624 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1625 DROP TEMPORARY TABLE tt_tmp_1;
1626 DROP TEMPORARY TABLE tt_tmp_2;
1627 INSERT INTO nt_error_1() VALUES (5), (5);
1628 ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
1629 COMMIT;
1630 -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-
1631 include/show_binlog_events.inc
1632 Log_name Pos Event_type Server_id End_log_pos Info
1633 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1634 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (5), (5)
1635 master-bin.000001 # Query # # COMMIT
1636 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1637 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1638 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1639 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1640 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1641 master-bin.000001 # Query # # COMMIT
1642 -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-
1643
1644 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C';
1645 BEGIN;
1646 DROP TEMPORARY TABLE tt_tmp_2;
1647 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1648 DROP TEMPORARY TABLE tt_tmp_1;
1649 DROP TEMPORARY TABLE tt_tmp_2;
1650 INSERT INTO tt_error_1() VALUES (3), (3);
1651 ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
1652 COMMIT;
1653 -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-
1654 include/show_binlog_events.inc
1655 Log_name Pos Event_type Server_id End_log_pos Info
1656 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1657 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1658 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1659 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1660 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1661 master-bin.000001 # Query # # COMMIT
1662 -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-
1663
1664 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C';
1665 BEGIN;
1666 DROP TEMPORARY TABLE tt_tmp_2;
1667 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1668 DROP TEMPORARY TABLE tt_tmp_1;
1669 DROP TEMPORARY TABLE tt_tmp_2;
1670 INSERT INTO nt_error_1() VALUES (6), (6);
1671 ERROR 23000: Duplicate entry '6' for key 'PRIMARY'
1672 COMMIT;
1673 -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-
1674 include/show_binlog_events.inc
1675 Log_name Pos Event_type Server_id End_log_pos Info
1676 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1677 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (6), (6)
1678 master-bin.000001 # Query # # COMMIT
1679 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1680 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1681 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1682 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1683 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1684 master-bin.000001 # Query # # COMMIT
1685 -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-
1686
1687
1688 #
1689 #3) Generates in the binlog what follows:
1690 #
1691 SET @commands= 'B T Drop-Temp-N-Temp Create-N-Temp Drop-Temp-N-Temp Drop-Temp-N-Temp R';
1692 BEGIN;
1693 INSERT INTO tt_xx_1() VALUES (1);
1694 DROP TEMPORARY TABLE nt_tmp_2;
1695 CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam;
1696 DROP TEMPORARY TABLE nt_tmp_1;
1697 DROP TEMPORARY TABLE nt_tmp_2;
1698 ROLLBACK;
1699 -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-
1700 include/show_binlog_events.inc
1701 Log_name Pos Event_type Server_id End_log_pos Info
1702 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1703 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1704 master-bin.000001 # Query # # COMMIT
1705 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1706 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE nt_tmp_2 ( id INT ) engine= MyIsam
1707 master-bin.000001 # Query # # COMMIT
1708 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1709 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_1` /* generated by server */
1710 master-bin.000001 # Query # # COMMIT
1711 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1712 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `nt_tmp_2` /* generated by server */
1713 master-bin.000001 # Query # # COMMIT
1714 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1715 master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
1716 master-bin.000001 # Query # # ROLLBACK
1717 -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-
1718
1719 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R';
1720 BEGIN;
1721 DROP TEMPORARY TABLE tt_tmp_2;
1722 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1723 DROP TEMPORARY TABLE tt_tmp_1;
1724 DROP TEMPORARY TABLE tt_tmp_2;
1725 ROLLBACK;
1726 -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-
1727 include/show_binlog_events.inc
1728 Log_name Pos Event_type Server_id End_log_pos Info
1729 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1730 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1731 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1732 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1733 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1734 master-bin.000001 # Query # # ROLLBACK
1735 -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-
1736
1737 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R';
1738 BEGIN;
1739 DROP TEMPORARY TABLE tt_tmp_2;
1740 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1741 DROP TEMPORARY TABLE tt_tmp_1;
1742 DROP TEMPORARY TABLE tt_tmp_2;
1743 INSERT INTO nt_error_1() VALUES (7), (7);
1744 ERROR 23000: Duplicate entry '7' for key 'PRIMARY'
1745 ROLLBACK;
1746 Warnings:
1747 Warning # Some non-transactional changed tables couldn't be rolled back
1748 -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-
1749 include/show_binlog_events.inc
1750 Log_name Pos Event_type Server_id End_log_pos Info
1751 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1752 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (7), (7)
1753 master-bin.000001 # Query # # COMMIT
1754 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1755 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1756 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1757 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1758 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1759 master-bin.000001 # Query # # ROLLBACK
1760 -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-
1761
1762 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R';
1763 BEGIN;
1764 DROP TEMPORARY TABLE tt_tmp_2;
1765 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1766 DROP TEMPORARY TABLE tt_tmp_1;
1767 DROP TEMPORARY TABLE tt_tmp_2;
1768 INSERT INTO tt_error_1() VALUES (4), (4);
1769 ERROR 23000: Duplicate entry '4' for key 'PRIMARY'
1770 ROLLBACK;
1771 -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-
1772 include/show_binlog_events.inc
1773 Log_name Pos Event_type Server_id End_log_pos Info
1774 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1775 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1776 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1777 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1778 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1779 master-bin.000001 # Query # # ROLLBACK
1780 -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-
1781
1782 SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R';
1783 BEGIN;
1784 DROP TEMPORARY TABLE tt_tmp_2;
1785 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
1786 DROP TEMPORARY TABLE tt_tmp_1;
1787 DROP TEMPORARY TABLE tt_tmp_2;
1788 INSERT INTO nt_error_1() VALUES (8), (8);
1789 ERROR 23000: Duplicate entry '8' for key 'PRIMARY'
1790 ROLLBACK;
1791 Warnings:
1792 Warning # Some non-transactional changed tables couldn't be rolled back
1793 -b-b-b-b-b-b-b-b-b-b-b- >> B 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-
1794 include/show_binlog_events.inc
1795 Log_name Pos Event_type Server_id End_log_pos Info
1796 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1797 master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (8), (8)
1798 master-bin.000001 # Query # # COMMIT
1799 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1800 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1801 master-bin.000001 # Query # # use `test`; CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb
1802 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_1` /* generated by server */
1803 master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE `tt_tmp_2` /* generated by server */
1804 master-bin.000001 # Query # # ROLLBACK
1805 -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-
1806
1807 #########################################################################
1808 # 4 - CHANGING TEMPORARY TABLES
1809 #########################################################################
1810 connection master;
1811
1812 #
1813 #1) Generates in the binlog what follows:
1814 #
1815 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp C';
1816 BEGIN;
1817 INSERT INTO nt_xx_1() VALUES (1);
1818 INSERT INTO nt_tmp_xx_1() VALUES (1);
1819 INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1;
1820 INSERT INTO nt_tmp_xx_1() VALUES (1);
1821 COMMIT;
1822 -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-
1823 include/show_binlog_events.inc
1824 Log_name Pos Event_type Server_id End_log_pos Info
1825 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1826 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1827 master-bin.000001 # Query # # COMMIT
1828 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1829 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1830 master-bin.000001 # Query # # COMMIT
1831 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1832 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1
1833 master-bin.000001 # Query # # COMMIT
1834 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1835 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1836 master-bin.000001 # Query # # COMMIT
1837 -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-
1838
1839 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp C';
1840 BEGIN;
1841 INSERT INTO nt_xx_1() VALUES (1);
1842 INSERT INTO nt_tmp_xx_1() VALUES (1);
1843 INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1;
1844 INSERT INTO nt_tmp_xx_1() VALUES (1);
1845 COMMIT;
1846 -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-
1847 include/show_binlog_events.inc
1848 Log_name Pos Event_type Server_id End_log_pos Info
1849 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1850 master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
1851 master-bin.000001 # Query # # COMMIT
1852 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1853 master-bin.000001 # Query # # use `test`; INSERT INTO nt_tmp_xx_1() VALUES (1)
1854 master-bin.000001 # Query # # COMMIT
1855 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1856 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1
1857 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
1858 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1859 master-bin.000001 # Xid # # COMMIT /* XID */
1860 -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-
1861
1862 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp C';
1863 BEGIN;
1864 INSERT INTO nt_xx_1() VALUES (1);
1865 INSERT INTO nt_tmp_xx_1() VALUES (1);
1866 INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1;
1867 INSERT INTO nt_tmp_xx_1() VALUES (1);
1868 COMMIT;
1869 -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-
1870 include/show_binlog_events.inc
1871 Log_name Pos Event_type Server_id End_log_pos Info
1872 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1873 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
1874 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1875 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1876 master-bin.000001 # Query # # COMMIT
1877 -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-
1878
1879 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp C';
1880 BEGIN;
1881 INSERT INTO nt_xx_1() VALUES (1);
1882 INSERT INTO nt_tmp_xx_1() VALUES (1);
1883 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1884 INSERT INTO nt_tmp_xx_1() VALUES (1);
1885 COMMIT;
1886 -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-
1887 include/show_binlog_events.inc
1888 Log_name Pos Event_type Server_id End_log_pos Info
1889 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1890 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
1891 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1892 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1893 master-bin.000001 # Query # # COMMIT
1894 -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-
1895
1896 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne C';
1897 BEGIN;
1898 INSERT INTO nt_xx_1() VALUES (1);
1899 INSERT INTO nt_tmp_xx_1() VALUES (1);
1900 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1901 INSERT INTO nt_tmp_xx_1() VALUES (1);
1902 INSERT INTO nt_error_1() VALUES (9), (9);
1903 ERROR 23000: Duplicate entry '9' for key 'PRIMARY'
1904 COMMIT;
1905 -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-
1906 include/show_binlog_events.inc
1907 Log_name Pos Event_type Server_id End_log_pos Info
1908 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1909 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
1910 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1911 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1912 master-bin.000001 # Query # # COMMIT
1913 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1914 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (9), (9)
1915 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1916 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1917 master-bin.000001 # Query # # COMMIT
1918 -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-
1919
1920 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te C';
1921 BEGIN;
1922 INSERT INTO nt_xx_1() VALUES (1);
1923 INSERT INTO nt_tmp_xx_1() VALUES (1);
1924 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1925 INSERT INTO nt_tmp_xx_1() VALUES (1);
1926 INSERT INTO tt_error_1() VALUES (5), (5);
1927 ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
1928 COMMIT;
1929 -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-
1930 include/show_binlog_events.inc
1931 Log_name Pos Event_type Server_id End_log_pos Info
1932 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1933 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
1934 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1935 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1936 master-bin.000001 # Query # # COMMIT
1937 -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-
1938
1939 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig C';
1940 BEGIN;
1941 INSERT INTO nt_xx_1() VALUES (1);
1942 INSERT INTO nt_tmp_xx_1() VALUES (1);
1943 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
1944 INSERT INTO nt_tmp_xx_1() VALUES (1);
1945 INSERT INTO nt_error_1() VALUES (10), (10);
1946 ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
1947 COMMIT;
1948 -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-
1949 include/show_binlog_events.inc
1950 Log_name Pos Event_type Server_id End_log_pos Info
1951 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1952 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
1953 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1954 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1955 master-bin.000001 # Query # # COMMIT
1956 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1957 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (10), (10)
1958 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
1959 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1960 master-bin.000001 # Query # # COMMIT
1961 -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-
1962
1963
1964
1965 #
1966 #2) Generates in the binlog what follows:
1967 #
1968 SET @commands= 'B N N-Temp N-SELECT-N-Temp N-Temp R';
1969 BEGIN;
1970 INSERT INTO nt_xx_1() VALUES (1);
1971 INSERT INTO nt_tmp_xx_1() VALUES (1);
1972 INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1;
1973 INSERT INTO nt_tmp_xx_1() VALUES (1);
1974 ROLLBACK;
1975 Warnings:
1976 Warning # Some non-transactional changed tables couldn't be rolled back
1977 -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-
1978 include/show_binlog_events.inc
1979 Log_name Pos Event_type Server_id End_log_pos Info
1980 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1981 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
1982 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1983 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1984 master-bin.000001 # Query # # COMMIT
1985 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
1986 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1 SELECT * FROM nt_tmp_xx_1
1987 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
1988 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
1989 master-bin.000001 # Query # # COMMIT
1990 -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-
1991
1992 SET @commands= 'B N N-Temp T-SELECT-N-Temp N-Temp R';
1993 BEGIN;
1994 INSERT INTO nt_xx_1() VALUES (1);
1995 INSERT INTO nt_tmp_xx_1() VALUES (1);
1996 INSERT INTO tt_xx_1 SELECT * FROM nt_tmp_xx_1;
1997 INSERT INTO nt_tmp_xx_1() VALUES (1);
1998 ROLLBACK;
1999 Warnings:
2000 Warning # Some non-transactional changed tables couldn't be rolled back
2001 -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-
2002 include/show_binlog_events.inc
2003 Log_name Pos Event_type Server_id End_log_pos Info
2004 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2005 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
2006 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
2007 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2008 master-bin.000001 # Query # # COMMIT
2009 -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-
2010
2011 SET @commands= 'B N N-Temp N-SELECT-T-Temp N-Temp R';
2012 BEGIN;
2013 INSERT INTO nt_xx_1() VALUES (1);
2014 INSERT INTO nt_tmp_xx_1() VALUES (1);
2015 INSERT INTO nt_xx_1 SELECT * FROM tt_tmp_xx_1;
2016 INSERT INTO nt_tmp_xx_1() VALUES (1);
2017 ROLLBACK;
2018 Warnings:
2019 Warning # Some non-transactional changed tables couldn't be rolled back
2020 -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-
2021 include/show_binlog_events.inc
2022 Log_name Pos Event_type Server_id End_log_pos Info
2023 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2024 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
2025 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
2026 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2027 master-bin.000001 # Query # # COMMIT
2028 -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-
2029
2030 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp R';
2031 BEGIN;
2032 INSERT INTO nt_xx_1() VALUES (1);
2033 INSERT INTO nt_tmp_xx_1() VALUES (1);
2034 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
2035 INSERT INTO nt_tmp_xx_1() VALUES (1);
2036 ROLLBACK;
2037 Warnings:
2038 Warning # Some non-transactional changed tables couldn't be rolled back
2039 -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-
2040 include/show_binlog_events.inc
2041 Log_name Pos Event_type Server_id End_log_pos Info
2042 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2043 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
2044 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
2045 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2046 master-bin.000001 # Query # # COMMIT
2047 -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-
2048
2049 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Ne R';
2050 BEGIN;
2051 INSERT INTO nt_xx_1() VALUES (1);
2052 INSERT INTO nt_tmp_xx_1() VALUES (1);
2053 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
2054 INSERT INTO nt_tmp_xx_1() VALUES (1);
2055 INSERT INTO nt_error_1() VALUES (11), (11);
2056 ERROR 23000: Duplicate entry '11' for key 'PRIMARY'
2057 ROLLBACK;
2058 Warnings:
2059 Warning # Some non-transactional changed tables couldn't be rolled back
2060 -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-
2061 include/show_binlog_events.inc
2062 Log_name Pos Event_type Server_id End_log_pos Info
2063 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2064 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
2065 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
2066 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2067 master-bin.000001 # Query # # COMMIT
2068 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2069 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (11), (11)
2070 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
2071 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2072 master-bin.000001 # Query # # COMMIT
2073 -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-
2074
2075 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp Te R';
2076 BEGIN;
2077 INSERT INTO nt_xx_1() VALUES (1);
2078 INSERT INTO nt_tmp_xx_1() VALUES (1);
2079 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
2080 INSERT INTO nt_tmp_xx_1() VALUES (1);
2081 INSERT INTO tt_error_1() VALUES (6), (6);
2082 ERROR 23000: Duplicate entry '6' for key 'PRIMARY'
2083 ROLLBACK;
2084 Warnings:
2085 Warning # Some non-transactional changed tables couldn't be rolled back
2086 -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-
2087 include/show_binlog_events.inc
2088 Log_name Pos Event_type Server_id End_log_pos Info
2089 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2090 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
2091 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
2092 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2093 master-bin.000001 # Query # # COMMIT
2094 -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-
2095
2096 SET @commands= 'B N N-Temp T-SELECT-T-Temp N-Temp NeT-trig R';
2097 BEGIN;
2098 INSERT INTO nt_xx_1() VALUES (1);
2099 INSERT INTO nt_tmp_xx_1() VALUES (1);
2100 INSERT INTO tt_xx_1 SELECT * FROM tt_tmp_xx_1;
2101 INSERT INTO nt_tmp_xx_1() VALUES (1);
2102 INSERT INTO nt_error_1() VALUES (12), (12);
2103 ERROR 23000: Duplicate entry '12' for key 'PRIMARY'
2104 ROLLBACK;
2105 Warnings:
2106 Warning # Some non-transactional changed tables couldn't be rolled back
2107 -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-
2108 include/show_binlog_events.inc
2109 Log_name Pos Event_type Server_id End_log_pos Info
2110 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2111 master-bin.000001 # Annotate_rows # # INSERT INTO nt_xx_1() VALUES (1)
2112 master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1)
2113 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2114 master-bin.000001 # Query # # COMMIT
2115 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2116 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (12), (12)
2117 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
2118 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2119 master-bin.000001 # Query # # COMMIT
2120 -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-
2121
2122 # > MDEV-26833
2123 # Errored out and rolled back Te statement should not produce any event to binlog
2124 # in the following cases:
2125 SET @sav_var = @@session.binlog_direct_non_transactional_updates;
2126 SET @@session.binlog_direct_non_transactional_updates = ON;
2127 SET @commands= 'B T Drop-Temp-TT-Temp Te C';
2128 BEGIN;
2129 INSERT INTO tt_xx_1() VALUES (1);
2130 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
2131 INSERT INTO tt_error_1() VALUES (7), (7);
2132 ERROR 23000: Duplicate entry '7' for key 'PRIMARY'
2133 COMMIT;
2134 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2135 include/show_binlog_events.inc
2136 Log_name Pos Event_type Server_id End_log_pos Info
2137 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2138 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2139 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2140 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2141 master-bin.000001 # Xid # # COMMIT /* XID */
2142 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2143
2144 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te C';
2145 DROP TEMPORARY TABLE tt_tmp_2;
2146 BEGIN;
2147 INSERT INTO tt_xx_1() VALUES (1);
2148 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
2149 INSERT INTO tt_error_1() VALUES (8), (8);
2150 ERROR 23000: Duplicate entry '8' for key 'PRIMARY'
2151 COMMIT;
2152 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-T-Temp B T Create-T-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2153 include/show_binlog_events.inc
2154 Log_name Pos Event_type Server_id End_log_pos Info
2155 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2156 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2157 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2158 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2159 master-bin.000001 # Xid # # COMMIT /* XID */
2160 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-T-Temp B T Create-T-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2161
2162 SET @commands= 'B T Drop-Temp-TN-Temp Te C';
2163 BEGIN;
2164 INSERT INTO tt_xx_1() VALUES (1);
2165 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
2166 INSERT INTO tt_error_1() VALUES (9), (9);
2167 ERROR 23000: Duplicate entry '9' for key 'PRIMARY'
2168 COMMIT;
2169 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2170 include/show_binlog_events.inc
2171 Log_name Pos Event_type Server_id End_log_pos Info
2172 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2173 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2174 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2175 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2176 master-bin.000001 # Xid # # COMMIT /* XID */
2177 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2178
2179 SET @commands= 'B T N-Temp Te C';
2180 BEGIN;
2181 INSERT INTO tt_xx_1() VALUES (1);
2182 INSERT INTO nt_tmp_xx_1() VALUES (1);
2183 INSERT INTO tt_error_1() VALUES (10), (10);
2184 ERROR 23000: Duplicate entry '10' for key 'PRIMARY'
2185 COMMIT;
2186 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2187 include/show_binlog_events.inc
2188 Log_name Pos Event_type Server_id End_log_pos Info
2189 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2190 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2191 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2192 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2193 master-bin.000001 # Xid # # COMMIT /* XID */
2194 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2195
2196 SET @commands= 'B T Drop-Temp-TT-Temp Te R';
2197 BEGIN;
2198 INSERT INTO tt_xx_1() VALUES (1);
2199 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
2200 INSERT INTO tt_error_1() VALUES (11), (11);
2201 ERROR 23000: Duplicate entry '11' for key 'PRIMARY'
2202 ROLLBACK;
2203 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2204 include/show_binlog_events.inc
2205 Log_name Pos Event_type Server_id End_log_pos Info
2206 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2207 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2208 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2209 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2210 master-bin.000001 # Query # # ROLLBACK
2211 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2212
2213 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te R';
2214 DROP TEMPORARY TABLE tt_tmp_2;
2215 BEGIN;
2216 INSERT INTO tt_xx_1() VALUES (1);
2217 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
2218 INSERT INTO tt_error_1() VALUES (12), (12);
2219 ERROR 23000: Duplicate entry '12' for key 'PRIMARY'
2220 ROLLBACK;
2221 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-T-Temp B T Create-T-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2222 include/show_binlog_events.inc
2223 Log_name Pos Event_type Server_id End_log_pos Info
2224 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2225 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2226 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2227 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2228 master-bin.000001 # Query # # ROLLBACK
2229 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-T-Temp B T Create-T-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2230
2231 SET @commands= 'B T Drop-Temp-TN-Temp Te R';
2232 BEGIN;
2233 INSERT INTO tt_xx_1() VALUES (1);
2234 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
2235 INSERT INTO tt_error_1() VALUES (13), (13);
2236 ERROR 23000: Duplicate entry '13' for key 'PRIMARY'
2237 ROLLBACK;
2238 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2239 include/show_binlog_events.inc
2240 Log_name Pos Event_type Server_id End_log_pos Info
2241 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2242 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2243 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2244 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2245 master-bin.000001 # Query # # ROLLBACK
2246 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2247
2248 SET @commands= 'B T N-Temp Te R';
2249 BEGIN;
2250 INSERT INTO tt_xx_1() VALUES (1);
2251 INSERT INTO nt_tmp_xx_1() VALUES (1);
2252 INSERT INTO tt_error_1() VALUES (14), (14);
2253 ERROR 23000: Duplicate entry '14' for key 'PRIMARY'
2254 ROLLBACK;
2255 Warnings:
2256 Warning # Some non-transactional changed tables couldn't be rolled back
2257 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2258 include/show_binlog_events.inc
2259 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2260
2261 # Non-transactional side effects.
2262 SET @commands= 'B T N-Temp Te Ne C';
2263 BEGIN;
2264 INSERT INTO tt_xx_1() VALUES (1);
2265 INSERT INTO nt_tmp_xx_1() VALUES (1);
2266 INSERT INTO tt_error_1() VALUES (15), (15);
2267 ERROR 23000: Duplicate entry '15' for key 'PRIMARY'
2268 INSERT INTO nt_error_1() VALUES (13), (13);
2269 ERROR 23000: Duplicate entry '13' for key 'PRIMARY'
2270 COMMIT;
2271 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te Ne C << -b-b-b-b-b-b-b-b-b-b-b-
2272 include/show_binlog_events.inc
2273 Log_name Pos Event_type Server_id End_log_pos Info
2274 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2275 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (13), (13)
2276 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
2277 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2278 master-bin.000001 # Query # # COMMIT
2279 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2280 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2281 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2282 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2283 master-bin.000001 # Xid # # COMMIT /* XID */
2284 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te Ne C << -e-e-e-e-e-e-e-e-e-e-e-
2285
2286 SET @commands= 'B T N-Temp Te Ne R';
2287 BEGIN;
2288 INSERT INTO tt_xx_1() VALUES (1);
2289 INSERT INTO nt_tmp_xx_1() VALUES (1);
2290 INSERT INTO tt_error_1() VALUES (16), (16);
2291 ERROR 23000: Duplicate entry '16' for key 'PRIMARY'
2292 INSERT INTO nt_error_1() VALUES (14), (14);
2293 ERROR 23000: Duplicate entry '14' for key 'PRIMARY'
2294 ROLLBACK;
2295 Warnings:
2296 Warning # Some non-transactional changed tables couldn't be rolled back
2297 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te Ne R << -b-b-b-b-b-b-b-b-b-b-b-
2298 include/show_binlog_events.inc
2299 Log_name Pos Event_type Server_id End_log_pos Info
2300 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2301 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (14), (14)
2302 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
2303 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2304 master-bin.000001 # Query # # COMMIT
2305 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te Ne R << -e-e-e-e-e-e-e-e-e-e-e-
2306
2307 SET @@session.binlog_direct_non_transactional_updates = OFF;
2308 SET @commands= 'B T Drop-Temp-TT-Temp Te C';
2309 BEGIN;
2310 INSERT INTO tt_xx_1() VALUES (1);
2311 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
2312 INSERT INTO tt_error_1() VALUES (17), (17);
2313 ERROR 23000: Duplicate entry '17' for key 'PRIMARY'
2314 COMMIT;
2315 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2316 include/show_binlog_events.inc
2317 Log_name Pos Event_type Server_id End_log_pos Info
2318 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2319 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2320 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2321 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2322 master-bin.000001 # Xid # # COMMIT /* XID */
2323 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2324
2325 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te C';
2326 DROP TEMPORARY TABLE tt_tmp_2;
2327 BEGIN;
2328 INSERT INTO tt_xx_1() VALUES (1);
2329 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
2330 INSERT INTO tt_error_1() VALUES (18), (18);
2331 ERROR 23000: Duplicate entry '18' for key 'PRIMARY'
2332 COMMIT;
2333 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-T-Temp B T Create-T-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2334 include/show_binlog_events.inc
2335 Log_name Pos Event_type Server_id End_log_pos Info
2336 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2337 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2338 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2339 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2340 master-bin.000001 # Xid # # COMMIT /* XID */
2341 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-T-Temp B T Create-T-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2342
2343 SET @commands= 'B T Drop-Temp-TN-Temp Te C';
2344 BEGIN;
2345 INSERT INTO tt_xx_1() VALUES (1);
2346 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
2347 INSERT INTO tt_error_1() VALUES (19), (19);
2348 ERROR 23000: Duplicate entry '19' for key 'PRIMARY'
2349 COMMIT;
2350 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2351 include/show_binlog_events.inc
2352 Log_name Pos Event_type Server_id End_log_pos Info
2353 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2354 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2355 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2356 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2357 master-bin.000001 # Xid # # COMMIT /* XID */
2358 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2359
2360 SET @commands= 'B T N-Temp Te C';
2361 BEGIN;
2362 INSERT INTO tt_xx_1() VALUES (1);
2363 INSERT INTO nt_tmp_xx_1() VALUES (1);
2364 INSERT INTO tt_error_1() VALUES (20), (20);
2365 ERROR 23000: Duplicate entry '20' for key 'PRIMARY'
2366 COMMIT;
2367 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te C << -b-b-b-b-b-b-b-b-b-b-b-
2368 include/show_binlog_events.inc
2369 Log_name Pos Event_type Server_id End_log_pos Info
2370 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2371 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2372 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2373 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2374 master-bin.000001 # Xid # # COMMIT /* XID */
2375 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te C << -e-e-e-e-e-e-e-e-e-e-e-
2376
2377 SET @commands= 'B T Drop-Temp-TT-Temp Te R';
2378 BEGIN;
2379 INSERT INTO tt_xx_1() VALUES (1);
2380 DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2;
2381 INSERT INTO tt_error_1() VALUES (21), (21);
2382 ERROR 23000: Duplicate entry '21' for key 'PRIMARY'
2383 ROLLBACK;
2384 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TT-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2385 include/show_binlog_events.inc
2386 Log_name Pos Event_type Server_id End_log_pos Info
2387 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2388 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2389 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2390 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2391 master-bin.000001 # Query # # ROLLBACK
2392 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TT-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2393
2394 SET @commands= 'Drop-Temp-T-Temp B T Create-T-Temp Te R';
2395 DROP TEMPORARY TABLE tt_tmp_2;
2396 BEGIN;
2397 INSERT INTO tt_xx_1() VALUES (1);
2398 CREATE TEMPORARY TABLE tt_tmp_2 ( id INT ) engine= Innodb;
2399 INSERT INTO tt_error_1() VALUES (22), (22);
2400 ERROR 23000: Duplicate entry '22' for key 'PRIMARY'
2401 ROLLBACK;
2402 -b-b-b-b-b-b-b-b-b-b-b- >> Drop-Temp-T-Temp B T Create-T-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2403 include/show_binlog_events.inc
2404 Log_name Pos Event_type Server_id End_log_pos Info
2405 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2406 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2407 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2408 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2409 master-bin.000001 # Query # # ROLLBACK
2410 -e-e-e-e-e-e-e-e-e-e-e- >> Drop-Temp-T-Temp B T Create-T-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2411
2412 SET @commands= 'B T Drop-Temp-TN-Temp Te R';
2413 BEGIN;
2414 INSERT INTO tt_xx_1() VALUES (1);
2415 DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2;
2416 INSERT INTO tt_error_1() VALUES (23), (23);
2417 ERROR 23000: Duplicate entry '23' for key 'PRIMARY'
2418 ROLLBACK;
2419 -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-Temp-TN-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2420 include/show_binlog_events.inc
2421 Log_name Pos Event_type Server_id End_log_pos Info
2422 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2423 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2424 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2425 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2426 master-bin.000001 # Query # # ROLLBACK
2427 -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-Temp-TN-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2428
2429 SET @commands= 'B T N-Temp Te R';
2430 BEGIN;
2431 INSERT INTO tt_xx_1() VALUES (1);
2432 INSERT INTO nt_tmp_xx_1() VALUES (1);
2433 INSERT INTO tt_error_1() VALUES (24), (24);
2434 ERROR 23000: Duplicate entry '24' for key 'PRIMARY'
2435 ROLLBACK;
2436 Warnings:
2437 Warning # Some non-transactional changed tables couldn't be rolled back
2438 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te R << -b-b-b-b-b-b-b-b-b-b-b-
2439 include/show_binlog_events.inc
2440 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te R << -e-e-e-e-e-e-e-e-e-e-e-
2441
2442 # Non-transactional side effects.
2443 SET @commands= 'B T N-Temp Te Ne C';
2444 BEGIN;
2445 INSERT INTO tt_xx_1() VALUES (1);
2446 INSERT INTO nt_tmp_xx_1() VALUES (1);
2447 INSERT INTO tt_error_1() VALUES (25), (25);
2448 ERROR 23000: Duplicate entry '25' for key 'PRIMARY'
2449 INSERT INTO nt_error_1() VALUES (15), (15);
2450 ERROR 23000: Duplicate entry '15' for key 'PRIMARY'
2451 COMMIT;
2452 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te Ne C << -b-b-b-b-b-b-b-b-b-b-b-
2453 include/show_binlog_events.inc
2454 Log_name Pos Event_type Server_id End_log_pos Info
2455 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2456 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (15), (15)
2457 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
2458 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2459 master-bin.000001 # Query # # COMMIT
2460 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2461 master-bin.000001 # Annotate_rows # # INSERT INTO tt_xx_1() VALUES (1)
2462 master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1)
2463 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2464 master-bin.000001 # Xid # # COMMIT /* XID */
2465 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te Ne C << -e-e-e-e-e-e-e-e-e-e-e-
2466
2467 SET @commands= 'B T N-Temp Te Ne R';
2468 BEGIN;
2469 INSERT INTO tt_xx_1() VALUES (1);
2470 INSERT INTO nt_tmp_xx_1() VALUES (1);
2471 INSERT INTO tt_error_1() VALUES (26), (26);
2472 ERROR 23000: Duplicate entry '26' for key 'PRIMARY'
2473 INSERT INTO nt_error_1() VALUES (16), (16);
2474 ERROR 23000: Duplicate entry '16' for key 'PRIMARY'
2475 ROLLBACK;
2476 Warnings:
2477 Warning # Some non-transactional changed tables couldn't be rolled back
2478 -b-b-b-b-b-b-b-b-b-b-b- >> B T N-Temp Te Ne R << -b-b-b-b-b-b-b-b-b-b-b-
2479 include/show_binlog_events.inc
2480 Log_name Pos Event_type Server_id End_log_pos Info
2481 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
2482 master-bin.000001 # Annotate_rows # # INSERT INTO nt_error_1() VALUES (16), (16)
2483 master-bin.000001 # Table_map # # table_id: # (test.nt_error_1)
2484 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
2485 master-bin.000001 # Query # # COMMIT
2486 -e-e-e-e-e-e-e-e-e-e-e- >> B T N-Temp Te Ne R << -e-e-e-e-e-e-e-e-e-e-e-
2487
2488 SET @@session.binlog_direct_non_transactional_updates = @sav_var;
2489 # < MDEV-26833
2490 ###################################################################################
2491 # CHECK CONSISTENCY
2492 ###################################################################################
2493 connection master;
2494 connection slave;
2495 #########################################################################
2496 # CLEAN
2497 #########################################################################
2498 SET @commands= 'clean';
2499 connection master;
2500 DROP TABLE IF EXISTS tt_xx_1;
2501 DROP TABLE IF EXISTS nt_xx_1;
2502 DROP TABLE IF EXISTS tt_error_1;
2503 DROP TABLE IF EXISTS nt_error_1;
2504 DROP TABLE IF EXISTS tt_error_2;
2505 DROP TABLE IF EXISTS nt_error_2;
2506 DROP TEMPORARY TABLE IF EXISTS tt_tmp_xx_1;
2507 DROP TEMPORARY TABLE IF EXISTS nt_tmp_xx_1;
2508 DROP TABLE IF EXISTS nt_2;
2509 DROP TEMPORARY TABLE IF EXISTS tt_tmp_2;
2510 DROP TEMPORARY TABLE IF EXISTS nt_tmp_2;
2511 DROP TABLE IF EXISTS nt_1;
2512 DROP TEMPORARY TABLE IF EXISTS tt_tmp_1;
2513 DROP TEMPORARY TABLE IF EXISTS nt_tmp_1;
2514 DROP TABLE IF EXISTS tt_2;
2515 DROP TABLE IF EXISTS tt_1;
2516 connection slave;
2517 SET @commands= '';
2518 include/rpl_end.inc