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