Bug #12490 Packets out of order if calling HELP CONTENTS from Stored Procedure
Submitted: 10 Aug 2005 12:18 Modified: 1 Sep 2005 14:21
Reporter: Konstantin Osipov (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.11 OS:Any (any)
Assigned to: Andrey Hristov CPU Architecture:Any

[10 Aug 2005 12:18] Konstantin Osipov
Description:
The following test case reports 'packets out of order' when calling SP for the second time:

delimiter |
drop procedure p1|
create procedure p1()
begin
 help contents;
end|
call p1()|
delimiter |
call p1();
call p1();

How to repeat:
mysql> delimiter |
mysql> drop procedure p1|
Query OK, 0 rows affected (0.01 sec)

mysql> create procedure p1()
    -> begin
    ->  help contents;
    -> end|
Query OK, 0 rows affected (0.01 sec)

mysql> call p1()|
+----------------------+---------------------+----------------+
| source_category_name | name                | is_it_category |
+----------------------+---------------------+----------------+
| Contents             | Administration      | Y              |
| Contents             | Column Types        | Y              |
| Contents             | Data Definition     | Y              |
| Contents             | Data Manipulation   | Y              |
| Contents             | Functions           | Y              |
| Contents             | Geographic features | Y              |
| Contents             | Transactions        | Y              |
+----------------------+---------------------+----------------+
7 rows in set (0.01 sec)

mysql> call p1()|
Packets out of order (Found: 14, expected 1)
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> delimiter ;

Suggested fix:
HELP should be disabled in stored procedures.
[10 Aug 2005 14:35] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28110
[10 Aug 2005 16:04] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28117
[29 Aug 2005 10:19] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28966
[1 Sep 2005 14:21] Paul Dubois
Noted in 5.0.13 changelog.