DROP FUNCTION for UDF functions is not replicated
Bug #1376278 reported by
Philip Stoev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership | Status tracked in 5.6 | |||||
5.6 |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
DROP FUNCTION , which is used to drop UDF functions is not replicated. CREATE FUNCTION is replicated properly.
http://
affects: | percona-xtradb-cluster → codership-mysql |
To post a comment you must log in.
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