Debian Codegraph @

mysql-test/suite/rpl/r/rpl_create_drop_udf.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
5 SELECT metaphon('master');
6 metaphon('master')
7 MSTR
8 CREATE FUNCTION metaphon RETURNS INT SONAME "UDF_EXAMPLE_LIB";
9 ERROR HY000: Function 'metaphon' already exists
10 connection slave;
11 SELECT metaphon('slave');
12 metaphon('slave')
13 SLF
14 connection master;
15 CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
16 Warnings:
17 Note 1125 Function 'metaphon' already exists
18 DROP FUNCTION IF EXISTS random_function_name;
19 Warnings:
20 Note 1305 FUNCTION test.random_function_name does not exist
21 CREATE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
22 Warnings:
23 Note 1125 Function 'metaphon' already exists
24 CREATE OR REPLACE FUNCTION IF NOT EXISTS metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
25 ERROR HY000: Incorrect usage of OR REPLACE and IF NOT EXISTS
26 connection slave;
27 SELECT metaphon('slave');
28 metaphon('slave')
29 SLF
30 connection master;
31 DROP FUNCTION metaphon;
32 CREATE OR REPLACE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
33 CREATE FUNCTION metaphon RETURNS STRING SONAME "UDF_EXAMPLE_LIB";
34 ERROR HY000: Function 'metaphon' already exists
35 connection slave;
36 SELECT metaphon('slave');
37 metaphon('slave')
38 SLF
39 connection master;
40 DROP FUNCTION metaphon;
41 DROP FUNCTION IF EXISTS metaphon;
42 Warnings:
43 Note 1305 FUNCTION test.metaphon does not exist
44 connection slave;
45 DROP FUNCTION metaphon;
46 ERROR 42000: FUNCTION test.metaphon does not exist
47 DROP FUNCTION IF EXISTS metaphon;
48 Warnings:
49 Note 1305 FUNCTION test.metaphon does not exist
50 include/rpl_end.inc