1--source include/master-slave.inc
2
3connection master;
4
5CREATE FUNCTION hello (str CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN
6CONCAT('Hello, ', str, '!');
7
8--error ER_SP_ALREADY_EXISTS
9CREATE FUNCTION hello (str CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN
10CONCAT('Hello, ', str, '!');
11
12sync_slave_with_master;
13
14SHOW CREATE FUNCTION hello;
15
16connection master;
17
18--error ER_WRONG_USAGE
19CREATE OR REPLACE FUNCTION IF NOT EXISTS hello (str CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN
20CONCAT('Hello, ', str, '!');
21
22CREATE OR REPLACE FUNCTION hello (str CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN
23CONCAT('Hello, ', str, '!');
24
25SELECT hello('master');
26sync_slave_with_master;
27
28SELECT hello('slave');
29
30connection master;
31CREATE FUNCTION IF NOT EXISTS hello (str CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN
32CONCAT('Hello, ', str, '!');
33
34CREATE OR REPLACE FUNCTION bye (str CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN
35CONCAT('Bye, ', str, '!');
36
37SELECT hello('master');
38SELECT bye('master');
39sync_slave_with_master;
40
41SELECT hello('slave');
42SELECT bye('slave');
43
44connection master;
45DROP FUNCTION hello;
46DROP FUNCTION IF EXISTS bye;
47sync_slave_with_master;
48
49--error ER_SP_DOES_NOT_EXIST
50DROP FUNCTION hello;
51
52DROP FUNCTION IF EXISTS bye;
53
54--source include/rpl_end.inc
55