Bug #7544 show procedure status
Submitted: 27 Dec 2004 12:24 Modified: 27 Dec 2004 12:39
Reporter: aaa sss Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.2-alpha OS:Windows (Windows 2000 Pro sp4)
Assigned to: CPU Architecture:Any

[27 Dec 2004 12:24] aaa sss
Description:
When command "show procedure status rep;" is run in the mysql console a windows error dialog box appears saying that operation does not have access to the memmory and after clicking OK console displayes following message "ERROR 2013 (HY000): Lost connection to MySQL server during query" and after that MySQL-dt is no longer in the list of processes, it is dead

How to repeat:
1. install MySQL 5.0 as a windows service on Windows 2000 Pro sp4 with root user
2. Login with root user
3. create a Database
4. use that DB
5. create a stored procedure, for example the one from section "19.1.9.6 REPEAT Statement" user manual
6. execute the following command  "show procedure status rep;"
7. Error is thrown, see Description

Suggested fix:
at least srever must not die, it should return something like: "Such stored procedure does not exist"
[27 Dec 2004 12:39] MySQL Verification Team
Duplicate for #6955