76
76
Note 1051 Unknown table 'tt_xx_1'
77
77
-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-
78
78
Log_name Pos Event_type Server_id End_log_pos Info
79
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
79
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
80
80
-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-
82
82
SET @commands= 'Drop-Temp-TXe-Temp';
93
93
Note 1051 Unknown table 'tt_1'
94
94
-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-
95
95
Log_name Pos Event_type Server_id End_log_pos Info
96
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
96
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
97
97
-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-
99
99
SET @commands= 'Drop-Temp-NXe-Temp';
110
110
Note 1051 Unknown table 'tt_1'
111
111
-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-
112
112
Log_name Pos Event_type Server_id End_log_pos Info
113
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
114
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
113
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
114
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
115
115
-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-
117
117
SET @commands= 'Drop-Temp-TN-Temp';
253
253
Log_name Pos Event_type Server_id End_log_pos Info
254
254
master-bin.000001 # Query # # BEGIN
255
255
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
256
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
256
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
257
257
master-bin.000001 # Xid # # COMMIT /* XID */
258
258
-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-
275
275
master-bin.000001 # Query # # COMMIT
276
276
master-bin.000001 # Query # # BEGIN
277
277
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
278
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
279
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
278
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
279
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
280
280
master-bin.000001 # Xid # # COMMIT /* XID */
281
281
-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-
326
326
Log_name Pos Event_type Server_id End_log_pos Info
327
327
master-bin.000001 # Query # # BEGIN
328
328
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
329
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
329
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
330
330
master-bin.000001 # Xid # # COMMIT /* XID */
331
331
-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-
348
348
master-bin.000001 # Query # # COMMIT
349
349
master-bin.000001 # Query # # BEGIN
350
350
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
351
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
352
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */
351
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
352
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_1` /* generated by server */
353
353
master-bin.000001 # Xid # # COMMIT /* XID */
354
354
-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-
404
404
-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-
405
405
Log_name Pos Event_type Server_id End_log_pos Info
406
406
master-bin.000001 # Query # # BEGIN
407
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
407
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
408
408
master-bin.000001 # Query # # COMMIT
409
409
master-bin.000001 # Query # # BEGIN
410
410
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
411
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
411
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
412
412
master-bin.000001 # Xid # # COMMIT /* XID */
413
413
-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-
426
426
-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-
427
427
Log_name Pos Event_type Server_id End_log_pos Info
428
428
master-bin.000001 # Query # # BEGIN
429
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
429
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
430
430
master-bin.000001 # Query # # COMMIT
431
431
master-bin.000001 # Query # # BEGIN
432
432
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
433
433
master-bin.000001 # Query # # COMMIT
434
434
master-bin.000001 # Query # # BEGIN
435
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
435
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
436
436
master-bin.000001 # Query # # COMMIT
437
437
master-bin.000001 # Query # # BEGIN
438
438
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
439
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
440
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
439
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
440
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
441
441
master-bin.000001 # Xid # # COMMIT /* XID */
442
442
-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-
669
669
Log_name Pos Event_type Server_id End_log_pos Info
670
670
master-bin.000001 # Query # # BEGIN
671
671
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
672
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
672
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
673
673
master-bin.000001 # Query # # ROLLBACK
674
674
-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-
693
693
master-bin.000001 # Query # # COMMIT
694
694
master-bin.000001 # Query # # BEGIN
695
695
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
696
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
697
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */
696
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
697
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_xx_1` /* generated by server */
698
698
master-bin.000001 # Query # # ROLLBACK
699
699
-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-
746
746
Log_name Pos Event_type Server_id End_log_pos Info
747
747
master-bin.000001 # Query # # BEGIN
748
748
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
749
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
749
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
750
750
master-bin.000001 # Query # # ROLLBACK
751
751
-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-
770
770
master-bin.000001 # Query # # COMMIT
771
771
master-bin.000001 # Query # # BEGIN
772
772
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
773
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */
774
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */
773
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_2`,`test`.`tt_1` /* generated by server */
774
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_tmp_1`,`test`.`tt_1` /* generated by server */
775
775
master-bin.000001 # Query # # ROLLBACK
776
776
-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-
828
828
-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-
829
829
Log_name Pos Event_type Server_id End_log_pos Info
830
830
master-bin.000001 # Query # # BEGIN
831
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
831
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
832
832
master-bin.000001 # Query # # COMMIT
833
833
master-bin.000001 # Query # # BEGIN
834
834
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
835
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
835
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
836
836
master-bin.000001 # Query # # ROLLBACK
837
837
-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-
852
852
-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-
853
853
Log_name Pos Event_type Server_id End_log_pos Info
854
854
master-bin.000001 # Query # # BEGIN
855
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */
855
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_2` /* generated by server */
856
856
master-bin.000001 # Query # # COMMIT
857
857
master-bin.000001 # Query # # BEGIN
858
858
master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1)
859
859
master-bin.000001 # Query # # COMMIT
860
860
master-bin.000001 # Query # # BEGIN
861
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */
861
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`nt_tmp_1` /* generated by server */
862
862
master-bin.000001 # Query # # COMMIT
863
863
master-bin.000001 # Query # # BEGIN
864
864
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
865
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
866
master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_1` /* generated by server */
865
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
866
master-bin.000001 # Query # # DROP TEMPORARY TABLE IF EXISTS `test`.`tt_1` /* generated by server */
867
867
master-bin.000001 # Query # # ROLLBACK
868
868
-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-