Menu

#2864 (ok 3.1.5) INVOKER not understood by parser

fixed
1
2013-06-11
2009-04-30
tibre44
No

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

Discussion

  • Marc Delisle

    Marc Delisle - 2009-05-06
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2009-05-06
    • priority: 5 --> 1
    • summary: Bad use of named block --> (ok 3.1.5) INVOKER not understood by parser
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2009-05-06

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2009-05-15
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed