Bug #8754 MySQL server connection lost - 'SHOW PROCEDURE STATUS' statement is executed

• Submitted: 23 Feb 2005 22:55
• Modified: 23 Feb 2005 23:08
• Reporter: Disha
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.2
• OS: Windows (Windows 2003)
• CPU Architecture: Any

[23 Feb 2005 22:55] Disha

Description:
When 'SHOW PROCEDURE STATUS' statement is executed the connection to the MySQL server is lost as the MySQL server service gets stopped.

How to repeat:
SHOW PROCEDURE STATUS LIKE 'hello' ;

Following Message is displayed:
ERROR 2013 (HY000): Lost connection to MySQL server during query

Expected Results
This statement returns characteristics of routines, such as the database, name, type, creator, and creation and modification dates. If no pattern is specified, the information for all stored procedures listed, depending on which statement you use. 
	
Actual Results  
ERROR 2013 (HY000): Lost connection to MySQL server during query

[23 Feb 2005 23:08] MySQL Verification Team

This issue was already fixed:

mysql> show procedure status like "test_multi_table_updates"\G
*************************** 1. row ***************************
           Db: test
         Name: test_multi_table_updates
         Type: PROCEDURE
      Definer: root@localhost
     Modified: 2005-02-23 20:00:31
      Created: 2005-02-23 20:00:31
Security_type: DEFINER
      Comment:
1 row in set (0.01 sec)

mysql> select version();
+----------------+
| version()      |
+----------------+
| 5.0.3-alpha-nt |
+----------------+
1 row in set (0.02 sec)

mysql>