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