Debian Codegraph @

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