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