Debian Codegraph @

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

raw
1 --source include/have_udf.inc
2 --source include/master-slave.inc
3
4 connection master;
5
6 --replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
7 eval CREATE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
8 SELECT metaphon('master');
9
10 --replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
11 --error ER_UDF_EXISTS
12 eval CREATE FUNCTION metaphon RETURNS INT SONAME "$UDF_EXAMPLE_SO";
13
14 sync_slave_with_master;
15
16 SELECT metaphon('slave');
17
18 connection master;
19
20 --replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
21 eval CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
22 DROP FUNCTION IF EXISTS random_function_name;
23 --replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
24 eval CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
25
26 --replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
27 --error ER_WRONG_USAGE
28 eval CREATE OR REPLACE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
29 sync_slave_with_master;
30
31 SELECT metaphon('slave');
32
33 connection master;
34 DROP FUNCTION metaphon;
35
36 --replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
37 eval CREATE OR REPLACE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
38
39 --replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
40 --error ER_UDF_EXISTS
41 eval CREATE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_SO";
42 sync_slave_with_master;
43
44 SELECT metaphon('slave');
45
46 connection master;
47 DROP FUNCTION metaphon;
48 DROP FUNCTION IF EXISTS metaphon;
49 sync_slave_with_master;
50
51 --error ER_SP_DOES_NOT_EXIST
52 DROP FUNCTION metaphon;
53
54 DROP FUNCTION IF EXISTS metaphon;
55
56 --source include/rpl_end.inc