MySQL Bugs: #61421: Cannot use a MySQL UDF function

Bug #61421	Cannot use a MySQL UDF function
Submitted:	6 Jun 2011 9:14	Modified:	7 Jun 2011 11:45
Reporter:	Miranda Killz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.1.41-3ubuntu12.10	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	udf

Description:
Hello.

I have loaded an UDF function into MySQL (without having selected any particular DB). It used to work well during my session but now I can neither use nor drop the function.

Thanks in advance.

Note: there is no space problem like ("select myfunction ('aaa');") as reported on several other websites.

How to repeat:
I have loaded an UDF function into MySQL (without having selected any particular DB). It used to work well during my session but now I get the error "ERROR 1305 (42000): FUNCTION currentdatabase.myfunction does not exist" when I try to use the function with the following sql statement :

select myfunction('aaa');
I then tried to drop the function and I got the same error code :

mysql> drop function myfunction;
ERROR 1305 (42000): FUNCTION database.myfunction does not exist
if a DB is selected.

Another error code otherwise :

ERROR 1046 (3D000): No database selected
So I decided to specify again the function and I got the following error code :

CREATE FUNCTION myfunction RETURNS INT SONAME 'myfunction.so';
ERROR 1125 (HY000): Function 'myfunction' already exists

Actually someone should have used the same directory and modified some files.
The ticket should be closed.

I answered this in stackoverflow: http://stackoverflow.com/questions/6203626/cannot-use-a-mysql-udf-function/8078903#8078903