1include/master-slave.inc
2[connection master]
3connection master;
4DROP FUNCTION test.f1;
5DROP TABLE IF EXISTS test.t1;
6create table test.t1 (a int, PRIMARY KEY(a));
7create function test.f1(i int) returns int
8begin
9insert into test.t1 values(i);
10return 0;
11end//
12select test.f1(1);
13test.f1(1)
140
15select test.f1(2);
16test.f1(2)
170
18select * from test.t1;
19a
201
212
22connection slave;
23connection slave;
24select * from test.t1;
25a
261
272
28connection master;
29DROP FUNCTION test.f1;
30DROP TABLE test.t1;
31connection slave;
32include/rpl_end.inc
33