I use a phpMyAdmin SQL window to create a function with a named block :
DELIMITER /
CREATE FUNCTION f_check
( par_uid INT )
RETURNS CHAR(50)
SQL SECURITY INVOKER
f_check: BEGIN
RETURN 'OK';
END f_check;
/
but phpMyAdmin shows an error :
CREATE FUNCTION f_check(
par_uid INT
) RETURNS CHAR( 50 ) SQL SECURITY INVOKERf_check : BEGIN RETURN 'OK';
MySQL a répondu:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
When I create my function directly with MySQL, there is no error. PhpMyAdmin transforms :
SQL SECURITY INVOKER
f_check: BEGIN
by :
SQL SECURITY INVOKERf_check : BEGIN
Fixed in subversion, thanks for reporting.