Bug #14361 Support recursive stored procedures

• Submitted: 27 Oct 2005 0:35
• Modified: 5 Mar 2006 11:15
• Reporter: Mike Heath
• Status: Duplicate
• Category: Server
• Severity: S5 (Performance)
• Version: 5

[27 Oct 2005 0:35] Mike Heath

Description:
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 11:15] Konstantin Osipov

This is a duplicate of Bug#10100 (fixed).

[2 Apr 2008 18: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.