1
# This one assumes we are ignoring updates on table mysqltest_foo, but doing
2
# the ones on all other tables
4
source include/master-slave.inc;
8
# For this test we must be in the test database
13
drop table if exists mysqltest_foo;
14
drop table if exists mysqltest_bar;
17
create table mysqltest_foo (n int);
18
insert into mysqltest_foo values(4);
21
create table mysqltest_foo (n int);
22
insert into mysqltest_foo values(5);
23
create table mysqltest_bar (m int);
24
insert into mysqltest_bar values(15);
25
create table t1 (k int);
26
insert into t1 values(55);
30
select mysqltest_foo.n,mysqltest_bar.m,t1.k from mysqltest_foo,mysqltest_bar,t1;
32
drop table mysqltest_foo,mysqltest_bar,t1;
36
drop table mysqltest_foo,mysqltest_bar,t1;