DROP FUNCTION for UDF functions is not replicated

[Philip Stoev]

DROP FUNCTION , which is used to drop UDF functions is not replicated. CREATE FUNCTION is replicated properly.

http://dev.mysql.com/doc/refman/5.6/en/drop-function-udf.html

[Marc Castrovinci (marc-castrovinci)]

I'm not seeing the same results. It seems to be working as expected. Can you post an example of a function you're having issues with?

My test...

Server version: 5.6.20-68.0-56-log Percona XtraDB Cluster (GPL), Release 25.7, wsrep_25.7.r4126

Server A
-------------
mysql> CREATE FUNCTION hello (s CHAR(20))
    -> RETURNS CHAR(50) DETERMINISTIC
    -> RETURN CONCAT('Hello, ',s,'!');
Query OK, 0 rows affected (0.02 sec)

Server B
-------------
mysql> SELECT hello('world');
+----------------+
| hello('world') |
+----------------+
| Hello, world! |
+----------------+
1 row in set (0.00 sec)

Server A
--------------
mysql> drop function hello;
Query OK, 0 rows affected (0.04 sec)

Server B
-------------
mysql> SELECT hello('world');
ERROR 1305 (42000): FUNCTION foobar.hello does not exist

[Philip Stoev (philip-stoev-f)]

Hello,

You are trying with a SQL function, whereas the issue only demonstrate itself with a UDF function, a function defined in an external dynamically-loaded library.