| 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: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.11 | OS: | Any (any) |
| Assigned to: | Andrey Hristov | CPU Architecture: | Any |
[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.
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.