Author: jstephens
Date: 2006-08-06 12:55:14 +0200 (Sun, 06 Aug 2006)
New Revision: 2963
Log:
Correcting information concerning max_sp_recursion_depth - fixes Bug #21444
(Thanks, Paul & Kostja!)
Modified:
trunk/refman-5.0/database-administration.xml
trunk/refman-5.0/stored-procedures.xml
trunk/refman-5.1/database-administration.xml
trunk/refman-5.1/stored-procedures.xml
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-08-06 10:38:10 UTC (rev 2962)
+++ trunk/refman-5.0/database-administration.xml 2006-08-06 10:55:14 UTC (rev 2963)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 14; 1639 bytes
@@ -5203,22 +5203,15 @@
</para>
<para>
- The number of times that a stored routine (stored
- procedure or stored function) may call itself. The default
- value for this option is <literal>0</literal>, which
- completely disallows recursion in stored routines. The
- maximum value is <literal>4294967296</literal>
- (<literal>2<superscript>32</superscript></literal>).
- </para>
+ The number of times that a stored procedure may call
+ itself. The default value for this option is
+ 0, which completely disallows recursion in stored
+ procedures. The maximum value is 255.
+ </para>
<para>
- It is possible to remove limits on recursion by stored
- routines altogether by setting this option to
- <literal>9999999999</literal>. However, doing so can
- seriously impede performance and is not recommended,
- since for each new level of recursion, a new copy of the
- stored routine is created, compiled, and cached.
- </para>
+ This variable can be set globally and per session.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.0/stored-procedures.xml
===================================================================
--- trunk/refman-5.0/stored-procedures.xml 2006-08-06 10:38:10 UTC (rev 2962)
+++ trunk/refman-5.0/stored-procedures.xml 2006-08-06 10:55:14 UTC (rev 2963)
Changed blocks: 1, Lines Added: 7, Lines Deleted: 2; 844 bytes
@@ -97,12 +97,17 @@
</para>
<para>
- Recursive stored routines are disabled by default, but can be
+ Recursive stored procedures are disabled by default, but can be
enabled on the server by setting the
<literal>max_sp_recursion_depth</literal> server system variable to
a nonzero value. See <xref linkend="server-system-variables"/>, for
- more information.
+ more information.
</para>
+
+ <para>
+ Stored functions cannot be recursive. See
+ <xref linkend="routine-restrictions"/>.
+ </para>
<section id="stored-procedure-privileges">
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-08-06 10:38:10 UTC (rev 2962)
+++ trunk/refman-5.1/database-administration.xml 2006-08-06 10:55:14 UTC (rev 2963)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 13; 1592 bytes
@@ -5529,21 +5529,14 @@
</para>
<para>
- The number of times that a stored routine (stored
- procedure or stored function) may call itself. The default
- value for this option is <literal>0</literal>, which
- completely disallows recursion in stored routines. The
- maximum value is <literal>4294967296</literal>
- (<literal>2<superscript>32</superscript></literal>).
- </para>
+ The number of times that a stored procedure may call
+ itself. The default value for this option is
+ 0, which completely disallows recursion in stored
+ procedures. The maximum value is 255.
+ </para>
<para>
- It is possible to remove limits on recursion by stored
- routines altogether by setting this option to
- <literal>9999999999</literal>. However, doing so can
- seriously impede performance and is not recommended,
- since for each new level of recursion, a new copy of the
- stored routine is created, compiled, and cached.
+ This variable can be set globally and per session.
</para>
</listitem>
Modified: trunk/refman-5.1/stored-procedures.xml
===================================================================
--- trunk/refman-5.1/stored-procedures.xml 2006-08-06 10:38:10 UTC (rev 2962)
+++ trunk/refman-5.1/stored-procedures.xml 2006-08-06 10:55:14 UTC (rev 2963)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 822 bytes
@@ -97,12 +97,17 @@
</para>
<para>
- Recursive stored routines are disabled by default, but can be
+ Recursive stored procedures are disabled by default, but can be
enabled on the server by setting the
<literal>max_sp_recursion_depth</literal> server system variable to
a nonzero value. See <xref linkend="server-system-variables"/>, for
more information.
</para>
+
+ <para>
+ Stored functions cannot be recursive. See
+ <xref linkend="routine-restrictions"/>.
+ </para>
<section id="stored-procedure-privileges">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2963 - in trunk: refman-5.0 refman-5.1 | jstephens | 6 Aug |
