Bug #14361 Support recursive stored procedures
Submitted: 26 Oct 2005 22:35 Modified: 5 Mar 2006 10:15
Reporter: Mike Heath Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S5 (Performance)
Version:5 OS:
Assigned to: CPU Architecture:Any

[26 Oct 2005 22:35] Mike Heath
It would be nice to either support recursive stored procedures.  The document here http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.pdf has an example, 'hierachy2' that illustrated a recursive stored procedure.  This example will not work with MySQL 5.0.15.

How to repeat:
Just try the hierarchy2 example in the url mentioned above.

Suggested fix:
Support for recursive stored procedures was disabled because they crashed the server.  Please fix the server so that it doesn't crash.
[5 Mar 2006 10:15] Konstantin Osipov
This is a duplicate of Bug#10100 (fixed).
[2 Apr 2008 16:45] Donny Viszneki
This is not a duplicate of Bug#10100. That report is specifically about buggy behavior of the server. Behaviors like:

Disconnecting the client
Not issuing any warnings or errors
Allowing recursive procedures to be created

This bug is a request to ADD RECURSION CAPABILITY to MySQL server. Please mark this bug appropriately for posterity, even if there are not currently plans to add recursion. Remove the duplication notice.