From: Nicolas Sebrecht (nicolas.s-devlaposte.net)
Date: Thu Aug 07 2008 - 09:38:05 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Nicolas Sebrecht a écrit:

> mysql> CREATE DATABASE dbtest;
> mysql> DELIMITER $$
> mysql> DROP PROCEDURE IF EXISTS `dbtest`.`test`$$
> mysql> CREATE PROCEDURE `dbtest`.`test` (newf VARCHAR(130))
> -> BEGIN
> -> SET newf = REVERSE( SUBSTRING_INDEX( REVERSE (newf) , '/', 1));
> -> END$$
> mysql> DELIMITER ;
> mysql> CALL test ('/home/ftp/file.foo');
> ERROR 1305 (42000): FUNCTION dbtest.REVERSE does not exist

I found the mistake. The error was due to the white-space just after the
"REVERSE(" term.

So, the correct command is :
SET newf = REVERSE(SUBSTRING_INDEX(REVERSE(newf), '/', 1));

Thanks to all persons who tried to solve this problem.

I just lost a lot of time...

--
Nicolas Sebrecht

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]