Bug #40624 Cant save procedure in Query Browser
Submitted: 10 Nov 2008 22:38 Modified: 11 Nov 2008 12:58
Reporter: Thomas Lee Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.14 OS:Windows (XP, Ver 2002, sp2)
Assigned to: CPU Architecture:Any
Tags: cant saved procedure

[10 Nov 2008 22:38] Thomas Lee
Description:
After create procedure p1 in Query Browser, execute it, shown "not exist"

''p1 procedure
ELIMITER $$

DROP PROCEDURE IF EXISTS `masterroll`.`p1` $$
CREATE PROCEDURE `masterroll`.`p1` ()
BEGIN
  select * from scrap;
END $$

DELIMITER ;

''at query browser
SELECT * FROM masterroll.scrap s;      ''ok
call masterroll.p1();

PROCEDURE masterroll.p1 does not exist

How to repeat:
create p1 at masterroll db in query browser, will do it.
[11 Nov 2008 12:59] MySQL Verification Team
Thank you for the bug report. Sorry but I couldn't repeat the behavior reported, please be sure if you actually have created the procedure (it appears in the schemata masterroll tree). Thanks in advance.