Menu ▾ ▴

#2496 (ok 2.11.0-rc2) parameters lost when edit stored routine

2.11.0-rc1
fixed
Marc Delisle
MySQL Parser (154)
1
2013-06-11
2007-08-03
Jean DERAM
No

When editing a stored routine with 2.11-rc1 phpmyadmin skip paremetres.

This is reproducible like this:

create stored procedure in mysql client:

DELIMITER $$
CREATE PROCEDURE p_test(
IN aaaa VARCHAR(64),
IN bbbb VARCHAR(15)
)
BEGIN
SELECT NOW();
END $$
DELIMITER ;

Now displaying it in phpmyadmin shows:

DROP PROCEDURE `p_test`//
CREATE PROCEDURE `p_test`()
BEGIN
SELECT NOW();
END
//

parameter aaaa and bbbb are not displayed. When saving procedure parameters are lost

Discussion

  • Marc Delisle

    Marc Delisle - 2007-08-09
    • assigned_to: nobody --> lem9
     

  • Marc Delisle

    Marc Delisle - 2007-08-09
    • priority: 5 --> 1
    • summary: parameters lost when edit stored routine --> (ok 2.11.0-rc2) parameters lost when edit stored routine
    • status: open --> open-fixed
     

  • Marc Delisle

    Marc Delisle - 2007-08-21
    • status: open-fixed --> closed-fixed
     

  • Michal Čihař

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