--source include/have_row_based.inc --source include/have_binlog_format_row.inc let $SERVER_VERSION=`select version()`; #This test case is not written for NDB, the result files #will not match when NDB is the default engine -- source include/not_ndb_default.inc --source include/master-slave.inc # Bug#15942 (RBR ignores --binlog_ignore_db and tries to map to table # on slave for writes) CREATE DATABASE test_ignore; # --binlog_ignore_db=mysqltest_ignore --echo **** On Master **** SHOW DATABASES; USE test; CREATE TABLE t1 (a INT, b INT); SHOW TABLES; INSERT INTO t1 VALUES (1,1), (2,2); USE test_ignore; CREATE TABLE t2 (a INT, b INT); SHOW TABLES; INSERT INTO t2 VALUES (3,3), (4,4); --replace_regex /table_id: [0-9]+/table_id: #/ SHOW BINLOG EVENTS FROM 102; sync_slave_with_master; --echo **** On Slave **** SHOW DATABASES; USE test; SHOW TABLES; --error 1049 USE test_ignore; connection master; DROP DATABASE test_ignore; sync_slave_with_master; # Bug#19995: Extreneous table maps generated for statements that does # not generate rows --disable_query_log --source include/master-slave-reset.inc --enable_query_log connection master; CREATE TABLE t1 (a INT); DELETE FROM t1; INSERT INTO t1 VALUES (1),(2); DELETE FROM t1 WHERE a = 0; UPDATE t1 SET a=99 WHERE a = 0; --replace_result $SERVER_VERSION SERVER_VERSION --replace_regex /table_id: [0-9]+/table_id: #/ SHOW BINLOG EVENTS; DROP TABLE t1; # BUG#17620: Replicate (Row Based) Fails when Query Cache enabled on # slave --echo ================ Test for BUG#17620 ================ --disable_query_log --source include/master-slave-reset.inc --enable_query_log --echo **** On Slave **** connection slave; SET GLOBAL QUERY_CACHE_SIZE=0; --echo **** On Master **** connection master; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1),(2),(3); --echo **** On Slave **** sync_slave_with_master; SET GLOBAL QUERY_CACHE_SIZE=16*1024*1024; --echo **** On Master **** connection master; INSERT INTO t1 VALUES (4),(5),(6); --echo **** On Slave **** sync_slave_with_master; SELECT * FROM t1; --echo **** On Master **** connection master; INSERT INTO t1 VALUES (7),(8),(9); --echo **** On Slave **** sync_slave_with_master; SELECT * FROM t1; DROP TABLE t1;