Description:
until now, everything goes fine.. but today, i want to write a simple function to return a simple value from a table. function is succesfully created and i start to use it. after a while i must add some code in it and i drop the function. when i want to drop the function i get "function SEHIR_DONDER is not exist" error message... i dont know why mysql gives this message.. i simply ignore the message and write new function with the same name.. when i want to compile the function, this time i get "function SEHIR_DONDER is already exists".. i can not create the funciton again.. i spent hours with trying some possibilities to overcome this problem but i can not. i changed the name of the function to smt else.. but take the error again.. after some hours. i decide to drop the database and use my scripts to built again. i drop the database and look at information_schema.routines table.. i saw the functions at there! even if i dropped the database, the functions are still there...
at last i uninstall mysql and clean everything and install again and built the database from my scripts.. i still get this function creating errors...
from the time on, i cannot built functions...
my func is:
drop FUNCTION IF EXISTS `GMO`.`ODEMETIPI_DONDER`;
CREATE FUNCTION `GMO`.`ODEMETIPI_DONDER`(P_ODEME varchar(50)) RETURNS INT(11)
BEGIN
DECLARE RET_VAL INT(11);
SET RET_VAL = 0;
SELECT S.ODEMETIPI
INTO RET_VAL
FROM ODEMETIPI S
WHERE S.ODEMETIPI = P_ODEME;
RETURN RET_VAL;
End;
thanks for your interest...
joseph
How to repeat:
i drop my database, and look at information_schema.routines table. i saw functions at there.
i will sent you some screenshots if you want...
