commit 0770651a532aa207a44a7848f13d0f8d98eac307 Author: Laurynas Biveinis Date: Tue Mar 21 06:54:31 2017 +0200 Fix bug 85258 / 1668602 (DROP TEMPORARY TABLE creates a transaction in binary log on read only server) The issue is that DROP TEMPORARY TABLE statements are logged pretty much unconditionally, regardless of binlog format and actual temporary table presence. Fix by logging only successful DROP TEMPORARY TABLE statements whose corresponding CREATE TEMPORARY TABLE statement has been logged too. Implement the fix by the following. - Only count those temporary tables whose DROPs are actually going to be binlogged in mysql_rm_table for ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP diagnostic. - In mysql_rm_table_no_locks: - split out the bool flags of trans/non_trans tmp tables deletes to flags of tables deleted and whether deletes have to be binloggeed - check whether the qualified table name in DROP has to be used in all cases instead of only if the current binlog format is row and IF EXISTS is given. - only build the DROP ... strings for the tables whose DROPs actually have to be binlogged because of binlog format at table create time. Update the testsuite for the above. Among other changes, rpl.rpl_row_drop test case becomes handled by existing rpl_ddl-including testcases, thus delete it. diff --git a/mysql-test/extra/binlog_tests/enforce_gtid_consistency_statement.inc b/mysql-test/extra/binlog_tests/enforce_gtid_consistency_statement.inc index dba16a6bec5..a579097a71d 100644 --- a/mysql-test/extra/binlog_tests/enforce_gtid_consistency_statement.inc +++ b/mysql-test/extra/binlog_tests/enforce_gtid_consistency_statement.inc @@ -236,7 +236,7 @@ if ($statement_ends_transaction_row_mixed != '') { --let $expect_end_transaction= $statement_ends_transaction_row_mixed } - --let $counter_expected_text= $statement_ends_transaction (stm) / $statement_ends_transaction_row_mixed (row) + --let $counter_expected_text= $statement_ends_transaction (stm) / $statement_ends_transaction_row_mixed (row / mix) if ($gtid_next == 'AUTOMATIC') { --let $automatic_counter_expected_text= $counter_expected_text diff --git a/mysql-test/extra/binlog_tests/enforce_gtid_consistency_tmp_violation.test b/mysql-test/extra/binlog_tests/enforce_gtid_consistency_tmp_violation.test index f5eed711b8a..43f79fb81d5 100644 --- a/mysql-test/extra/binlog_tests/enforce_gtid_consistency_tmp_violation.test +++ b/mysql-test/extra/binlog_tests/enforce_gtid_consistency_tmp_violation.test @@ -57,6 +57,7 @@ CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; --echo ---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- --let $statement_ends_transaction= 1 +--let $statement_ends_transaction_row_mixed= 0 CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; --let $pre_statement= BEGIN --let $statement= DROP TEMPORARY TABLE t1 @@ -72,6 +73,7 @@ SET AUTOCOMMIT = 1; --echo ---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- --let $statement_ends_transaction= 1 +--let $statement_ends_transaction_row_mixed= 0 CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; SET AUTOCOMMIT = 0; --let $statement= DROP TEMPORARY TABLE t1 diff --git a/mysql-test/extra/binlog_tests/logical_timestamping.inc b/mysql-test/extra/binlog_tests/logical_timestamping.inc index 40c068ebd35..fe854be65e4 100644 --- a/mysql-test/extra/binlog_tests/logical_timestamping.inc +++ b/mysql-test/extra/binlog_tests/logical_timestamping.inc @@ -209,8 +209,9 @@ CREATE TEMPORARY TABLE tti1 (a INT) ENGINE=Innodb; DROP TABLE tm,t1,ttm1,tti1; - ---let $logical_timestamps= 0 1;1 2;2 3 +--let $logical_timestamps= 0 1;1 2;2 3;3 4;4 5 +# CREATE/DROP TEMPORARY TABLE is not binlogged under MIXED +--let $logical_timestamps_mix= 0 1 --source include/assert_logical_timestamps.inc # diff --git a/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables.inc b/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables.inc index 18c18765738..b5b9aaa8d77 100644 --- a/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables.inc +++ b/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables.inc @@ -12,7 +12,6 @@ # --let $table_list= TABLE_LIST # --let $remaining_table_list= TABLE_LIST # --let $automatic= [0|1] -# --let $expect_slave_error= [0|1] # --let $transaction_count= N # --source include/rpl_gtid_drop_multiple_tables.inc # @@ -45,14 +44,6 @@ # GTID_NEXT='UUID:NUMBER' (if gtid_mode=on) or # GTID_NEXT='ANONYMOUS' (if gtid_mode=off). # -# $expect_slave_error -# By default, this script assumes the statement executes the same -# way on master and slave. It assumes that that the statement is -# split, and thus asserts that it fails on master if GTID_MODE=ON -# and $automatic=0; otherwise it succeeds on master. If this -# variable is 1, the script instead asserts that the statement -# succeeds on master and fails on slave. -# # $transaction_count # The number of transactions that the DROP statement is expected # to generate. @@ -121,40 +112,14 @@ if ($expect_error) --let $dont_print_pattern= 1 --source include/assert_binlog_events.inc - -if ($expect_slave_error) +# Drop remaining tables. +if ($remaining_table_list) { - --connection slave - --let $slave_sql_errno= convert_error(ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP) - --source include/wait_for_slave_sql_error.inc - - --source include/rpl_skip_to_end_of_relay_log.inc - - # Drop temp tables. - --source include/stop_slave.inc - RESET SLAVE; - --source include/start_slave.inc - - # Drop base table. - if ($remaining_table_list != 'base') - { - eval DROP TABLE base; - } - --connection master - - eval DROP TABLE IF EXISTS base, temp_t, temp_n; + eval DROP TABLE $remaining_table_list; } -if (!$expect_slave_error) +if ($expect_error) { - # Drop remaining tables. - if ($remaining_table_list) - { - eval DROP TABLE $remaining_table_list; - } - if ($expect_error) - { - eval DROP TABLE $table_list; - } + eval DROP TABLE $table_list; } --source include/rpl_sync.inc diff --git a/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc b/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc index 506f17f8db8..9298ac22533 100644 --- a/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc +++ b/mysql-test/extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc @@ -12,7 +12,6 @@ # CREATE PROCEDURE drop_tables () BEGIN ... END; # --let $automatic= [0|1] # --let $transaction_count= N -# --let $expect_slave_error= 1 # --source extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc # # Parameters: see extra/rpl_tests/rpl_drop_multiple_tables.inc. diff --git a/mysql-test/extra/rpl_tests/rpl_drop_temp.test b/mysql-test/extra/rpl_tests/rpl_drop_temp.test index 36476c8d799..67f831d8892 100644 --- a/mysql-test/extra/rpl_tests/rpl_drop_temp.test +++ b/mysql-test/extra/rpl_tests/rpl_drop_temp.test @@ -39,10 +39,9 @@ drop database mysqltest; sync_slave_with_master; # -# Bug#49137 -# This test verifies if DROP MULTI TEMPORARY TABLE -# will cause different errors on master and slave, -# when one or more of these tables do not exist. +# This test verifies if DROP MULTI TEMPORARY TABLE +# will be binlogged correctly when one or more of +# these tables do not exist. # connection master; @@ -64,7 +63,6 @@ CREATE TEMPORARY TABLE tmp3 (a int); DROP TEMPORARY TABLE tmp3; connection slave; -SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; connection master; diff --git a/mysql-test/suite/rpl_gtid/t/rpl_gtid_drop_table.test b/mysql-test/extra/rpl_tests/rpl_gtid_drop_table.test similarity index 73% rename from mysql-test/suite/rpl_gtid/t/rpl_gtid_drop_table.test rename to mysql-test/extra/rpl_tests/rpl_gtid_drop_table.test index d983aae062c..e489682f5a6 100644 --- a/mysql-test/suite/rpl_gtid/t/rpl_gtid_drop_table.test +++ b/mysql-test/extra/rpl_tests/rpl_gtid_drop_table.test @@ -37,6 +37,13 @@ --source include/have_innodb.inc --source include/have_myisam.inc +# Create two regular tables and two temporary tables with distinct storage engines +--source include/rpl_connection_master.inc +CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM; +CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; + --echo # --echo # First part --echo # @@ -46,6 +53,9 @@ # GTID_NEXT to a specific GTID and then trying to issue a DROP TABLE # statement containing the combinations of at least two tables. # +# This part only applies to statement binary log format, as otherwise temporary +# table operations are completely invisible to the binary log. +# # As DROP statements with both regular and temporary tables or with # transactional and non transactional temporary tables are split before # sending to binlog, the following DROP statements must return an error to the @@ -76,83 +86,80 @@ # ER_BAD_TABLE_ERROR cases, the existent tables will be dropped regardless the # error. -# Create two regular tables and two temporary tables with distinct storage engines ---source include/rpl_connection_master.inc -CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB; -CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM; -CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; -CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; +--let $binlog_format= `SELECT @@GLOBAL.binlog_format` +if ($binlog_format == "STATEMENT") +{ + --echo # Error cases ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP + --let $next_gtid= '11111111-1111-1111-1111-111111111111:1' + --let $expected_error= ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP ---echo # Error cases ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP ---let $next_gtid= '11111111-1111-1111-1111-111111111111:1' ---let $expected_error= ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP - -# reg trans + reg non trans + temp trans ---let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + reg non trans + temp trans + temp non trans ---let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, temp_non_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + reg non trans + temp trans + temp non trans + inexistent ---let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + reg non trans + temp trans + inexistent ---let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + reg non trans + temp non trans ---let $statement= DROP TABLE trans_t1, non_trans_t1, temp_non_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + reg non trans + temp non trans + inexistent ---let $statement= DROP TABLE trans_t1, non_trans_t1, temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + temp trans ---let $statement= DROP TABLE trans_t1, temp_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + temp trans + temp non trans ---let $statement= DROP TABLE trans_t1, temp_trans_t1, temp_non_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + temp trans + temp non trans + inexistent ---let $statement= DROP TABLE trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + temp trans + inexistent ---let $statement= DROP TABLE trans_t1, temp_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + temp non trans ---let $statement= DROP TABLE trans_t1, temp_non_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg trans + temp non trans + inexistent ---let $statement= DROP TABLE trans_t1, temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg non trans + temp trans ---let $statement= DROP TABLE non_trans_t1, temp_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg non trans + temp trans + temp non trans ---let $statement= DROP TABLE non_trans_t1, temp_trans_t1, temp_non_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg non trans + temp trans + temp non trans + inexistent ---let $statement= DROP TABLE non_trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg non trans + temp trans + inexistent ---let $statement= DROP TABLE non_trans_t1, temp_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg non trans + temp non trans ---let $statement= DROP TABLE non_trans_t1, temp_non_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# reg non trans + temp non trans + inexistent ---let $statement= DROP TABLE non_trans_t1, temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# temp trans + temp non trans ---let $statement= DROP TABLE temp_trans_t1, temp_non_trans_t1 ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# temp trans + temp non trans + inexistent ---let $statement= DROP TABLE temp_trans_t1, temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# temp trans + inexistent ---let $statement= DROP TABLE temp_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc -# temp non trans + inexistent ---let $statement= DROP TABLE temp_non_trans_t1, non_existent ---source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + reg non trans + temp trans + --let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + reg non trans + temp trans + temp non trans + --let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, temp_non_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + reg non trans + temp trans + temp non trans + inexistent + --let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + reg non trans + temp trans + inexistent + --let $statement= DROP TABLE trans_t1, non_trans_t1, temp_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + reg non trans + temp non trans + --let $statement= DROP TABLE trans_t1, non_trans_t1, temp_non_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + reg non trans + temp non trans + inexistent + --let $statement= DROP TABLE trans_t1, non_trans_t1, temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + temp trans + --let $statement= DROP TABLE trans_t1, temp_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + temp trans + temp non trans + --let $statement= DROP TABLE trans_t1, temp_trans_t1, temp_non_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + temp trans + temp non trans + inexistent + --let $statement= DROP TABLE trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + temp trans + inexistent + --let $statement= DROP TABLE trans_t1, temp_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + temp non trans + --let $statement= DROP TABLE trans_t1, temp_non_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg trans + temp non trans + inexistent + --let $statement= DROP TABLE trans_t1, temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg non trans + temp trans + --let $statement= DROP TABLE non_trans_t1, temp_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg non trans + temp trans + temp non trans + --let $statement= DROP TABLE non_trans_t1, temp_trans_t1, temp_non_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg non trans + temp trans + temp non trans + inexistent + --let $statement= DROP TABLE non_trans_t1, temp_trans_t1, temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg non trans + temp trans + inexistent + --let $statement= DROP TABLE non_trans_t1, temp_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg non trans + temp non trans + --let $statement= DROP TABLE non_trans_t1, temp_non_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # reg non trans + temp non trans + inexistent + --let $statement= DROP TABLE non_trans_t1, temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # temp trans + temp non trans + --let $statement= DROP TABLE temp_trans_t1, temp_non_trans_t1 + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # temp trans + temp non trans + inexistent + --let $statement= DROP TABLE temp_trans_t1, temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # temp trans + inexistent + --let $statement= DROP TABLE temp_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc + # temp non trans + inexistent + --let $statement= DROP TABLE temp_non_trans_t1, non_existent + --source extra/rpl_tests/rpl_gtid_drop_table.inc +} --echo # Error cases ER_BAD_TABLE_ERROR --let $expected_error= ER_BAD_TABLE_ERROR diff --git a/mysql-test/extra/rpl_tests/rpl_implicit_commit_binlog.test b/mysql-test/extra/rpl_tests/rpl_implicit_commit_binlog.test index baec7377d34..bdf72076b95 100644 --- a/mysql-test/extra/rpl_tests/rpl_implicit_commit_binlog.test +++ b/mysql-test/extra/rpl_tests/rpl_implicit_commit_binlog.test @@ -542,10 +542,8 @@ while ($ddl_cases >= 1) let $cmd= DROP TEMPORARY TABLE IF EXISTS new_tt_xx; let $in_temporary= yes; # - # In SBR and MIXED modes, the DDL statement is written to the binary log - # but does not commit the current transaction: - # - # In SBR, we have what follows: + # In SBR mode, the DDL statement is written to the binary log but does + # not commit the current transaction: # # 1: GTID # 2: BEGIN @@ -553,43 +551,33 @@ while ($ddl_cases >= 1) # 4: DROP TEMPORARY # 5: COMMIT # - # In RBR the transaction is not committed either and the statement is not - # written to the binary log: + # In RBR and MIXED modes, the transaction is not committed either and + # the statement is not written to the binary log: # + # RBR: # 1: GTID # 2: BEGIN # 3: TABLE MAP EVENT # 4: ROW EVENT # 5: COMMIT # + # MIXED: + # 1: GTID + # 2: BEGIN + # 3: ROW EVENT + # 4: COMMIT + # if (`select @@binlog_format = 'STATEMENT'`) { let $commit_event_row_number= 5; } - # In ROW mode, the changes are logged as rows and we have what follows: - # - # 1: GTID - # 2: BEGIN - # 3: TABLE MAP EVENT - # 4: ROW EVENT - # 5: DROP TEMPORARY table IF EXISTS - # 6: COMMIT - # if (`select @@binlog_format = 'ROW'`) { - let $commit_event_row_number= 6; + let $commit_event_row_number= 5; } - # In MIXED mode, the changes are logged as rows and we have what follows: - # - # 1: GTID - # 2: BEGIN - # 2: ROW EVENT - # 3: DROP TEMPORARY table IF EXISTS - # 4: COMMIT - # if (`select @@binlog_format = 'MIXED'`) { - let $commit_event_row_number= 5; + let $commit_event_row_number= 4; } # diff --git a/mysql-test/extra/rpl_tests/rpl_innodb.test b/mysql-test/extra/rpl_tests/rpl_innodb.test index ea05ad0ac4d..313161d8ce7 100644 --- a/mysql-test/extra/rpl_tests/rpl_innodb.test +++ b/mysql-test/extra/rpl_tests/rpl_innodb.test @@ -71,8 +71,8 @@ sync_slave_with_master; connection slave; # We want to verify that the following transactions are written to the -# binlog, despite the transaction is rolled back. (They should be -# written to the binlog since they contain non-transactional DROP +# binlog in SBR, despite the transaction is rolled back. (They should be +# written to the binlog since they contain non-transactional CREATE # TEMPORARY TABLE). To see that, we use the auxiliary table t1, which # is transactional (InnoDB) on master and MyISAM on slave. t1 should # be transactional on master so that the insert into t1 does not cause @@ -108,12 +108,8 @@ connection slave; SHOW CREATE TABLE mysqltest1.tmp; --error ER_NO_SUCH_TABLE SHOW CREATE TABLE mysqltest1.tmp2; -# Aa a result of the bugfix for 72475, t1 has one row here since the -# CREATE TEMPORARY TABLE tmp2 above is not binlogged and thus changes the -# transactional/non-transactional logic, causing the INSERT f1=2 to not be bilogged -# on ROLLBACK --echo ######### for SBR, t1 has two rows here: the transaction not rolled back since t1 uses MyISAM ######### ---echo ######### for MBR, t1 has one row here: the transaction not rolled back since t1 uses MyISAM ######### +--echo ######### for MBR, t1 has zero rows here, as CREATE/DROP TEMPORARY TABLE were not binlogged ######### SELECT COUNT(*) FROM mysqltest1.t1; FLUSH LOGS; diff --git a/mysql-test/extra/rpl_tests/rpl_split_statements.test b/mysql-test/extra/rpl_tests/rpl_split_statements.test index 464e7e38b9d..5ad1270a897 100644 --- a/mysql-test/extra/rpl_tests/rpl_split_statements.test +++ b/mysql-test/extra/rpl_tests/rpl_split_statements.test @@ -35,9 +35,9 @@ # # 2. DROP TABLE: when a single statement drops multiple tables, then # there will be a separate statement for all dropped non-temporary -# tables, a separate statement for all dropped transactional -# temporary tables, and a separate statement for all dropped -# non-transactional tables. +# tables, with statement binlog format a separate statement for all +# dropped transactional temporary tables, and a separate statement +# for all dropped non-transactional tables. # # 3. DROP DATABASE: this statement will first drop all non-temporary # tables in the database, and then try to remove the database @@ -272,10 +272,6 @@ END| --echo ---- GTID_MODE=AUTOMATIC ---- --let $automatic= 1 -if ($gtid_mode_on) -{ - --let $expect_slave_error= 1 -} --let $transaction_count= 1 --source extra/rpl_tests/rpl_drop_multiple_tables_in_multiple_ways.inc diff --git a/mysql-test/include/assert_logical_timestamps.inc b/mysql-test/include/assert_logical_timestamps.inc index 9cf9213dcf8..6c5176ecd4e 100644 --- a/mysql-test/include/assert_logical_timestamps.inc +++ b/mysql-test/include/assert_logical_timestamps.inc @@ -8,6 +8,7 @@ # --let $binlog_file= FILENAME # [--let $binlog_position= OFFSET] # --let $logical_timestamps= LC1 SN1[;LC2 SN2[;LC3 SN3...]] +# [--let $logical_timestamps_mix= LC1 SN1[;LC2 SN2[;LC3 SN3...]]] # --source include/assert_logical_timestamps.inc # # Parameters: @@ -26,11 +27,32 @@ # integer. Note that this is whitespace-sensitive so there should # not be any other space characters than those separating # last_committed from sequence_number. +# +# $logical_timestamps_mix +# This is an optional list to be used instead of $logical_timestamps +# if the current binlog format is mixed. It is reset at the endo of +# this include file. ---let $include_filename= include/assert_logical_timestamps.inc [$logical_timestamps] +if ($logical_timestamps_mix == '') +{ + --let $include_filename= include/assert_logical_timestamps.inc [$logical_timestamps] +} +if ($logical_timestamps_mix != '') +{ + --let $include_filename= include/assert_logical_timestamps.inc [logical_timestamps=$logical_timestamps logical_timestamps_mix=$logical_timestamps_mix] +} --source include/begin_include_file.inc +--let $expected_logical_timestamps= $logical_timestamps +if ($logical_timestamps_mix != '') +{ + --let $binlog_format= `SELECT @@GLOBAL.binlog_format` + if ($binlog_format == 'MIXED') + { + --let $expected_logical_timestamps= $logical_timestamps_mix + } +} --let $assert_file= `SELECT CONCAT('$MYSQLTEST_VARDIR/tmp/_alt_', UUID())` @@ -45,13 +67,14 @@ if ($binlog_position) # Check for match. --let $assert_select= last_committed=.*sequence_number=.* ---let $assert_match= `SELECT CONCAT('^[^\n]*last_committed=', REPLACE(REPLACE('$logical_timestamps', ';', '\n[^\n]*last_committed='), ' ', '\tsequence_number='), CHAR(36))` ---let $assert_text= assert_logical_timestamps: $logical_timestamps ---let $extra_debug_info= Expected logical timestamps: $logical_timestamps +--let $assert_match= `SELECT CONCAT('^[^\n]*last_committed=', REPLACE(REPLACE('$expected_logical_timestamps', ';', '\n[^\n]*last_committed='), ' ', '\tsequence_number='), CHAR(36))` +--let $assert_text= assert_logical_timestamps: $expected_logical_timestamps +--let $extra_debug_info= Expected logical timestamps: $expected_logical_timestamps --source include/assert_grep.inc --remove_file $assert_file +--let $logical_timestamps_mix= ---let $include_filename= include/assert_logical_timestamps.inc [$logical_timestamps] +--let $include_filename= include/assert_logical_timestamps.inc [logical_timestamps=$logical_timestamps logical_timestamps_mix=$logical_timestamps_mix] --source include/end_include_file.inc diff --git a/mysql-test/suite/binlog/r/binlog_database.result b/mysql-test/suite/binlog/r/binlog_database.result index 028ae97146a..bdc8b934887 100644 --- a/mysql-test/suite/binlog/r/binlog_database.result +++ b/mysql-test/suite/binlog/r/binlog_database.result @@ -119,7 +119,6 @@ master-bin.000001 # Query # # drop database if exists mysqltest1 master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; insert into t1 values (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt1` /* generated by server */ master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ FLUSH STATUS; @@ -204,7 +203,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.t1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt1` /* generated by server */ master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ FLUSH STATUS; diff --git a/mysql-test/suite/binlog/r/binlog_innodb_row.result b/mysql-test/suite/binlog/r/binlog_innodb_row.result index ad1e98b7aea..cf42bd1c9df 100644 --- a/mysql-test/suite/binlog/r/binlog_innodb_row.result +++ b/mysql-test/suite/binlog/r/binlog_innodb_row.result @@ -57,7 +57,6 @@ DROP TEMPORARY TABLE t1; ############################################### include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t1` /* generated by server */ ############################################### # # Bug#12346411 SQL/LOG.CC:6509: ASSERTION `PREPARED_XIDS > 0' FAILED diff --git a/mysql-test/suite/binlog/r/binlog_row_mix_drop_tmp_tbl.result b/mysql-test/suite/binlog/r/binlog_row_mix_drop_tmp_tbl.result index a3149fc4e95..649d8c6df77 100644 --- a/mysql-test/suite/binlog/r/binlog_row_mix_drop_tmp_tbl.result +++ b/mysql-test/suite/binlog/r/binlog_row_mix_drop_tmp_tbl.result @@ -27,11 +27,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # CREATE DATABASE `drop-temp+table-test` master-bin.000001 # Query # # use `drop-temp+table-test`; CREATE TABLE t(c1 int) -master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp` /* generated by server */ -master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp` /* generated by server */ -master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp1`,`tmp` /* generated by server */ -master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp3` /* generated by server */ -master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp2` /* generated by server */ master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TABLE IF EXISTS `t` /* generated by server */ master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TABLE IF EXISTS `tmp2`,`t` /* generated by server */ DROP DATABASE `drop-temp+table-test`; diff --git a/mysql-test/suite/binlog/r/binlog_stm_drop_tmp_tbl.result b/mysql-test/suite/binlog/r/binlog_stm_drop_tmp_tbl.result index 29901f869d3..91cbd2beb25 100644 --- a/mysql-test/suite/binlog/r/binlog_stm_drop_tmp_tbl.result +++ b/mysql-test/suite/binlog/r/binlog_stm_drop_tmp_tbl.result @@ -35,8 +35,7 @@ master-bin.000001 # Query # # use `drop-temp+table-test`; CREATE TEMPORARY TABLE master-bin.000001 # Query # # use `drop-temp+table-test`; CREATE TEMPORARY TABLE tmp3(c1 int) master-bin.000001 # Query # # use `drop-temp+table-test`; CREATE TABLE t(c1 int) master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp` /* generated by server */ -master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp` /* generated by server */ -master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp1`,`tmp` /* generated by server */ +master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp1` /* generated by server */ master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE `tmp3` /* generated by server */ master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp2` /* generated by server */ master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TABLE IF EXISTS `t` /* generated by server */ diff --git a/mysql-test/suite/binlog_gtid/r/binlog_mts_logical_clock_gtid.result b/mysql-test/suite/binlog_gtid/r/binlog_mts_logical_clock_gtid.result index ecae80c6a42..23ed97d98b6 100644 --- a/mysql-test/suite/binlog_gtid/r/binlog_mts_logical_clock_gtid.result +++ b/mysql-test/suite/binlog_gtid/r/binlog_mts_logical_clock_gtid.result @@ -72,4 +72,4 @@ CREATE TEMPORARY TABLE ttm1 (a INT) ENGINE=MyISAM; CREATE TEMPORARY TABLE tti1 (a INT) ENGINE=Innodb; *** The query is logged in three parts. DROP TABLE tm,t1,ttm1,tti1; -include/include/assert_logical_timestamps.inc [0 1;1 2;2 3] +include/include/assert_logical_timestamps.inc [logical_timestamps=0 1;1 2;2 3;3 4;4 5 logical_timestamps_mix=0 1] diff --git a/mysql-test/suite/binlog_nogtid/r/binlog_enforce_gtid_consistency_tmp_violation.result b/mysql-test/suite/binlog_nogtid/r/binlog_enforce_gtid_consistency_tmp_violation.result index 91712638680..8b22d667982 100644 --- a/mysql-test/suite/binlog_nogtid/r/binlog_enforce_gtid_consistency_tmp_violation.result +++ b/mysql-test/suite/binlog_nogtid/r/binlog_enforce_gtid_consistency_tmp_violation.result @@ -37,7 +37,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -74,7 +74,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -112,7 +112,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -149,7 +149,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -184,7 +184,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -219,7 +219,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -255,7 +255,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -290,7 +290,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -476,7 +476,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -511,7 +511,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -547,7 +547,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -582,7 +582,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -621,7 +621,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -656,7 +656,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -692,7 +692,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -727,7 +727,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -913,7 +913,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -948,7 +948,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -984,7 +984,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -1019,7 +1019,7 @@ include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -1058,7 +1058,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -1093,7 +1093,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -1129,7 +1129,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -1164,7 +1164,7 @@ include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be [END] DROP TEMPORARY TABLE t1; include/assert.inc [No warning or error should be generated.] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -1208,7 +1208,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1245,7 +1245,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1283,7 +1283,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1320,7 +1320,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1505,7 +1505,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1542,7 +1542,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1580,7 +1580,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1617,7 +1617,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1654,7 +1654,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -1691,7 +1691,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -1729,7 +1729,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -1766,7 +1766,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -1950,7 +1950,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -1987,7 +1987,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2025,7 +2025,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2062,7 +2062,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2099,7 +2099,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2136,7 +2136,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2174,7 +2174,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2211,7 +2211,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2395,7 +2395,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2432,7 +2432,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2470,7 +2470,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2507,7 +2507,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2544,7 +2544,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2581,7 +2581,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2619,7 +2619,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2656,7 +2656,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; include/assert.inc [Both counters should be 0] @@ -2695,7 +2695,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2732,7 +2732,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2770,7 +2770,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2807,7 +2807,7 @@ ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be an Error, not a Warning.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; SET GTID_NEXT = 'AUTOMATIC'; @@ -2850,7 +2850,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -2893,7 +2893,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -2937,7 +2937,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -2980,7 +2980,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -3174,7 +3174,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3217,7 +3217,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3261,7 +3261,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3304,7 +3304,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3351,7 +3351,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -3394,7 +3394,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -3438,7 +3438,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -3481,7 +3481,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -3675,7 +3675,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3718,7 +3718,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3762,7 +3762,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3805,7 +3805,7 @@ Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DRO include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] -include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] ROLLBACK; Warnings: @@ -3852,7 +3852,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -3895,7 +3895,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row)] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1751 The creation of some temporary tables could not be rolled back. @@ -3939,7 +3939,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. @@ -3982,7 +3982,7 @@ include/assert.inc [One warning/error should be generated.] include/assert.inc [It should be a Warning, not an Error.] include/assert.inc [Text should be "violates GTID consistency"] include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] -include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] +include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1 (stm) / 0 (row / mix)] ROLLBACK; Warnings: Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. diff --git a/mysql-test/suite/binlog_nogtid/r/binlog_mts_logical_clock.result b/mysql-test/suite/binlog_nogtid/r/binlog_mts_logical_clock.result index 26d8af913d5..a06b263396d 100644 --- a/mysql-test/suite/binlog_nogtid/r/binlog_mts_logical_clock.result +++ b/mysql-test/suite/binlog_nogtid/r/binlog_mts_logical_clock.result @@ -72,7 +72,7 @@ CREATE TEMPORARY TABLE ttm1 (a INT) ENGINE=MyISAM; CREATE TEMPORARY TABLE tti1 (a INT) ENGINE=Innodb; *** The query is logged in three parts. DROP TABLE tm,t1,ttm1,tti1; -include/include/assert_logical_timestamps.inc [0 1;1 2;2 3] +include/include/assert_logical_timestamps.inc [logical_timestamps=0 1;1 2;2 3;3 4;4 5 logical_timestamps_mix=0 1] CALL mtr.add_suppression("Some non-transactional changed tables couldn't be rolled back"); CREATE TABLE t1 (a int) ENGINE= innodb; CREATE TABLE tm (a int) ENGINE= MyISAM; diff --git a/mysql-test/suite/binlog_nogtid/r/binlog_row_binlog.result b/mysql-test/suite/binlog_nogtid/r/binlog_row_binlog.result index a22583c507b..b81f83223fb 100644 --- a/mysql-test/suite/binlog_nogtid/r/binlog_row_binlog.result +++ b/mysql-test/suite/binlog_nogtid/r/binlog_row_binlog.result @@ -559,7 +559,6 @@ COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2, COERCIBILITY(s1) d3; DROP TEMPORARY TABLE tmp1; END -master-bin.000001 # Query # # use `bug39182`; DROP TEMPORARY TABLE IF EXISTS `tmp1` /* generated by server */ DROP PROCEDURE p1; DROP TABLE t1; DROP DATABASE bug39182; diff --git a/mysql-test/suite/binlog_nogtid/r/binlog_row_mix_innodb_myisam.result b/mysql-test/suite/binlog_nogtid/r/binlog_row_mix_innodb_myisam.result index 829b5ecf940..7768ddea7ac 100644 --- a/mysql-test/suite/binlog_nogtid/r/binlog_row_mix_innodb_myisam.result +++ b/mysql-test/suite/binlog_nogtid/r/binlog_row_mix_innodb_myisam.result @@ -425,7 +425,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.t1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t2` /* generated by server */ master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ reset master; create table t1 (a int) engine=innodb; diff --git a/mysql-test/suite/binlog_nogtid/r/binlog_stm_binlog.result b/mysql-test/suite/binlog_nogtid/r/binlog_stm_binlog.result index 9d318f037c0..bfee47d8fe3 100644 --- a/mysql-test/suite/binlog_nogtid/r/binlog_stm_binlog.result +++ b/mysql-test/suite/binlog_nogtid/r/binlog_stm_binlog.result @@ -343,7 +343,6 @@ COERCIBILITY(NAME_CONST('s1', _utf8'test' COLLATE utf8_unicode_ci)) d2, COERCIBILITY(s1) d3; DROP TEMPORARY TABLE tmp1; END -master-bin.000001 # Query # # use `bug39182`; DROP TEMPORARY TABLE IF EXISTS `tmp1` /* generated by server */ DROP PROCEDURE p1; DROP TABLE t1; DROP DATABASE bug39182; diff --git a/mysql-test/suite/rpl/r/rpl_gtid_empty_transaction.result b/mysql-test/suite/rpl/r/rpl_gtid_empty_transaction.result index aeca1ece0e1..b2ce27cb4eb 100644 --- a/mysql-test/suite/rpl/r/rpl_gtid_empty_transaction.result +++ b/mysql-test/suite/rpl/r/rpl_gtid_empty_transaction.result @@ -26,7 +26,7 @@ CREATE TEMPORARY TABLE t_ignore_wild(a INT); ALTER TABLE t_ignore_wild ADD COLUMN b INT; INSERT INTO t_ignore_wild VALUES (1, 2); DROP TEMPORARY TABLE t_ignore_wild; -include/gtid_step_assert.inc [count=2, only_count=0] +include/gtid_step_assert.inc [count=0, only_count=0] include/rpl_sync.inc ==== Case 1C: database filters on slave applier ==== include/gtid_step_reset.inc diff --git a/mysql-test/suite/rpl/r/rpl_mix_innodb.result b/mysql-test/suite/rpl/r/rpl_mix_innodb.result index 1edf66a8f42..e5601ff5c32 100644 --- a/mysql-test/suite/rpl/r/rpl_mix_innodb.result +++ b/mysql-test/suite/rpl/r/rpl_mix_innodb.result @@ -80,10 +80,10 @@ ERROR 42S02: Table 'mysqltest1.tmp' doesn't exist SHOW CREATE TABLE mysqltest1.tmp2; ERROR 42S02: Table 'mysqltest1.tmp2' doesn't exist ######### for SBR, t1 has two rows here: the transaction not rolled back since t1 uses MyISAM ######### -######### for MBR, t1 has one row here: the transaction not rolled back since t1 uses MyISAM ######### +######### for MBR, t1 has zero rows here, as CREATE/DROP TEMPORARY TABLE were not binlogged ######### SELECT COUNT(*) FROM mysqltest1.t1; COUNT(*) -1 +0 FLUSH LOGS; -------- switch to master -------- FLUSH LOGS; diff --git a/mysql-test/suite/rpl/r/rpl_row_drop.result b/mysql-test/suite/rpl/r/rpl_row_drop.result deleted file mode 100644 index e5f11ba6250..00000000000 --- a/mysql-test/suite/rpl/r/rpl_row_drop.result +++ /dev/null @@ -1,62 +0,0 @@ -include/master-slave.inc -Warnings: -Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. -Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. -[connection master] -**** On Master **** -CREATE TABLE t1 (a int); -CREATE TABLE t2 (a int); -CREATE TEMPORARY TABLE t2 (a int, b int); -SHOW TABLES; -Tables_in_test -t1 -t2 -include/sync_slave_sql_with_master.inc -**** On Slave **** -SHOW TABLES; -Tables_in_test -t1 -t2 -**** On Master **** -DROP TABLE t2; -SHOW TABLES; -Tables_in_test -t1 -t2 -include/sync_slave_sql_with_master.inc -**** On Slave **** -SHOW TABLES; -Tables_in_test -t1 -t2 -**** On Master **** -CREATE TEMPORARY TABLE t2 (a int, b int); -SHOW TABLES; -Tables_in_test -t1 -t2 -include/sync_slave_sql_with_master.inc -**** On Slave **** -SHOW TABLES; -Tables_in_test -t1 -t2 -**** On Master **** -DROP TABLE t1,t2; -include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a int) -master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (a int) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */ -SHOW TABLES; -Tables_in_test -t2 -include/sync_slave_sql_with_master.inc -**** On Slave **** -SHOW TABLES; -Tables_in_test -t2 -include/sync_slave_sql_with_master.inc -include/rpl_end.inc diff --git a/mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.test b/mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.test index c5c098fbf00..e6dcbc0feb0 100644 --- a/mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.test +++ b/mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.test @@ -93,8 +93,8 @@ ALTER TABLE t_ignore_wild ADD COLUMN b INT; INSERT INTO t_ignore_wild VALUES (1, 2); DROP TEMPORARY TABLE t_ignore_wild; -# Verify that 2 GTIDs were generated. ---let $gtid_step_count= 2 +# Verify that 0 GTIDs were generated. +--let $gtid_step_count= 0 --source include/gtid_step_assert.inc # Verify that the GTIDs make it to every slave. diff --git a/mysql-test/suite/rpl/t/rpl_row_drop.test b/mysql-test/suite/rpl/t/rpl_row_drop.test deleted file mode 100644 index 6d911c56eb8..00000000000 --- a/mysql-test/suite/rpl/t/rpl_row_drop.test +++ /dev/null @@ -1,47 +0,0 @@ --- source include/not_group_replication_plugin.inc --- source include/have_binlog_format_row.inc --- source include/master-slave.inc - -# Bug#12415: DROP of temporary table on master stops slave -connection master; ---echo **** On Master **** -CREATE TABLE t1 (a int); -CREATE TABLE t2 (a int); -CREATE TEMPORARY TABLE t2 (a int, b int); -SHOW TABLES; ---source include/sync_slave_sql_with_master.inc ---echo **** On Slave **** -SHOW TABLES; -connection master; ---echo **** On Master **** -DROP TABLE t2; # Dropping the temporary table -SHOW TABLES; ---source include/sync_slave_sql_with_master.inc ---echo **** On Slave **** -SHOW TABLES; # There should be two tables on the slave - -connection master; ---echo **** On Master **** -CREATE TEMPORARY TABLE t2 (a int, b int); -SHOW TABLES; ---source include/sync_slave_sql_with_master.inc ---echo **** On Slave **** -SHOW TABLES; -connection master; ---echo **** On Master **** -# Should drop the non-temporary table t1 and the temporary table t2 -DROP TABLE t1,t2; -source include/show_binlog_events.inc; -SHOW TABLES; ---source include/sync_slave_sql_with_master.inc ---echo **** On Slave **** -SHOW TABLES; - ---disable_query_log ---disable_warnings -connection master; -DROP TABLE IF EXISTS t2; ---source include/sync_slave_sql_with_master.inc ---enable_warnings ---enable_query_log ---source include/rpl_end.inc diff --git a/mysql-test/suite/rpl_gtid/r/rpl_gtid_row_mix_drop_table.result b/mysql-test/suite/rpl_gtid/r/rpl_gtid_row_mix_drop_table.result new file mode 100644 index 00000000000..5005566e4c3 --- /dev/null +++ b/mysql-test/suite/rpl_gtid/r/rpl_gtid_row_mix_drop_table.result @@ -0,0 +1,95 @@ +include/rpl_init.inc [topology=1->2->3] +Warnings: +Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. +Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. +Warnings: +Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. +Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. +include/rpl_default_connections.inc +[connection master] +CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM; +CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; +# +# First part +# +# Error cases ER_BAD_TABLE_ERROR +SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1'; +## Expecting error ER_BAD_TABLE_ERROR after the statement +DROP TABLE trans_t1, non_trans_t1, non_existent; +ERROR 42S02: Unknown table 'test.non_existent' +ROLLBACK; +SET GTID_NEXT= AUTOMATIC; +CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB; +SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:2'; +## Expecting error ER_BAD_TABLE_ERROR after the statement +DROP TABLE trans_t1, non_existent; +ERROR 42S02: Unknown table 'test.non_existent' +ROLLBACK; +SET GTID_NEXT= AUTOMATIC; +CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM; +SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:3'; +## Expecting error ER_BAD_TABLE_ERROR after the statement +DROP TABLE non_trans_t1, non_existent; +ERROR 42S02: Unknown table 'test.non_existent' +ROLLBACK; +SET GTID_NEXT= AUTOMATIC; +CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM; +# Non-error cases +SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:4'; +DROP TABLE trans_t1, non_trans_t1; +SET GTID_NEXT= AUTOMATIC; +CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB; +# +# Second part +# +CREATE TEMPORARY TABLE temp_ignore (c1 INT) ENGINE=MyISAM; +DROP TEMPORARY TABLE IF EXISTS temp_ignore, temp_non_trans_t1; +include/sync_slave_sql_with_master.inc +[connection master] +CREATE TEMPORARY TABLE temp_ignore (c1 INT) ENGINE=InnoDB; +DROP TEMPORARY TABLE IF EXISTS temp_ignore, temp_trans_t1; +include/sync_slave_sql_with_master.inc +# +# Third part +# +[connection master] +SET SESSION sql_log_bin= 0; +call mtr.add_suppression("InnoDB: Error: table .* does not exist in the InnoDB internal"); +SET SESSION sql_log_bin= 1; +CREATE DATABASE test2; +CREATE DATABASE test3; +use test; +CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; +USE test2; +CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; +USE test3; +CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TEMPORARY TABLE temp_trans_t2 (c1 INT) ENGINE=InnoDB; +[connection master1] +use test; +CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; +CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; +USE test2; +CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; +USE test3; +CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; +CREATE TEMPORARY TABLE temp_non_trans_t2 (c1 INT) ENGINE=MyISAM; +include/sync_slave_sql_with_master.inc +include/stop_slave_io.inc +include/rpl_stop_server.inc [server_number=1] +include/rpl_start_server.inc [server_number=1] +[connection slave] +include/start_slave_io.inc +[connection master] +include/sync_slave_io_with_master.inc +include/assert.inc [Slave_open_temp_tables should be 0] +[connection master] +USE test; +DROP TABLE trans_t1; +DROP DATABASE test2; +DROP DATABASE test3; +include/rpl_end.inc diff --git a/mysql-test/suite/rpl_gtid/r/rpl_gtid_split_statements.result b/mysql-test/suite/rpl_gtid/r/rpl_gtid_split_statements.result index 5d16fc4a215..7e4a1f368b8 100644 --- a/mysql-test/suite/rpl_gtid/r/rpl_gtid_split_statements.result +++ b/mysql-test/suite/rpl_gtid/r/rpl_gtid_split_statements.result @@ -158,18 +158,7 @@ include/gtid_step_reset.inc DROP TABLE base, temp_t; include/gtid_step_assert.inc [count=1, only_count=0] include/assert_binlog_events.inc -include/wait_for_slave_sql_error.inc [errno=1884] -include/include/rpl_skip_to_end_of_relay_log.inc -include/stop_slave.inc -Warnings: -Warning 3022 This operation may not be safe when the slave has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until slave_open_temp_tables = 0. -RESET SLAVE; -include/start_slave.inc -DROP TABLE base; -DROP TABLE IF EXISTS base, temp_t, temp_n; -Warnings: -Note 1051 Unknown table 'test.base' -Note 1051 Unknown table 'test.temp_t' +DROP TABLE temp_n; include/rpl_sync.inc include/rpl_reset.inc CALL create_tables(); @@ -179,18 +168,7 @@ include/gtid_step_reset.inc DROP TABLE base, temp_n; include/gtid_step_assert.inc [count=1, only_count=0] include/assert_binlog_events.inc -include/wait_for_slave_sql_error.inc [errno=1884] -include/include/rpl_skip_to_end_of_relay_log.inc -include/stop_slave.inc -Warnings: -Warning 3022 This operation may not be safe when the slave has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until slave_open_temp_tables = 0. -RESET SLAVE; -include/start_slave.inc -DROP TABLE base; -DROP TABLE IF EXISTS base, temp_t, temp_n; -Warnings: -Note 1051 Unknown table 'test.base' -Note 1051 Unknown table 'test.temp_n' +DROP TABLE temp_t; include/rpl_sync.inc include/rpl_reset.inc CALL create_tables(); @@ -200,17 +178,7 @@ include/gtid_step_reset.inc DROP TABLE temp_t, temp_n; include/gtid_step_assert.inc [count=1, only_count=0] include/assert_binlog_events.inc -include/wait_for_slave_sql_error.inc [errno=1884] -include/include/rpl_skip_to_end_of_relay_log.inc -include/stop_slave.inc -Warnings: -Warning 3022 This operation may not be safe when the slave has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until slave_open_temp_tables = 0. -RESET SLAVE; -include/start_slave.inc -DROP TABLE IF EXISTS base, temp_t, temp_n; -Warnings: -Note 1051 Unknown table 'test.temp_t' -Note 1051 Unknown table 'test.temp_n' +DROP TABLE base; include/rpl_sync.inc include/rpl_reset.inc CALL create_tables(); @@ -220,19 +188,6 @@ include/gtid_step_reset.inc DROP TABLE base, temp_t, temp_n; include/gtid_step_assert.inc [count=1, only_count=0] include/assert_binlog_events.inc -include/wait_for_slave_sql_error.inc [errno=1884] -include/include/rpl_skip_to_end_of_relay_log.inc -include/stop_slave.inc -Warnings: -Warning 3022 This operation may not be safe when the slave has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until slave_open_temp_tables = 0. -RESET SLAVE; -include/start_slave.inc -DROP TABLE base; -DROP TABLE IF EXISTS base, temp_t, temp_n; -Warnings: -Note 1051 Unknown table 'test.base' -Note 1051 Unknown table 'test.temp_t' -Note 1051 Unknown table 'test.temp_n' include/rpl_sync.inc include/rpl_reset.inc ---- Clean up ---- diff --git a/mysql-test/suite/rpl_gtid/r/rpl_gtid_drop_table.result b/mysql-test/suite/rpl_gtid/r/rpl_gtid_stm_drop_table.result similarity index 100% rename from mysql-test/suite/rpl_gtid/r/rpl_gtid_drop_table.result rename to mysql-test/suite/rpl_gtid/r/rpl_gtid_stm_drop_table.result index 0dade04bff4..9d5f289e1f8 100644 --- a/mysql-test/suite/rpl_gtid/r/rpl_gtid_drop_table.result +++ b/mysql-test/suite/rpl_gtid/r/rpl_gtid_stm_drop_table.result @@ -6,14 +6,14 @@ Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. include/rpl_default_connections.inc -# -# First part -# [connection master] CREATE TABLE trans_t1 (c1 INT) ENGINE=InnoDB; CREATE TABLE non_trans_t1 (c1 INT) ENGINE=MyISAM; CREATE TEMPORARY TABLE temp_trans_t1 (c1 INT) ENGINE=InnoDB; CREATE TEMPORARY TABLE temp_non_trans_t1 (c1 INT) ENGINE=MyISAM; +# +# First part +# # Error cases ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP SET GTID_NEXT= '11111111-1111-1111-1111-111111111111:1'; ## Expecting error ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP after the statement diff --git a/mysql-test/suite/rpl_gtid/t/rpl_gtid_drop_table.cnf b/mysql-test/suite/rpl_gtid/t/rpl_gtid_row_mix_drop_table.cnf similarity index 100% rename from mysql-test/suite/rpl_gtid/t/rpl_gtid_drop_table.cnf rename to mysql-test/suite/rpl_gtid/t/rpl_gtid_row_mix_drop_table.cnf diff --git a/mysql-test/suite/rpl_gtid/t/rpl_gtid_row_mix_drop_table.test b/mysql-test/suite/rpl_gtid/t/rpl_gtid_row_mix_drop_table.test new file mode 100644 index 00000000000..0fc79850753 --- /dev/null +++ b/mysql-test/suite/rpl_gtid/t/rpl_gtid_row_mix_drop_table.test @@ -0,0 +1,2 @@ +--source include/have_binlog_format_mixed_or_row.inc +--source extra/rpl_tests/rpl_gtid_drop_table.test diff --git a/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_drop_table.cnf b/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_drop_table.cnf new file mode 100644 index 00000000000..10b447761fe --- /dev/null +++ b/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_drop_table.cnf @@ -0,0 +1,17 @@ +!include ../my.cnf + +# Set innodb-write-io-threads and innodb-read-io-threads to 2, +# instead of the default value 4, so that the aio-max-nr limit +# is not exceeded due to the increased number of concurrent mysqld +# instances when MTR runs rpl tests with parallel 4 or more. + +[mysqld.2] +replicate-ignore-table=test.temp_ignore + +[mysqld.3] +loose-innodb_write_io_threads= 2 +loose-innodb_read_io_threads= 2 + +[ENV] +SERVER_MYPORT_3= @mysqld.3.port +SERVER_MYSOCK_3= @mysqld.3.socket diff --git a/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_drop_table.test b/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_drop_table.test new file mode 100644 index 00000000000..6e0fb21f1ec --- /dev/null +++ b/mysql-test/suite/rpl_gtid/t/rpl_gtid_stm_drop_table.test @@ -0,0 +1,2 @@ +--source include/have_binlog_format_statement.inc +--source extra/rpl_tests/rpl_gtid_drop_table.test diff --git a/mysql-test/suite/rpl_gtid/t/rpl_gtids_table.test b/mysql-test/suite/rpl_gtid/t/rpl_gtids_table.test index 65691fca6ae..e6ff36c5bcb 100644 --- a/mysql-test/suite/rpl_gtid/t/rpl_gtids_table.test +++ b/mysql-test/suite/rpl_gtid/t/rpl_gtids_table.test @@ -75,6 +75,13 @@ if (`SELECT @@BINLOG_FORMAT = 'ROW' || @@BINLOG_FORMAT = 'MIXED'`) } --error ER_BAD_TABLE_ERROR DROP TEMPORARY TABLE tmp1, t3; +if (`SELECT @@BINLOG_FORMAT = 'ROW' || @@BINLOG_FORMAT = 'MIXED'`) +{ + # Likewise for the DROP TEMPORARY TABLE above + --disable_query_log + INSERT INTO t3 VALUES(1); + --enable_query_log +} DROP TABLE t3; --let $assert_text= committed gtids MASTER_UUID:1-8 --let $assert_cond= "[SELECT @@GLOBAL.GTID_EXECUTED]" = "$master_uuid:1-8" diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_mix_drop_temp.result b/mysql-test/suite/rpl_nogtid/r/rpl_mix_drop_temp.result index d1201c15241..9f9f129f17a 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_mix_drop_temp.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_mix_drop_temp.result @@ -23,7 +23,6 @@ stop slave; **** On Master **** CREATE TEMPORARY TABLE tmp3 (a int); DROP TEMPORARY TABLE tmp3; -SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; include/rpl_reset.inc CREATE TABLE t1 ( i INT ); diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_mixed_drop_create_temp_table.result b/mysql-test/suite/rpl_nogtid/r/rpl_mixed_drop_create_temp_table.result index 568a9bc834c..18b003e0aff 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_mixed_drop_create_temp_table.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_mixed_drop_create_temp_table.result @@ -65,16 +65,12 @@ SET @commands= 'Drop-Temp-T-Temp'; DROP TEMPORARY TABLE tt_tmp_2; -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e- SET @commands= 'Drop-Temp-N-Temp'; DROP TEMPORARY TABLE nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-Xe-Temp'; @@ -90,8 +86,6 @@ Warnings: Note 1051 Unknown table 'test.tt_xx_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -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- SET @commands= 'Drop-Temp-TXe-Temp'; @@ -99,8 +93,6 @@ DROP TEMPORARY TABLE tt_tmp_2, tt_1; ERROR 42S02: Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-If-TXe-Temp'; @@ -109,8 +101,6 @@ Warnings: Note 1051 Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -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- SET @commands= 'Drop-Temp-NXe-Temp'; @@ -118,8 +108,6 @@ DROP TEMPORARY TABLE nt_tmp_2, tt_1; ERROR 42S02: Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-If-NXe-Temp'; @@ -128,33 +116,24 @@ Warnings: Note 1051 Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -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- SET @commands= 'Drop-Temp-TN-Temp'; DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-TT-Temp'; DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-NN-Temp'; DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -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- @@ -171,7 +150,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -190,8 +168,6 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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,9 +180,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -222,15 +195,9 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -281,7 +248,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -304,8 +270,6 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -320,7 +284,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -341,8 +304,6 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -358,7 +319,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -381,8 +341,6 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -396,9 +354,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -416,15 +371,9 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -440,9 +389,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -462,15 +408,9 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -484,11 +424,7 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -503,18 +439,10 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -528,7 +456,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -546,7 +473,6 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -559,9 +485,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -576,9 +499,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN @@ -598,9 +518,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN @@ -623,9 +540,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN @@ -645,9 +559,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN @@ -671,11 +582,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R'; @@ -694,11 +600,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-N-Temp R'; @@ -710,10 +611,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R'; @@ -730,14 +627,8 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-Xe-Temp R'; @@ -780,11 +671,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R'; @@ -807,11 +693,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TXe-Temp R'; @@ -824,11 +705,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R'; @@ -849,11 +725,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-If-TXe-Temp R'; @@ -867,11 +738,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R'; @@ -894,11 +760,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-NXe-Temp R'; @@ -911,10 +772,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R'; @@ -933,14 +790,8 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-If-NXe-Temp R'; @@ -954,10 +805,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R'; @@ -978,14 +825,8 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-TN-Temp R'; @@ -997,14 +838,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R'; @@ -1021,19 +854,8 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TT-Temp R'; @@ -1045,11 +867,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R'; @@ -1067,10 +884,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-NN-Temp R'; @@ -1082,10 +895,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R'; @@ -1101,9 +910,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -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- @@ -1123,9 +929,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN @@ -1148,9 +951,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -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- @@ -1170,9 +970,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN @@ -1287,8 +1084,6 @@ DROP TABLE tt_tmp_2, nt_tmp_2, nt_2; -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- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ -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- @@ -1296,9 +1091,6 @@ SET @commands= 'Drop-TN-Temp'; DROP TABLE tt_tmp_2, nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- @@ -1466,8 +1258,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ -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- @@ -1481,8 +1271,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- ######################################################################### @@ -1499,10 +1287,6 @@ DROP TEMPORARY TABLE nt_tmp_1; DROP TEMPORARY TABLE nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp'; @@ -1512,10 +1296,6 @@ DROP TEMPORARY TABLE tt_tmp_1; DROP TEMPORARY TABLE tt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- @@ -1534,15 +1314,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -1556,12 +1327,6 @@ DROP TEMPORARY TABLE tt_tmp_2; COMMIT; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C'; @@ -1579,11 +1344,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (5), (5) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C'; @@ -1597,12 +1357,6 @@ ERROR 23000: Duplicate entry '3' for key 'PRIMARY' COMMIT; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C'; @@ -1620,11 +1374,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (6), (6) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- @@ -1644,16 +1393,6 @@ Warning # The creation of some temporary tables could not be rolled back. Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R'; @@ -1668,12 +1407,6 @@ Warning # The creation of some temporary tables could not be rolled back. Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R'; @@ -1695,11 +1428,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (7), (7) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R'; @@ -1716,12 +1444,6 @@ Warning # The creation of some temporary tables could not be rolled back. Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R'; @@ -1743,11 +1465,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_error_1() VALUES (8), (8) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- ######################################################################### diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_mixed_implicit_commit_binlog.result b/mysql-test/suite/rpl_nogtid/r/rpl_mixed_implicit_commit_binlog.result index b517fa72131..37f39d81027 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_mixed_implicit_commit_binlog.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_mixed_implicit_commit_binlog.result @@ -522,7 +522,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_1(ddl_case) VALUES (8) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `new_tt_xx` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e- diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_mixed_mixing_engines.result b/mysql-test/suite/rpl_nogtid/r/rpl_mixed_mixing_engines.result index 7a5a0203361..ec693c34978 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_mixed_mixing_engines.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_mixed_mixing_engines.result @@ -12676,13 +12676,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_11; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T Sn T CT Rn R] @@ -12726,13 +12722,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_12; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T CT T R] @@ -12766,13 +12758,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_13; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B tN CT T R] @@ -12815,13 +12803,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_14; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B CT T R] @@ -12851,13 +12835,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_15; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B N CT T R] @@ -12900,13 +12880,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_16; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- ################################################################################### diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_mixed_mixing_engines.result b/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_mixed_mixing_engines.result index 68d666ba618..5b967da9d5c 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_mixed_mixing_engines.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_mixed_mixing_engines.result @@ -13048,13 +13048,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_11; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T Sn T CT Rn R] @@ -13098,13 +13094,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_12; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T CT T R] @@ -13138,13 +13130,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_13; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B tN CT T R] @@ -13187,13 +13175,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_14; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B CT T R] @@ -13223,13 +13207,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_15; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B N CT T R] @@ -13272,13 +13252,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_16; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- ################################################################################### diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_row_mixing_engines.result b/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_row_mixing_engines.result index 9e1f7f23588..94071097785 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_row_mixing_engines.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_non_direct_row_mixing_engines.result @@ -14926,13 +14926,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_11; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T Sn T CT Rn R] @@ -14976,13 +14972,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_12; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T CT T R] @@ -15016,13 +15008,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_13; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B tN CT T R] @@ -15067,13 +15055,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_14; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B CT T R] @@ -15103,13 +15087,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_15; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B N CT T R] @@ -15154,13 +15134,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_16; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- ################################################################################### diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_row_drop_create_temp_table.result b/mysql-test/suite/rpl_nogtid/r/rpl_row_drop_create_temp_table.result index 45bb7bc4d31..76b4830ea37 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_row_drop_create_temp_table.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_row_drop_create_temp_table.result @@ -65,16 +65,12 @@ SET @commands= 'Drop-Temp-T-Temp'; DROP TEMPORARY TABLE tt_tmp_2; -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e- SET @commands= 'Drop-Temp-N-Temp'; DROP TEMPORARY TABLE nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-Xe-Temp'; @@ -90,8 +86,6 @@ Warnings: Note 1051 Unknown table 'test.tt_xx_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -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- SET @commands= 'Drop-Temp-TXe-Temp'; @@ -99,8 +93,6 @@ DROP TEMPORARY TABLE tt_tmp_2, tt_1; ERROR 42S02: Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-If-TXe-Temp'; @@ -109,8 +101,6 @@ Warnings: Note 1051 Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -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- SET @commands= 'Drop-Temp-NXe-Temp'; @@ -118,8 +108,6 @@ DROP TEMPORARY TABLE nt_tmp_2, tt_1; ERROR 42S02: Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-If-NXe-Temp'; @@ -128,33 +116,24 @@ Warnings: Note 1051 Unknown table 'test.tt_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -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- SET @commands= 'Drop-Temp-TN-Temp'; DROP TEMPORARY TABLE tt_tmp_2, nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-TT-Temp'; DROP TEMPORARY TABLE tt_tmp_1, tt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-NN-Temp'; DROP TEMPORARY TABLE nt_tmp_1, nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -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- @@ -172,7 +151,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -193,8 +171,6 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -207,9 +183,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -226,16 +199,10 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -291,7 +258,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -316,8 +282,6 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -333,7 +297,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -356,8 +319,6 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -374,7 +335,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -399,8 +359,6 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -414,9 +372,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -435,16 +390,10 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -461,9 +410,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -484,16 +430,10 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -508,12 +448,8 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -528,20 +464,12 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -556,7 +484,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -576,7 +503,6 @@ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -589,9 +515,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -607,9 +530,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -631,9 +551,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -659,9 +576,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -683,9 +597,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -712,12 +623,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-T-Temp N Drop-Temp-T-Temp R'; @@ -737,12 +642,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-N-Temp R'; @@ -754,10 +653,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-N-Temp N Drop-Temp-N-Temp R'; @@ -774,15 +669,9 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-Xe-Temp R'; @@ -826,12 +715,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R'; @@ -855,12 +738,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TXe-Temp R'; @@ -873,12 +750,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TXe-Temp N Drop-Temp-TXe-Temp R'; @@ -900,12 +771,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-If-TXe-Temp R'; @@ -919,12 +784,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-If-TXe-Temp N Drop-Temp-If-TXe-Temp R'; @@ -948,12 +807,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-NXe-Temp R'; @@ -966,10 +819,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-NXe-Temp N Drop-Temp-NXe-Temp R'; @@ -988,15 +837,9 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-If-NXe-Temp R'; @@ -1010,10 +853,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-If-NXe-Temp N Drop-Temp-If-NXe-Temp R'; @@ -1034,15 +873,9 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-TN-Temp R'; @@ -1054,15 +887,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TN-Temp N Drop-Temp-TN-Temp R'; @@ -1079,21 +903,9 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TT-Temp R'; @@ -1105,12 +917,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TT-Temp N Drop-Temp-TT-Temp R'; @@ -1129,11 +935,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) -master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-NN-Temp R'; @@ -1145,10 +946,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B T Drop-Temp-NN-Temp N Drop-Temp-NN-Temp R'; @@ -1164,9 +961,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -1187,9 +981,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -1214,9 +1005,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -1237,9 +1025,6 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT @@ -1356,8 +1141,6 @@ DROP TABLE tt_tmp_2, nt_tmp_2, nt_2; -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- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ -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- @@ -1365,9 +1148,6 @@ SET @commands= 'Drop-TN-Temp'; DROP TABLE tt_tmp_2, nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- @@ -1547,8 +1327,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ -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- @@ -1563,8 +1341,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- ######################################################################### @@ -1581,10 +1357,6 @@ DROP TEMPORARY TABLE nt_tmp_1; DROP TEMPORARY TABLE nt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp'; @@ -1594,10 +1366,6 @@ DROP TEMPORARY TABLE tt_tmp_1; DROP TEMPORARY TABLE tt_tmp_2; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- @@ -1616,15 +1384,6 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_xx_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Xid # # COMMIT /* XID */ @@ -1639,12 +1398,6 @@ DROP TEMPORARY TABLE tt_tmp_2; COMMIT; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne C'; @@ -1663,11 +1416,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_error_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te C'; @@ -1681,12 +1429,6 @@ ERROR 23000: Duplicate entry '3' for key 'PRIMARY' COMMIT; -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig C'; @@ -1705,11 +1447,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_error_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- @@ -1729,16 +1466,6 @@ Warning # The creation of some temporary tables could not be rolled back. Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # COMMIT -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp R'; @@ -1753,12 +1480,6 @@ Warning # The creation of some temporary tables could not be rolled back. Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Ne R'; @@ -1781,11 +1502,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_error_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp Te R'; @@ -1802,12 +1518,6 @@ Warning # The creation of some temporary tables could not be rolled back. Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B Drop-Temp-T-Temp Create-T-Temp Drop-Temp-T-Temp Drop-Temp-T-Temp NeT-trig R'; @@ -1830,11 +1540,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.nt_error_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- ######################################################################### diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_row_implicit_commit_binlog.result b/mysql-test/suite/rpl_nogtid/r/rpl_row_implicit_commit_binlog.result index 4537f202b51..55b8f7c215c 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_row_implicit_commit_binlog.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_row_implicit_commit_binlog.result @@ -559,7 +559,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.tt_1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `new_tt_xx` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e- diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_row_mixing_engines.result b/mysql-test/suite/rpl_nogtid/r/rpl_row_mixing_engines.result index 9e1f7f23588..94071097785 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_row_mixing_engines.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_row_mixing_engines.result @@ -14926,13 +14926,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_11; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_11` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T Sn T CT Rn R] @@ -14976,13 +14972,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_12; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_12` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B T CT T R] @@ -15016,13 +15008,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_13; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_13` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B tN CT T R] @@ -15067,13 +15055,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_14; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_14` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B CT T R] @@ -15103,13 +15087,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_15; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_15` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- rpl_mixing_engines.inc [commands=B N CT T R] @@ -15154,13 +15134,9 @@ rpl_mixing_engines.inc [commands=drop-CT] -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- DROP TEMPORARY TABLE IF EXISTS tt_xx_16; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> drop-CT << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= Gtid_set -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_16` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> drop-CT << -e-e-e-e-e-e-e-e-e-e-e- ################################################################################### diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_create_temp_table.result b/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_create_temp_table.result index 62e3f22f055..d6bedad0e79 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_create_temp_table.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_create_temp_table.result @@ -90,8 +90,6 @@ Warnings: Note 1051 Unknown table 'test.tt_xx_1' -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -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- SET @commands= 'Drop-Temp-TXe-Temp'; @@ -110,7 +108,7 @@ Note 1051 Unknown table 'test.tt_1' -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- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-NXe-Temp'; @@ -129,7 +127,7 @@ Note 1051 Unknown table 'test.tt_1' -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- include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ -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- SET @commands= 'Drop-Temp-TN-Temp'; @@ -281,7 +279,6 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -304,8 +301,6 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -358,7 +353,7 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -381,8 +376,8 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Xid # # COMMIT /* XID */ -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- @@ -440,7 +435,7 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) @@ -462,13 +457,13 @@ COMMIT; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) @@ -780,11 +775,6 @@ Warnings: Warning # Some temporary tables were dropped, but these operations could not be rolled back. -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- include/show_binlog_events.inc -Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-If-Xe-Temp N Drop-Temp-If-Xe-Temp R'; @@ -807,11 +797,6 @@ Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_xx_1` /* generated by server */ -master-bin.000001 # Query # # ROLLBACK -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- SET @commands= 'B T Drop-Temp-TXe-Temp R'; @@ -870,7 +855,7 @@ include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ master-bin.000001 # Query # # ROLLBACK -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- @@ -896,8 +881,8 @@ master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2`,`tt_1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_2` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt_tmp_1` /* generated by server */ master-bin.000001 # Query # # ROLLBACK -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- @@ -956,7 +941,7 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ master-bin.000001 # Query # # COMMIT -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- @@ -978,13 +963,13 @@ Warning # Some temporary tables were dropped, but these operations could not be include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_2` /* generated by server */ master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1`,`tt_1` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `nt_tmp_1` /* generated by server */ master-bin.000001 # Query # # COMMIT -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- diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_temp.result b/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_temp.result index aaca3d9b801..bf27ce2bf39 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_temp.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_stm_drop_temp.result @@ -23,7 +23,6 @@ stop slave; **** On Master **** CREATE TEMPORARY TABLE tmp3 (a int); DROP TEMPORARY TABLE tmp3; -SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE; include/rpl_reset.inc CREATE TABLE t1 ( i INT ); diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_stm_innodb.result b/mysql-test/suite/rpl_nogtid/r/rpl_stm_innodb.result index d0b2ea4030d..0fe198bfc0b 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_stm_innodb.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_stm_innodb.result @@ -80,7 +80,7 @@ ERROR 42S02: Table 'mysqltest1.tmp' doesn't exist SHOW CREATE TABLE mysqltest1.tmp2; ERROR 42S02: Table 'mysqltest1.tmp2' doesn't exist ######### for SBR, t1 has two rows here: the transaction not rolled back since t1 uses MyISAM ######### -######### for MBR, t1 has one row here: the transaction not rolled back since t1 uses MyISAM ######### +######### for MBR, t1 has zero rows here, as CREATE/DROP TEMPORARY TABLE were not binlogged ######### SELECT COUNT(*) FROM mysqltest1.t1; COUNT(*) 2 diff --git a/mysql-test/suite/rpl_nogtid/r/rpl_temp_table_mix_row.result b/mysql-test/suite/rpl_nogtid/r/rpl_temp_table_mix_row.result index 55fdf3c91cb..d7c1f3cd0ba 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_temp_table_mix_row.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_temp_table_mix_row.result @@ -37,7 +37,7 @@ ALTER TABLE t1_tmp ADD COLUMN b INT; DELETE FROM t2; CREATE TEMPORARY TABLE t2_tmp (a int); ALTER TABLE t1_tmp ADD COLUMN c INT; -### assertion: assert that there is one open temp table on slave +### assertion: assert that slave has no temporary tables opened include/sync_slave_sql_with_master.inc SHOW STATUS LIKE 'Slave_open_temp_tables'; Variable_name Value @@ -59,12 +59,10 @@ slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a int) slave-bin.000001 # Query # # use `test`; CREATE TABLE t2 ( i1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (i1) ) slave-bin.000001 # Query # # use `test`; CREATE TABLE t3 ( i1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (i1) ) slave-bin.000001 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1 AFTER DELETE ON t2 FOR EACH ROW INSERT INTO t3 () VALUES () -slave-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t1_tmp` /* generated by server */ slave-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */ slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1) slave-bin.000001 # Xid # # COMMIT /* XID */ -slave-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t2_tmp` /* generated by server */ slave-bin.000001 # Query # # BEGIN slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2) slave-bin.000001 # Xid # # COMMIT /* XID */ @@ -72,7 +70,7 @@ slave-bin.000001 # Query # # use `test`; DROP TABLE `t3`,`t1` /* generated by se # Bug#55478 Row events wrongly apply on the temporary table of the same name # ========================================================================== -# The statement should be binlogged +# The statement should not be binlogged CREATE TEMPORARY TABLE t1(c1 INT) ENGINE=InnoDB; # Case 1: CREATE TABLE t1 ... SELECT @@ -96,8 +94,6 @@ master-bin.000001 # Query # # COMMIT BEGIN; DROP TEMPORARY TABLE t1; -# The rows event will binlogged before 'DROP TEMPORARY TABLE t1', -# as t1 is non-transactional table INSERT INTO t1 VALUES(Rand()); COMMIT; include/show_binlog_events.inc @@ -106,9 +102,6 @@ master-bin.000001 # Query # # BEGIN master-bin.000001 # Table_map # # table_id: # (test.t1) master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT -master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t1` /* generated by server */ -master-bin.000001 # Query # # COMMIT include/sync_slave_sql_with_master.inc # Compare the base table. include/diff_tables.inc [master:t1, slave:t1] diff --git a/mysql-test/suite/rpl_nogtid/t/rpl_temp_table_mix_row.test b/mysql-test/suite/rpl_nogtid/t/rpl_temp_table_mix_row.test index 725fe31d98f..238ccb898d4 100644 --- a/mysql-test/suite/rpl_nogtid/t/rpl_temp_table_mix_row.test +++ b/mysql-test/suite/rpl_nogtid/t/rpl_temp_table_mix_row.test @@ -61,13 +61,7 @@ DROP TABLE t1; # NOTES # ===== # -# 1. Temporary tables cannot be logged using the row-based -# format. Thus, once row-based logging is used, all subsequent -# statements using that table are unsafe, and we approximate this -# condition by treating all statements made by that client as -# unsafe until the client no longer holds any temporary tables. -# -# 2. Two different connections can use the same temporary table +# 1. Two different connections can use the same temporary table # name without conflicting with each other or with an # existing non-TEMPORARY table of the same name. # @@ -76,17 +70,16 @@ DROP TABLE t1; # # The test is implemented as follows: # 1. create regular tables -# 2. create a temporary table t1_tmp: should be logged as statement +# 2. create a temporary table t1_tmp: should not be logged # 3. issue an alter table: should be logged as statement # 4. issue statement that forces switch to RBR # 5. create another temporary table t2_tmp: should not be logged # 6. issue alter table on t1_tmp: should not be logged -# 7. drop t1_tmp and regular table on same statement: should log both in -# statement format (but different statements) -# 8. issue deterministic insert: logged as row (because t2_tmp still -# exists). -# 9. drop t2_tmp and issue deterministic statement: should log drop and -# query in statement format (show switch back to STATEMENT format) +# 7. drop t1_tmp and regular table on same statement: should only log the +# regular table drop +# 8. issue deterministic insert: logged as statement +# 9. drop t2_tmp and issue deterministic statement: should not log drop and +# log the query in statement format # 10. in the end the slave should not have open temp tables. # @@ -99,39 +92,37 @@ CREATE TABLE t2 ( i1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (i1) ); CREATE TABLE t3 ( i1 INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (i1) ); CREATE TRIGGER tr1 AFTER DELETE ON t2 FOR EACH ROW INSERT INTO t3 () VALUES (); -# assertion: assert that CREATE is logged as STATEMENT +# assertion: assert that CREATE is not logged CREATE TEMPORARY TABLE t1_tmp (i1 int); -# assertion: assert that ALTER TABLE is logged as STATEMENT +# assertion: assert that ALTER TABLE is not logged ALTER TABLE t1_tmp ADD COLUMN b INT; # action: force switch to RBR DELETE FROM t2; -# assertion: assert that t2_tmp will not make into the binlog (RBR logging atm) +# assertion: assert that t2_tmp will not make into the binlog CREATE TEMPORARY TABLE t2_tmp (a int); # assertion: assert that ALTER TABLE on t1_tmp will not make into the binlog ALTER TABLE t1_tmp ADD COLUMN c INT; --- echo ### assertion: assert that there is one open temp table on slave +-- echo ### assertion: assert that slave has no temporary tables opened --source include/sync_slave_sql_with_master.inc SHOW STATUS LIKE 'Slave_open_temp_tables'; -- connection master -# assertion: assert that both drops are logged +# assertion: assert that only t2 drop is logged DROP TABLE t1_tmp, t2; -# assertion: assert that statement is logged as row (master still has one -# opened temporary table - t2_tmp. +# assertion: assert that statement is logged as statement INSERT INTO t1 VALUES (1); -# assertion: assert that DROP TABLE *is* logged despite CREATE is not. +# assertion: assert that DROP TABLE is not logged DROP TEMPORARY TABLE t2_tmp; -# assertion: assert that statement is now logged as STMT (mixed mode switches -# back to STATEMENT). +# assertion: assert that statement is logged as STMT INSERT INTO t1 VALUES (2); --source include/sync_slave_sql_with_master.inc @@ -156,7 +147,7 @@ connection master; let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1); let $binlog_start= query_get_value(SHOW MASTER STATUS, Position, 1); ---echo # The statement should be binlogged +--echo # The statement should not be binlogged CREATE TEMPORARY TABLE t1(c1 INT) ENGINE=InnoDB; --echo @@ -188,8 +179,6 @@ DROP TEMPORARY TABLE t1; # # INSERT INTO t1 VALUES(1); ---echo # The rows event will binlogged before 'DROP TEMPORARY TABLE t1', ---echo # as t1 is non-transactional table INSERT INTO t1 VALUES(Rand()); COMMIT; diff --git a/sql/sql_table.cc b/sql/sql_table.cc index a4d9b674874..b8c44a0832a 100644 --- a/sql/sql_table.cc +++ b/sql/sql_table.cc @@ -2278,7 +2278,8 @@ bool mysql_rm_table(THD *thd,TABLE_LIST *tables, my_bool if_exists, Here we are sure that the tmp table exists and will set the flag based on table transactional type. */ - if (is_temporary_table(table)) + if (is_temporary_table(table) + && table->table->should_binlog_drop_if_temp()) { if (table->table->s->tmp_table == TRANSACTIONAL_TMP_TABLE) have_trans_tmp_table= 1; @@ -2468,14 +2469,16 @@ int mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, int non_temp_tables_count= 0; bool foreign_key_error= false; bool non_tmp_error= false; - bool trans_tmp_table_deleted= false; - bool non_trans_tmp_table_deleted= false; + bool trans_tmp_table_delete_to_binlog= false; + bool non_trans_tmp_table_delete_to_binlog= false; bool non_tmp_table_deleted= false; - bool have_nonexistent_tmp_table= false; - bool is_drop_tmp_if_exists_with_no_defaultdb= false; + bool nonexistent_tmp_table_to_binlog= false; + bool is_drop_tmp_with_no_defaultdb= false; String built_query; String built_trans_tmp_query, built_non_trans_tmp_query; String nonexistent_tmp_tables; + bool tmp_table_deleted= false; + bool tmp_table_not_found= false; DBUG_ENTER("mysql_rm_table_no_locks"); /* @@ -2522,25 +2525,27 @@ int mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, built_query.append("DROP TABLE "); } - if (thd->is_current_stmt_binlog_format_row() || if_exists) + /* + If default database doesnot exist in those cases set + 'is_drop_tmp_with_no_defaultdb flag to 'true' so that the + 'DROP TEMPORARY TABLE IF EXISTS' command is logged with a qualified + table name. + */ + is_drop_tmp_with_no_defaultdb= + (thd->is_current_stmt_binlog_format_row() && thd->db().str != NULL); + if (is_drop_tmp_with_no_defaultdb) { - /* - If default database doesnot exist in those cases set - 'is_drop_tmp_if_exists_with_no_defaultdb flag to 'true' so that the - 'DROP TEMPORARY TABLE IF EXISTS' command is logged with a qualified - table name. - */ - if (thd->db().str != NULL) + bool exists= false; + if (dd::schema_exists(thd, thd->db().str, &exists)) { - bool exists= false; - if (dd::schema_exists(thd, thd->db().str, &exists)) - { - error= 1; - goto err; - } - if (!exists) - is_drop_tmp_if_exists_with_no_defaultdb= true; + error= 1; + goto err; } + is_drop_tmp_with_no_defaultdb= is_drop_tmp_with_no_defaultdb && !exists; + } + + if (if_exists) + { built_trans_tmp_query.set_charset(system_charset_info); built_trans_tmp_query.append("DROP TEMPORARY TABLE IF EXISTS "); built_non_trans_tmp_query.set_charset(system_charset_info); @@ -2578,6 +2583,9 @@ int mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, thd->add_to_binlog_accessed_dbs(table->db); + // Save this before drop_temporary_table resets table->table to NULL + const auto should_binlog_drop_if_temp= + is_temporary_table(table) && table->table->should_binlog_drop_if_temp(); /* drop_temporary_table may return one of the following error codes: . 0 - a temporary table was successfully dropped. @@ -2606,36 +2614,50 @@ int mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, */ if (!dont_log_query) { - /* - If there is an error, we don't know the type of the engine - at this point. So, we keep it in the nonexistent_tmp_table list. - */ if (error == 1) - have_nonexistent_tmp_table= true; - else if (is_trans) - trans_tmp_table_deleted= TRUE; + tmp_table_not_found= true; else - non_trans_tmp_table_deleted= TRUE; + tmp_table_deleted= true; - String *built_ptr_query= - (error == 1 ? &nonexistent_tmp_tables : - (is_trans ? &built_trans_tmp_query : &built_non_trans_tmp_query)); - /* - Write the database name if it is not the current one or if - thd->db is NULL or 'IF EXISTS' clause is present in 'DROP TEMPORARY' - query. - */ - if (thd->db().str == NULL || strcmp(db, thd->db().str) != 0 - || is_drop_tmp_if_exists_with_no_defaultdb ) + if (should_binlog_drop_if_temp) { - append_identifier(thd, built_ptr_query, db, db_len, - system_charset_info, thd->charset()); - built_ptr_query->append("."); + String *built_ptr_query; + if (error == 1) + { + /* + If there is an error, we don't know the type of the engine + at this point. So, we keep it in the nonexistent_tmp_table list. + */ + built_ptr_query= &nonexistent_tmp_tables; + nonexistent_tmp_table_to_binlog= true; + } + else if (is_trans) + { + built_ptr_query= &built_trans_tmp_query; + trans_tmp_table_delete_to_binlog= true; + } + else + { + built_ptr_query= &built_non_trans_tmp_query; + non_trans_tmp_table_delete_to_binlog= true; + } + /* + Write the database name if it is not the current one or if + thd->db is NULL or 'IF EXISTS' clause is present in 'DROP + TEMPORARY' query. + */ + if (thd->db().str == NULL || strcmp(db, thd->db().str) != 0 + || is_drop_tmp_with_no_defaultdb) + { + append_identifier(thd, built_ptr_query, db, db_len, + system_charset_info, thd->charset()); + built_ptr_query->append("."); + } + append_identifier(thd, built_ptr_query, table->table_name, + strlen(table->table_name), system_charset_info, + thd->charset()); + built_ptr_query->append(","); } - append_identifier(thd, built_ptr_query, table->table_name, - strlen(table->table_name), system_charset_info, - thd->charset()); - built_ptr_query->append(","); } /* This means that a temporary table was droped and as such there @@ -2848,8 +2870,7 @@ int mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, #endif } DEBUG_SYNC(thd, "rm_table_no_locks_before_binlog"); - thd->thread_specific_used|= (trans_tmp_table_deleted || - non_trans_tmp_table_deleted); + thd->thread_specific_used= thd->thread_specific_used || tmp_table_deleted; error= 0; err: if (wrong_tables.length()) @@ -2862,11 +2883,9 @@ err: error= 1; } - if (have_nonexistent_tmp_table || non_trans_tmp_table_deleted || - trans_tmp_table_deleted || non_tmp_table_deleted) + if (tmp_table_deleted || tmp_table_not_found || non_tmp_table_deleted) { - if (have_nonexistent_tmp_table || non_trans_tmp_table_deleted || - trans_tmp_table_deleted) + if (tmp_table_deleted || tmp_table_not_found) thd->get_transaction()->mark_dropped_temp_table(Transaction_ctx::STMT); /* @@ -2896,13 +2915,14 @@ err: */ if (!dont_log_query && mysql_bin_log.is_open()) { - if (non_trans_tmp_table_deleted) + if (non_trans_tmp_table_delete_to_binlog) { /* Add the list of nonexistent tmp tables here only if there is no trans tmp table deleted. */ - if (!trans_tmp_table_deleted && have_nonexistent_tmp_table) + if (!trans_tmp_table_delete_to_binlog + && nonexistent_tmp_table_to_binlog) built_non_trans_tmp_query.append(nonexistent_tmp_tables); /* Chop off the last comma */ built_non_trans_tmp_query.chop(); @@ -2911,11 +2931,12 @@ err: built_non_trans_tmp_query.ptr(), built_non_trans_tmp_query.length(), false/*is_trans*/, false/*direct*/, - is_drop_tmp_if_exists_with_no_defaultdb/*suppress_use*/, + is_drop_tmp_with_no_defaultdb/*suppress_use*/, 0)/*errcode*/; } - if (trans_tmp_table_deleted || - (have_nonexistent_tmp_table && !non_trans_tmp_table_deleted)) + if (trans_tmp_table_delete_to_binlog || + (nonexistent_tmp_table_to_binlog + && !non_trans_tmp_table_delete_to_binlog)) { /* When multiple tables are dropped, the tables are classified @@ -2957,14 +2978,14 @@ err: (non_tmp_table_deleted)'. */ if (!thd->in_active_multi_stmt_transaction() && - non_trans_tmp_table_deleted) + non_trans_tmp_table_delete_to_binlog) { DBUG_PRINT("info", ("mysql_rm_table_no_locks commit point 1")); thd->is_commit_in_middle_of_statement= true; error |= mysql_bin_log.commit(thd, true); thd->is_commit_in_middle_of_statement= false; } - if (have_nonexistent_tmp_table) + if (nonexistent_tmp_table_to_binlog) built_trans_tmp_query.append(nonexistent_tmp_tables); /* Chop off the last comma */ built_trans_tmp_query.chop(); @@ -2973,7 +2994,7 @@ err: built_trans_tmp_query.ptr(), built_trans_tmp_query.length(), true/*is_trans*/, false/*direct*/, - is_drop_tmp_if_exists_with_no_defaultdb/*suppress_use*/, + is_drop_tmp_with_no_defaultdb/*suppress_use*/, 0/*errcode*/); } /* @@ -2985,8 +3006,9 @@ err: (thd->lex->select_lex->table_list.elements > 1 || !error)) { /// @see comment for mysql_bin_log.commit above. - if (non_trans_tmp_table_deleted || trans_tmp_table_deleted || - have_nonexistent_tmp_table) + if (non_trans_tmp_table_delete_to_binlog + || trans_tmp_table_delete_to_binlog + || nonexistent_tmp_table_to_binlog) { DBUG_PRINT("info", ("mysql_rm_table_no_locks commit point 1")); thd->is_commit_in_middle_of_statement= true;