Bug #11437 Browser crashes after repeated procedure execution
Submitted: 19 Jun 2005 19:49 Modified: 27 Jun 2005 13:36
Reporter: Robin Bailes Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.10 OS:Windows (Windows XP)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[19 Jun 2005 19:49] Robin Bailes 
Description:
Executing a stored procedure several times the browser crashes.

How to repeat:
version 1.1.10

-- Create a test table
CREATE TABLE `testtable` (
  `Col1` varchar(20) NOT NULL,
  PRIMARY KEY  (`Col1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Create some testdata
INSERT INTO testtable VALUES ('A'), ('B'), ('C'), ('D'); 

-- Create a simple inquiry procedure
DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`prcTest`$$
CREATE PROCEDURE `test`.`prcTest`()
begin
SELECT Col1
FROM testtable;

end$$

DELIMITER ;

-- Execute the procedure four times (click lightning button)
CALL prcTest()

-- The first three work successfully.  The fourth abends Query Browser
-- See attachment word doc for error messages
[19 Jun 2005 19:51] Robin Bailes 
Screen shots of error messages

Attachment: MySQL Bug.doc (application/msword, text), 66.50 KiB.
[20 Jun 2005 19:32] MySQL Verification Team 
Thank you for the bug report.
[27 Jun 2005 13:36] Vladimir Kolesnikov 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html