Debian Codegraph @

mysql-test/suite/rpl/t/rpl_create_drop_function.test

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