commit 73d9e345172e28f5018a7605f022c00e32e319cf Author: Laurynas Biveinis Date: Fri Apr 14 07:02:24 2017 +0300 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, process tables temporary tables needing and not needing binlog separately. - In mysql_alter_table, add a thd->decide_logging_format call in one of the temporary table opening paths in order to record the create-time binlog format for an ALTER TABLE-recreated temporary table correctly. 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/drop_temp_table.test b/mysql-test/extra/binlog_tests/drop_temp_table.test index af2a635ff22..b2129dfeb34 100644 --- a/mysql-test/extra/binlog_tests/drop_temp_table.test +++ b/mysql-test/extra/binlog_tests/drop_temp_table.test @@ -25,10 +25,6 @@ CREATE TABLE t(c1 int); DROP TEMPORARY TABLE IF EXISTS tmp; -# In RBR DROP TEMPORARY TABLE statements are always binlogged, so tables -# which were added prior switching to RBR are cleaned up. -# IF EXISTS clause is always added to ensure that statement doesn't fail -# if table was created after switch to RBR. --disable_warnings DROP TEMPORARY TABLE IF EXISTS tmp; 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 6a3bcd9ef42..31c90a2113e 100644 --- a/mysql-test/extra/binlog_tests/logical_timestamping.inc +++ b/mysql-test/extra/binlog_tests/logical_timestamping.inc @@ -204,8 +204,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 67e5fbab414..25a2ebec2f5 100644 --- a/mysql-test/extra/rpl_tests/rpl_drop_temp.test +++ b/mysql-test/extra/rpl_tests/rpl_drop_temp.test @@ -78,7 +78,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 72% 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 62cb8a5f3fe..4070c299db6 100644 --- a/mysql-test/suite/rpl_gtid/t/rpl_gtid_drop_table.test +++ b/mysql-test/extra/rpl_tests/rpl_gtid_drop_table.test @@ -35,6 +35,13 @@ --source include/rpl_default_connections.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 # @@ -44,6 +51,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 @@ -74,83 +84,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. # All error cases below are no-ops. 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 e6a40201702..7b9e45abb4c 100644 --- a/mysql-test/extra/rpl_tests/rpl_split_statements.test +++ b/mysql-test/extra/rpl_tests/rpl_split_statements.test @@ -35,19 +35,19 @@ # # 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 temporary tables. Moreover, statement for all -# dropped non-temporary tables can be split further. If no GTID -# is assigned then there will be individual DROP TABLE statements -# for each dropped table in SEs which don't support atomic DDL -# and single statement for all dropped tables in SEs supporting -# atomic DDL. If original DROP TABLE statement is supposed to be -# executed under single GTID then all dropped base tables (both -# supporting atomic DDL and not) are combined in a single -# statement. Execution of statements which drop both temporary -# and non-temporary tables or two kinds of temporary tables under -# single GTID is not allowed. +# tables, with statement binlog format a separate statement for all +# dropped transactional temporary tables, and a separate statement +# for all dropped non-transactional temporary tables. Moreover, +# statement for all dropped non-temporary tables can be split +# further. If no GTID is assigned then there will be individual +# DROP TABLE statements for each dropped table in SEs which don't +# support atomic DDL and single statement for all dropped tables in +# SEs supporting atomic DDL. If original DROP TABLE statement is +# supposed to be executed under single GTID then all dropped base +# tables (both supporting atomic DDL and not) are combined in a +# single statement. Execution of statements which drop both +# temporary and non-temporary tables or two kinds of temporary +# tables under single GTID is not allowed. # # 3. DROP DATABASE: See details in rpl_split_statements_debug.test # @@ -270,10 +270,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 07de2fb39f4..9321bdca66a 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...]]] # [--let $save_binlog_position= 1] # [--let $dont_print_logical_timestamps= 1] # --source include/assert_logical_timestamps.inc @@ -29,6 +30,11 @@ # 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. +# # $save_binlog_position # If this flag is set, the script will source # include/save_binlog_position.inc after it has finished the @@ -40,13 +46,29 @@ # By default, $logical_timestamps is printed to the result log. If # this flag is set, that is suppressed. ---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] +} if ($dont_print_logical_timestamps) { --let $include_filename= include/assert_logical_timestamps.inc } --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())` @@ -61,19 +83,19 @@ 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='))` ---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='))` +--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 - if ($save_binlog_position) { --source include/save_binlog_position.inc } ---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 +--let $logical_timestamps_mix= diff --git a/mysql-test/suite/binlog/r/binlog_database.result b/mysql-test/suite/binlog/r/binlog_database.result index 24633816e53..4ae4080f2c0 100644 --- a/mysql-test/suite/binlog/r/binlog_database.result +++ b/mysql-test/suite/binlog/r/binlog_database.result @@ -123,7 +123,6 @@ 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 TABLE `t1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt1` /* generated by server */ FLUSH STATUS; # 'DROP TABLE IF EXISTS ' is binlogged @@ -211,7 +210,6 @@ 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 TABLE `t1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `tt1` /* generated by server */ FLUSH STATUS; # 'DROP TABLE IF EXISTS ' is binlogged 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 5b2dc903bc0..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,12 +27,7 @@ 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 TABLE IF EXISTS `t` /* 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 `tmp2`,`t` /* generated by server */ DROP DATABASE `drop-temp+table-test`; RESET MASTER; 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 abc8e5e7538..22c41d8ddac 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 TABLE IF EXISTS `t` /* generated by server */ master-bin.000001 # Query # # use `drop-temp+table-test`; DROP TEMPORARY TABLE IF EXISTS `tmp2` /* 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 60922af490a..81abc1e3505 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 one part. 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 34fc175062b..b8d2152a571 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 one part. 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 c8fe3d98ca8..604be5836c6 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 @@ -427,7 +427,6 @@ 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 TABLE `t1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t2` /* generated by server */ reset master; create table t1 (a int) engine=innodb; create table t2 (a int) engine=myisam; 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_row_drop.result b/mysql-test/suite/rpl/r/rpl_row_drop.result deleted file mode 100644 index e33c395b1aa..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 TABLE `t1` /* generated by server */ -master-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t2` /* 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 c5746c9bbde..5a13bdc3f49 100644 --- a/mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.test +++ b/mysql-test/suite/rpl/t/rpl_gtid_empty_transaction.test @@ -92,8 +92,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..1e8640a5aad --- /dev/null +++ b/mysql-test/suite/rpl_gtid/r/rpl_gtid_row_mix_drop_table.result @@ -0,0 +1,88 @@ +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= '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= '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; +# 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 36bebe78a87..c6157758e9d 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 f59356aee78..7de16dbea0b 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 91447813913..77f64adcc77 100644 --- a/mysql-test/suite/rpl_gtid/t/rpl_gtids_table.test +++ b/mysql-test/suite/rpl_gtid/t/rpl_gtids_table.test @@ -86,6 +86,13 @@ if (`SELECT @@BINLOG_FORMAT = 'ROW' || @@BINLOG_FORMAT = 'MIXED'`) --error ER_BAD_TABLE_ERROR DROP TEMPORARY TABLE tmp1, t3; DROP TEMPORARY TABLE tmp1; +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 4418fc10878..73cfd2d654b 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 @@ -24,7 +24,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_mix_innodb.result b/mysql-test/suite/rpl_nogtid/r/rpl_mix_innodb.result index 416658c12e5..7ed730c98b9 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_mix_innodb.result +++ b/mysql-test/suite/rpl_nogtid/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_nogtid/r/rpl_mixed_drop_create_temp_table.result b/mysql-test/suite/rpl_nogtid/r/rpl_mixed_drop_create_temp_table.result index b9c3b579076..4de84015130 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'; @@ -107,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'; @@ -124,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- @@ -167,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- @@ -186,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- @@ -200,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- @@ -218,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- @@ -277,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- @@ -300,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- @@ -351,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- @@ -374,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- @@ -424,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- @@ -446,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- @@ -468,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- @@ -487,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- @@ -512,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- @@ -530,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- @@ -543,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- @@ -560,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 @@ -582,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 @@ -607,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 @@ -629,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 @@ -655,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'; @@ -678,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'; @@ -694,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'; @@ -714,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'; @@ -760,15 +667,8 @@ DROP TEMPORARY TABLE IF EXISTS tt_xx_1; Warnings: Note 1051 Unknown table 'test.tt_xx_1' ROLLBACK; -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'; @@ -784,18 +684,12 @@ Note 1051 Unknown table 'test.tt_xx_1' ROLLBACK; Warnings: Warning # Some non-transactional changed tables couldn't 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-If-Xe-Temp N 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 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'; @@ -838,11 +732,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'; @@ -865,11 +754,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'; @@ -912,10 +796,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'; @@ -936,14 +816,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'; @@ -955,14 +829,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'; @@ -979,19 +845,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'; @@ -1003,11 +858,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'; @@ -1025,10 +875,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'; @@ -1040,10 +886,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'; @@ -1059,9 +901,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- @@ -1081,9 +920,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 @@ -1106,9 +942,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- @@ -1128,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 # Query # # use `test`; INSERT INTO nt_xx_1() VALUES (1) master-bin.000001 # Query # # COMMIT master-bin.000001 # Query # # BEGIN @@ -1245,17 +1075,12 @@ DROP TABLE tt_tmp_2, nt_tmp_2, nt_2; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ -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-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- 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- @@ -1425,8 +1250,6 @@ 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 TABLE `nt_2` /* generated by server */ -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-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- SET @commands= 'B T Drop-TN-Temp'; @@ -1439,8 +1262,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- ######################################################################### @@ -1457,10 +1278,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'; @@ -1470,10 +1287,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- @@ -1492,15 +1305,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- @@ -1514,12 +1318,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'; @@ -1537,11 +1335,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'; @@ -1555,12 +1348,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'; @@ -1578,11 +1365,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- @@ -1602,16 +1384,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'; @@ -1626,12 +1398,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'; @@ -1653,11 +1419,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'; @@ -1674,12 +1435,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'; @@ -1701,11 +1456,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 152044dfe1b..ebd1438691c 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 26d00ccdf0c..58c74b8c09b 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 @@ -12700,13 +12700,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] @@ -12750,13 +12746,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] @@ -12790,13 +12782,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] @@ -12839,13 +12827,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] @@ -12875,13 +12859,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] @@ -12924,13 +12904,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 f9373acb804..dfca93b8653 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 @@ -13072,13 +13072,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] @@ -13122,13 +13118,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] @@ -13162,13 +13154,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] @@ -13211,13 +13199,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] @@ -13247,13 +13231,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] @@ -13296,13 +13276,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 0a14568ef6b..3f5abde8911 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 @@ -14950,13 +14950,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] @@ -15000,13 +14996,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] @@ -15040,13 +15032,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] @@ -15091,13 +15079,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] @@ -15127,13 +15111,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] @@ -15178,13 +15158,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 7d9d77a8189..d618fa0ee5b 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'; @@ -107,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'; @@ -124,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- @@ -168,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- @@ -189,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- @@ -203,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 */ @@ -222,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 */ @@ -287,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- @@ -312,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- @@ -367,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- @@ -392,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- @@ -445,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 */ @@ -468,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 */ @@ -492,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- @@ -512,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- @@ -540,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- @@ -560,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- @@ -573,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 */ @@ -591,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 @@ -615,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 @@ -643,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 @@ -667,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 @@ -696,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'; @@ -721,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'; @@ -738,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'; @@ -758,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'; @@ -806,16 +711,8 @@ DROP TEMPORARY TABLE IF EXISTS tt_xx_1; Warnings: Note 1051 Unknown table 'test.tt_xx_1' ROLLBACK; -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'; @@ -831,7 +728,6 @@ Note 1051 Unknown table 'test.tt_xx_1' ROLLBACK; Warnings: Warning # Some non-transactional changed tables couldn't 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-If-Xe-Temp N 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 @@ -839,12 +735,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'; @@ -888,12 +778,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'; @@ -917,12 +801,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 +844,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'; @@ -990,15 +864,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'; @@ -1010,15 +878,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'; @@ -1035,21 +894,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'; @@ -1061,12 +908,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'; @@ -1085,11 +926,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'; @@ -1101,10 +937,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'; @@ -1120,9 +952,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 @@ -1143,9 +972,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 @@ -1170,9 +996,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 @@ -1193,9 +1016,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 @@ -1312,17 +1132,12 @@ DROP TABLE tt_tmp_2, nt_tmp_2, nt_2; include/show_binlog_events.inc Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # use `test`; DROP TABLE `nt_2` /* generated by server */ -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-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- 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- @@ -1504,8 +1319,6 @@ 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 TABLE `nt_2` /* generated by server */ -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-N-TN-Temp << -e-e-e-e-e-e-e-e-e-e-e- SET @commands= 'B T Drop-TN-Temp'; @@ -1519,8 +1332,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- ######################################################################### @@ -1537,10 +1348,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'; @@ -1550,10 +1357,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- @@ -1572,15 +1375,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 */ @@ -1595,12 +1389,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'; @@ -1619,11 +1407,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'; @@ -1637,12 +1420,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'; @@ -1661,11 +1438,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- @@ -1685,16 +1457,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'; @@ -1709,12 +1471,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'; @@ -1737,11 +1493,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'; @@ -1758,12 +1509,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'; @@ -1786,11 +1531,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 b251f9959cc..7495c2f8647 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 0a14568ef6b..3f5abde8911 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 @@ -14950,13 +14950,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] @@ -15000,13 +14996,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] @@ -15040,13 +15032,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] @@ -15091,13 +15079,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] @@ -15127,13 +15111,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] @@ -15178,13 +15158,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_semi_sync.result b/mysql-test/suite/rpl_nogtid/r/rpl_semi_sync.result index 98ee1275c2d..5110bd19bae 100644 --- a/mysql-test/suite/rpl_nogtid/r/rpl_semi_sync.result +++ b/mysql-test/suite/rpl_nogtid/r/rpl_semi_sync.result @@ -139,6 +139,7 @@ INSERT INTO t2 VALUES(22); COMMIT; DROP TABLE t2, t3; SET SESSION AUTOCOMMIT= 1; +FLUSH STATUS; include/sync_slave_sql_with_master.inc # # Test semi-sync master will switch OFF after one transaction @@ -156,7 +157,7 @@ Variable_name Value Rpl_semi_sync_master_no_tx 0 show status like 'Rpl_semi_sync_master_yes_tx'; Variable_name Value -Rpl_semi_sync_master_yes_tx 15 +Rpl_semi_sync_master_yes_tx 1 show status like 'Rpl_semi_sync_master_clients'; Variable_name Value Rpl_semi_sync_master_clients 0 @@ -171,7 +172,7 @@ Variable_name Value Rpl_semi_sync_master_no_tx 1 show status like 'Rpl_semi_sync_master_yes_tx'; Variable_name Value -Rpl_semi_sync_master_yes_tx 15 +Rpl_semi_sync_master_yes_tx 1 insert into t1 values (100); [ master status should be OFF ] show status like 'Rpl_semi_sync_master_status'; @@ -182,7 +183,7 @@ Variable_name Value Rpl_semi_sync_master_no_tx 12 show status like 'Rpl_semi_sync_master_yes_tx'; Variable_name Value -Rpl_semi_sync_master_yes_tx 15 +Rpl_semi_sync_master_yes_tx 1 # # Test semi-sync status on master will be ON again when slave catches up # @@ -215,7 +216,7 @@ Variable_name Value Rpl_semi_sync_master_no_tx 12 show status like 'Rpl_semi_sync_master_yes_tx'; Variable_name Value -Rpl_semi_sync_master_yes_tx 15 +Rpl_semi_sync_master_yes_tx 1 show status like 'Rpl_semi_sync_master_clients'; Variable_name Value Rpl_semi_sync_master_clients 1 @@ -235,7 +236,7 @@ Variable_name Value Rpl_semi_sync_master_no_tx 12 SHOW STATUS LIKE 'Rpl_semi_sync_master_yes_tx'; Variable_name Value -Rpl_semi_sync_master_yes_tx 16 +Rpl_semi_sync_master_yes_tx 2 FLUSH NO_WRITE_TO_BINLOG STATUS; [ Semi-sync master status variables after FLUSH STATUS ] SHOW STATUS LIKE 'Rpl_semi_sync_master_no_tx'; 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 1d70c4a486a..58654ba3aba 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'; @@ -108,7 +106,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'; @@ -125,7 +123,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'; @@ -277,7 +275,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- @@ -300,8 +297,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- @@ -351,7 +346,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- @@ -374,8 +369,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- @@ -424,7 +419,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) @@ -446,13 +441,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) @@ -760,15 +755,8 @@ DROP TEMPORARY TABLE IF EXISTS tt_xx_1; Warnings: Note 1051 Unknown table 'test.tt_xx_1' ROLLBACK; -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'; @@ -784,18 +772,12 @@ Note 1051 Unknown table 'test.tt_xx_1' ROLLBACK; Warnings: Warning # Some non-transactional changed tables couldn't 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-If-Xe-Temp N 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 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'; @@ -841,7 +823,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- @@ -867,8 +849,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- @@ -914,7 +896,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- @@ -936,13 +918,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 870400d8f84..854affed386 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 @@ -24,7 +24,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 997838f6e4a..876bda6b3ff 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 ed7d3714047..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 @@ -60,11 +60,9 @@ slave-bin.000001 # Query # # use `test`; CREATE TABLE t2 ( i1 INT NOT NULL AUTO_ 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 TABLE `t2` /* generated by server */ -slave-bin.000001 # Query # # use `test`; DROP TEMPORARY TABLE IF EXISTS `t1_tmp` /* 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_semi_sync.test b/mysql-test/suite/rpl_nogtid/t/rpl_semi_sync.test index 419c212cdd7..b4d18dc1173 100644 --- a/mysql-test/suite/rpl_nogtid/t/rpl_semi_sync.test +++ b/mysql-test/suite/rpl_nogtid/t/rpl_semi_sync.test @@ -236,6 +236,11 @@ COMMIT; DROP TABLE t2, t3; SET SESSION AUTOCOMMIT= 1; + +# The temporary table above will be binlogged in statement mode only, resulting +# in different Rpl_semi_sync_master_yes_tx values in statement vs row/mixed. Reset it. +FLUSH STATUS; + --source include/sync_slave_sql_with_master.inc 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 8ebd71c1d92..29efd33c038 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 @@ -59,13 +59,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. # @@ -74,17 +68,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. # @@ -97,39 +90,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 @@ -154,7 +145,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 @@ -186,8 +177,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 e8b67b9eee8..0457cd0dd29 100644 --- a/sql/sql_table.cc +++ b/sql/sql_table.cc @@ -2751,7 +2751,9 @@ public: base_atomic_tables(PSI_INSTRUMENT_ME), base_non_atomic_tables(PSI_INSTRUMENT_ME), tmp_trans_tables(PSI_INSTRUMENT_ME), + tmp_trans_tables_to_binlog(PSI_INSTRUMENT_ME), tmp_non_trans_tables(PSI_INSTRUMENT_ME), + tmp_non_trans_tables_to_binlog(PSI_INSTRUMENT_ME), nonexistent_tables(PSI_INSTRUMENT_ME), views(PSI_INSTRUMENT_ME), dropped_non_atomic(PSI_INSTRUMENT_ME), @@ -2770,7 +2772,9 @@ public: Prealloced_array base_atomic_tables; Prealloced_array base_non_atomic_tables; Prealloced_array tmp_trans_tables; + Prealloced_array tmp_trans_tables_to_binlog; Prealloced_array tmp_non_trans_tables; + Prealloced_array tmp_non_trans_tables_to_binlog; Prealloced_array nonexistent_tables; Prealloced_array views; @@ -2790,11 +2794,21 @@ public: return tmp_trans_tables.size() != 0; } + bool has_tmp_trans_tables_to_binlog() const + { + return tmp_trans_tables_to_binlog.size() != 0; + } + bool has_tmp_non_trans_tables() const { return tmp_non_trans_tables.size() != 0; } + bool has_tmp_non_trans_tables_to_binlog() const + { + return tmp_non_trans_tables_to_binlog.size() != 0; + } + bool has_any_nonexistent_tables() const { return nonexistent_tables.size() != 0; @@ -3059,10 +3073,6 @@ rm_table_sort_into_groups(THD *thd, Drop_tables_ctx *drop_ctx, other hand it can't fail once first simple checks are done. So it makes sense to drop them after base tables. - If the current binlog format is row, the IF EXISTS clause needs to be - appended because one does not know if CREATE TEMPORARY was previously - written to the binary log. - Unlike for base tables, it is possible to drop database in which some connection has temporary tables open. So we can end-up in situation when connection's default database is no more, but still the connection @@ -3144,9 +3154,17 @@ rm_table_sort_into_groups(THD *thd, Drop_tables_ctx *drop_ctx, DBUG_ASSERT(table->table->query_id == thd->query_id); if (table->table->file->has_transactions()) + { drop_ctx->tmp_trans_tables.push_back(table); + if (table->table->should_binlog_drop_if_temp()) + drop_ctx->tmp_trans_tables_to_binlog.push_back(table); + } else + { drop_ctx->tmp_non_trans_tables.push_back(table); + if (table->table->should_binlog_drop_if_temp()) + drop_ctx->tmp_non_trans_tables_to_binlog.push_back(table); + } continue; } } @@ -3291,13 +3309,13 @@ rm_table_eval_gtid_and_table_groups_state(THD *thd, Drop_tables_ctx *drop_ctx) /* Only DROP DATABASE drops views. */ DBUG_ASSERT(!drop_ctx->has_views()); - if ((drop_ctx->has_tmp_trans_tables() && - drop_ctx->has_tmp_non_trans_tables()) || + if ((drop_ctx->has_tmp_trans_tables_to_binlog() && + drop_ctx->has_tmp_non_trans_tables_to_binlog()) || ((drop_ctx->has_base_non_atomic_tables() || drop_ctx->has_base_atomic_tables() || drop_ctx->has_base_nonexistent_tables()) && - (drop_ctx->has_tmp_trans_tables() || - drop_ctx->has_tmp_non_trans_tables()))) + (drop_ctx->has_tmp_trans_tables_to_binlog() || + drop_ctx->has_tmp_non_trans_tables_to_binlog()))) { /* Prohibited case. We have either both kinds of temporary tables or @@ -3343,8 +3361,8 @@ rm_table_eval_gtid_and_table_groups_state(THD *thd, Drop_tables_ctx *drop_ctx) Can be logged as one atomic multi-table DROP TABLES statement. Other groups are empty. */ - DBUG_ASSERT(!drop_ctx->has_tmp_trans_tables()); - DBUG_ASSERT(!drop_ctx->has_tmp_non_trans_tables()); + DBUG_ASSERT(!drop_ctx->has_tmp_trans_tables_to_binlog()); + DBUG_ASSERT(!drop_ctx->has_tmp_non_trans_tables_to_binlog()); drop_ctx->gtid_and_table_groups_state= Drop_tables_ctx::GTID_SINGLE_TABLE_GROUP; } @@ -3361,7 +3379,7 @@ rm_table_eval_gtid_and_table_groups_state(THD *thd, Drop_tables_ctx *drop_ctx) DBUG_ASSERT(!drop_ctx->has_base_non_atomic_tables()); DBUG_ASSERT(!drop_ctx->has_base_atomic_tables() && !drop_ctx->has_base_nonexistent_tables()); - DBUG_ASSERT(!drop_ctx->has_tmp_non_trans_tables()); + DBUG_ASSERT(!drop_ctx->has_tmp_non_trans_tables_to_binlog()); drop_ctx->gtid_and_table_groups_state= Drop_tables_ctx::GTID_SINGLE_TABLE_GROUP; } @@ -3801,19 +3819,6 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, DBUG_RETURN(true); } - /* - Check early if default database exists. We don't want code responsible - for dropping temporary tables fail due to this check after some tables - were dropped already. - */ - if (thd->db().str != NULL) - { - bool exists= false; - if (dd::schema_exists(thd, thd->db().str, &exists)) - DBUG_RETURN(true); - default_db_doesnt_exist= !exists; - } - if (drop_ctx.if_exists && drop_ctx.has_any_nonexistent_tables()) { for (TABLE_LIST *table : drop_ctx.nonexistent_tables) @@ -3827,6 +3832,36 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, } } + /* Non-existent temporary tables with IF EXISTS do not need any + further processing */ + if (drop_ctx.if_exists && drop_ctx.has_tmp_nonexistent_tables()) + { + drop_ctx.nonexistent_tables.clear(); + + /* If such tables were all we had, there is nothing else to do */ + if (!drop_ctx.has_base_atomic_tables() + && !drop_ctx.has_base_non_atomic_tables() + && !drop_ctx.has_tmp_trans_tables() + && !drop_ctx.has_tmp_non_trans_tables() + && !drop_ctx.has_views()) + { + DBUG_RETURN(false); + } + } + + /* + Check early if default database exists. We don't want code responsible + for dropping temporary tables fail due to this check after some tables + were dropped already. + */ + if (thd->db().str != NULL) + { + bool exists= false; + if (dd::schema_exists(thd, thd->db().str, &exists)) + DBUG_RETURN(true); + default_db_doesnt_exist= !exists; + } + if (drop_ctx.has_base_non_atomic_tables()) { /* @@ -4243,6 +4278,23 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, */ if (drop_ctx.has_tmp_non_trans_tables()) { + for (TABLE_LIST *table : drop_ctx.tmp_non_trans_tables) + { + /* + Don't check THD::killed flag. We can't rollback deletion of + temporary table, so aborting on KILL will make DROP TABLES + less atomic. + OTOH it is unlikely that we have many temporary tables to drop + so being immune to KILL is not that horrible in most cases. + */ + drop_temporary_table(thd, table); + } + thd->get_transaction()->mark_dropped_temp_table(Transaction_ctx::STMT); + } + + if (drop_ctx.has_tmp_non_trans_tables_to_binlog()) + { + DBUG_ASSERT(drop_ctx.has_tmp_non_trans_tables()); /* Handle non-transactional temporary tables. */ @@ -4251,38 +4303,20 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, DBUG_ASSERT(!drop_ctx.drop_database); /* - If the current format is row, the IF EXISTS clause needs to be - appended because one does not know if CREATE TEMPORARY was - previously written to the binary log. - If default database does not exist, 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 fully-qualified table name and we don't write "USE db" prefix. */ - bool log_if_exists= (thd->is_current_stmt_binlog_format_row() || - drop_ctx.if_exists); - bool is_drop_tmp_if_exists_with_no_defaultdb= log_if_exists && + bool is_drop_tmp_if_exists_with_no_defaultdb= drop_ctx.if_exists && default_db_doesnt_exist; Drop_tables_query_builder built_query(thd, true /* DROP TEMPORARY */, - log_if_exists, false /* stmt cache */, + drop_ctx.if_exists, false /* stmt cache */, is_drop_tmp_if_exists_with_no_defaultdb); - for (TABLE_LIST *table : drop_ctx.tmp_non_trans_tables) - { - /* - Don't check THD::killed flag. We can't rollback deletion of - temporary table, so aborting on KILL will make DROP TABLES - less atomic. - OTOH it is unlikely that we have many temporary tables to drop - so being immune to KILL is not that horrible in most cases. - */ - drop_temporary_table(thd, table); - } - - built_query.add_array(drop_ctx.tmp_non_trans_tables); + built_query.add_array(drop_ctx.tmp_non_trans_tables_to_binlog); /* If there are no transactional temporary tables to be dropped @@ -4293,7 +4327,6 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, if (drop_ctx.drop_temporary && !drop_ctx.has_tmp_trans_tables()) built_query.add_array(drop_ctx.nonexistent_tables); - thd->get_transaction()->mark_dropped_temp_table(Transaction_ctx::STMT); thd->thread_specific_used= true; if (built_query.write_bin_log()) @@ -4362,7 +4395,23 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, } } - if (drop_ctx.has_tmp_trans_tables() || + if (drop_ctx.has_tmp_trans_tables()) + { + for (TABLE_LIST *table : drop_ctx.tmp_trans_tables) + { + /* + Don't check THD::killed flag. We can't rollback deletion of + temporary table, so aborting on KILL will make DROP TABLES + less atomic. + OTOH it is unlikely that we have many temporary tables to drop + so being immune to KILL is not that horrible in most cases. + */ + drop_temporary_table(thd, table); + } + thd->get_transaction()->mark_dropped_temp_table(Transaction_ctx::STMT); + } + + if (drop_ctx.has_tmp_trans_tables_to_binlog() || (!drop_ctx.has_tmp_non_trans_tables() && drop_ctx.has_tmp_nonexistent_tables())) { @@ -4375,10 +4424,6 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, DBUG_ASSERT(!drop_ctx.drop_database); /* - If the current format is row, the IF EXISTS clause needs to be - appended because one does not know if CREATE TEMPORARY was - previously written to the binary log. - If default database does not exist, set 'is_drop_tmp_if_exists_with_no_defaultdb flag to 'true', so that the 'DROP TEMPORARY TABLE IF EXISTS' command is logged @@ -4391,29 +4436,15 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, this case and DROP TEMPORARY TABLES where it is really needed is exempted from this rule. */ - bool log_if_exists= (thd->is_current_stmt_binlog_format_row() || - drop_ctx.if_exists); - bool is_drop_tmp_if_exists_with_no_defaultdb= log_if_exists && + bool is_drop_tmp_if_exists_with_no_defaultdb= drop_ctx.if_exists && default_db_doesnt_exist; Drop_tables_query_builder built_query(thd, true /* DROP TEMPORARY */, - log_if_exists, + drop_ctx.if_exists, drop_ctx.drop_temporary /* trx/stmt cache */, is_drop_tmp_if_exists_with_no_defaultdb); - for (TABLE_LIST *table : drop_ctx.tmp_trans_tables) - { - /* - Don't check THD::killed flag. We can't rollback deletion of - temporary table, so aborting on KILL will make DROP TABLES - less atomic. - OTOH it is unlikely that we have many temporary tables to drop - so being immune to KILL is not that horrible in most cases. - */ - drop_temporary_table(thd, table); - } - - built_query.add_array(drop_ctx.tmp_trans_tables); + built_query.add_array(drop_ctx.tmp_trans_tables_to_binlog); /* Add non-existent temporary tables to this group if there are some @@ -4424,7 +4455,6 @@ bool mysql_rm_table_no_locks(THD *thd, TABLE_LIST *tables, bool if_exists, if (drop_ctx.drop_temporary) built_query.add_array(drop_ctx.nonexistent_tables); - thd->get_transaction()->mark_dropped_temp_table(Transaction_ctx::STMT); thd->thread_specific_used= true; if (built_query.write_bin_log()) @@ -12951,9 +12981,10 @@ bool mysql_alter_table(THD *thd, const char *new_db, const char *new_name, if (create_info->options & HA_LEX_CREATE_TMP_TABLE) { - if (!open_table_uncached(thd, alter_ctx.get_tmp_path(), - alter_ctx.new_db, alter_ctx.tmp_name, - true, true, table_def)) + if (thd->decide_logging_format(table_list) + || !open_table_uncached(thd, alter_ctx.get_tmp_path(), + alter_ctx.new_db, alter_ctx.tmp_name, + true, true, table_def)) goto err_new_table_cleanup; /* in case of alter temp table send the tracker in OK packet */ if (thd->session_tracker.get_tracker(SESSION_STATE_CHANGE_TRACKER)->is_enabled())