Bug #21110 | limit of max_sp_recursion_depth | ||
---|---|---|---|
Submitted: | 18 Jul 2006 10:46 | Modified: | 18 Jul 2006 16:46 |
Reporter: | Nikolay Shestakov | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S4 (Feature request) |
Version: | 5.0 | OS: | Any (All) |
Assigned to: | CPU Architecture: | Any |
[18 Jul 2006 10:46]
Nikolay Shestakov
[18 Jul 2006 16:46]
Valeriy Kravchuk
Thank you for a reasonable feature request.
[7 May 2008 14:37]
Helmut Neubauer
Is there a plan to increase the maximum possible value?
[9 Aug 2010 13:12]
Markus Schmid
No change in here? Please increase that value, 255 is not enough for complex routines.
[28 Apr 2011 22:04]
Anthony Galano
Any progress on this? I can't imagine it would be that hard. 255 is simply too small for complex routines or large datasets. For instance we use recursion to calculate and store nested set organizational tree but are stuck at 255 nodes. Any modern hardware should have no problems with 65k+ as recommended.
[6 Apr 2012 13:51]
Jamie Solomons
I completely agree, please can you look to increase the maximum possible value?
[6 Dec 2018 11:21]
Harikrishna Guggilla
Please increase it to 65k, 255 is not enough