Bug #8408 Stored procedure crash if function contains SHOW
Submitted: 9 Feb 2005 22:14 Modified: 28 Apr 2005 2:25
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-alpha-debug OS:Linux (SUSE 9.2)
Assigned to: Bugs System CPU Architecture:Any

[9 Feb 2005 22:14] Peter Gulutzan
Description:
If a function contains SHOW, a statement which uses the function crashes.
(This depends on a new 'feature' to allow table references in functions.)

How to repeat:
mysql> create function f21 () returns int begin show warnings; return 5; end;//
Query OK, 0 rows affected (0.00 sec)

mysql> select f21()//
ERROR 2027 (HY000): Malformed packet
mysql> select f21()//
ERROR 2006 (HY000): MySQL server has gone away
[9 Feb 2005 22:19] Miguel Solorzano
Thank you for the bug report.
[26 Apr 2005 15:53] 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/24326
[27 Apr 2005 14:57] 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/24381
[28 Apr 2005 2:25] Paul Dubois
Noted in 5.0.6 changelog.