1include/master-slave.inc
2[connection master]
3connection slave;
4create database mysqltest;
5connection master;
6drop database if exists mysqltest;
7Warnings:
8Note	1008	Can't drop database 'mysqltest'; database doesn't exist
9connection slave;
10show tables from mysqltest;
11ERROR 42000: Unknown database 'mysqltest'
12connection slave;
13create table t1 (a int);
14connection master;
15drop table if exists t1;
16Warnings:
17Note	1051	Unknown table 'test.t1'
18connection slave;
19select * from t1;
20ERROR 42S02: Table 'test.t1' doesn't exist
21connection master;
22create table t1 (a int, b int);
23connection slave;
24insert into t1 values(1,1);
25connection master;
26delete from t1;
27connection slave;
28select * from t1;
29a	b
30insert into t1 values(1,1);
31connection master;
32insert into t1 values(2,1);
33update t1 set a=2;
34connection slave;
35select * from t1;
36a	b
372	1
382	1
39connection master;
40create table t2 (a int, b int);
41delete from t1;
42insert into t1 values(1,1);
43insert into t2 values(1,1);
44connection slave;
45update t1 set a=2;
46connection master;
47UPDATE t1, t2 SET t1.a = t2.a;
48connection slave;
49select * from t1;
50a	b
511	1
52select * from t2;
53a	b
541	1
55connection master;
56delete from t1;
57delete from t2;
58connection slave;
59insert into t1 values(1,1);
60insert into t2 values(1,1);
61connection master;
62DELETE t1.*, t2.* from t1, t2;
63connection slave;
64select * from t1;
65a	b
66select * from t2;
67a	b
68connection master;
69drop table t1, t2;
70connection slave;
71include/rpl_end.inc
72