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:
Tags: udf

[6 Jun 2011 9:14] Miranda Killz
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
[7 Jun 2011 11:46] Miranda Killz
Actually someone should have used the same directory and modified some files.
The ticket should be closed.
[10 Nov 2011 11:38] Juan Miguel Cejuela
I answered this in stackoverflow: http://stackoverflow.com/questions/6203626/cannot-use-a-mysql-udf-function/8078903#8078903