diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/binlog/r/binlog_tmp_table.result | 1 | ||||
| -rw-r--r-- | mysql-test/suite/binlog/t/binlog_tmp_table.test | 6 |
2 files changed, 6 insertions, 1 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_tmp_table.result b/mysql-test/suite/binlog/r/binlog_tmp_table.result index f15130ad42c..91702aa7335 100644 --- a/mysql-test/suite/binlog/r/binlog_tmp_table.result +++ b/mysql-test/suite/binlog/r/binlog_tmp_table.result @@ -1,3 +1,4 @@ +RESET MASTER; create table foo (a int); flush logs; create temporary table tmp1_foo like foo; diff --git a/mysql-test/suite/binlog/t/binlog_tmp_table.test b/mysql-test/suite/binlog/t/binlog_tmp_table.test index 982ba9eedac..d4ca7226a64 100644 --- a/mysql-test/suite/binlog/t/binlog_tmp_table.test +++ b/mysql-test/suite/binlog/t/binlog_tmp_table.test @@ -28,6 +28,8 @@ source include/have_log_bin.inc; source include/have_binlog_format_mixed_or_statement.inc; +RESET MASTER; + --disable_query_log CALL mtr.add_suppression("Unsafe statement binlogged in statement format since BINLOG_FORMAT = STATEMENT"); --enable_query_log @@ -71,6 +73,8 @@ truncate table tmp1_foo; connection master1; truncate table tmp2_foo; +let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1); + flush logs; connection default; @@ -82,7 +86,7 @@ create table foo (a int); # replay from binary log let $MYSQLD_DATADIR= `select @@datadir`; -exec $MYSQL_BINLOG $MYSQLD_DATADIR/master-bin.000002 | $MYSQL; +exec $MYSQL_BINLOG $MYSQLD_DATADIR/$binlog_file | $MYSQL; select * from foo; # clean up |