1# This one assumes we are ignoring updates on table mysqltest_foo, but doing 2# the ones on all other tables 3 4source include/master-slave.inc; 5connection slave; 6 7# 8# For this test we must be in the test database 9# 10use test; 11 12--disable_warnings 13drop table if exists mysqltest_foo; 14drop table if exists mysqltest_bar; 15--enable_warnings 16 17create table mysqltest_foo (n int); 18insert into mysqltest_foo values(4); 19connection master; 20use test; 21create table mysqltest_foo (n int); 22insert into mysqltest_foo values(5); 23create table mysqltest_bar (m int); 24insert into mysqltest_bar values(15); 25create table t1 (k int); 26insert into t1 values(55); 27--sync_slave_with_master 28select mysqltest_foo.n,mysqltest_bar.m,t1.k from mysqltest_foo,mysqltest_bar,t1; 29connection master; 30drop table mysqltest_foo,mysqltest_bar,t1; 31--sync_slave_with_master 32drop table mysqltest_foo,mysqltest_bar,t1; 33 34# End of 4.1 tests 35--source include/rpl_end.inc 36