1# regression test for
2# Bug#36099 replicate-do-db affects replaying RBR events with mysqlbinlog
3# The test verifies that the slave side filtering rule does not affect
4# applying of row-events on master via mysqlbinlog
5
6-- source include/have_log_bin.inc
7-- source include/not_embedded.inc
8-- source include/have_binlog_format_row.inc
9
10--disable_warnings
11drop table if exists t1;
12--enable_warnings
13
14reset master;
15
16create table t1 (a int);
17insert into t1 values (1);
18
19let $MYSQLD_DATADIR= `select @@datadir`;
20flush logs;
21--exec $MYSQL_BINLOG  $MYSQLD_DATADIR/master-bin.000001 > $MYSQLTEST_VARDIR/tmp/bug36099.sql
22
23drop table t1;
24--exec $MYSQL -e "source $MYSQLTEST_VARDIR/tmp/bug36099.sql"
25
26--echo *** must be 1 ***
27select * from t1;
28
29# cleanup
30
31drop table t1;
32remove_file $MYSQLTEST_VARDIR/tmp/bug36099.sql;
33