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:	None
Category:	MySQL Server	Severity:	S5 (Performance)
Version:	5	OS:
Assigned to:		CPU Architecture:	Any

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.

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

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.

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.