Author: paul
Date: 2007-06-14 20:02:19 +0200 (Thu, 14 Jun 2007)
New Revision: 6792
Log:
r21538@frost: paul | 2007-06-14 12:48:12 -0500
Document SQLPS limitation: Cannot prepare DECLARE ... CURSOR
within stored procedures. (Bug#17153)
Modified:
trunk/refman-5.0/sql-syntax.xml
trunk/refman-5.1/sql-syntax.xml
trunk/refman-5.2/sql-syntax.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:26211
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:21515
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:17792
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:26211
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:21538
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:17792
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2007-06-14 10:25:27 UTC (rev 6791)
+++ trunk/refman-5.0/sql-syntax.xml 2007-06-14 18:02:19 UTC (rev 6792)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 1; 774 bytes
@@ -23516,7 +23516,10 @@
SQL syntax for prepared statements cannot be used within stored
routines (procedures or functions), or triggers. This restriction
is lifted as of MySQL 5.0.13 for stored procedures, but not for
- stored functions or triggers.
+ stored functions or triggers. However, you cannot open a cursor on
+ a prepared statment. That is, you cannot prepare a
+ <literal>DECLARE ... CURSOR</literal> statement, execute it, and
+ then open that cursor.
</para>
<para>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2007-06-14 10:25:27 UTC (rev 6791)
+++ trunk/refman-5.1/sql-syntax.xml 2007-06-14 18:02:19 UTC (rev 6792)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 1; 687 bytes
@@ -25649,7 +25649,10 @@
<para>
SQL syntax for prepared statements can be used within stored
- procedures, but not in stored functions or triggers.
+ procedures, but not in stored functions or triggers. However, you
+ cannot open a cursor on a prepared statment. That is, you cannot
+ prepare a <literal>DECLARE ... CURSOR</literal> statement, execute
+ it, and then open that cursor.
</para>
<para>
Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml 2007-06-14 10:25:27 UTC (rev 6791)
+++ trunk/refman-5.2/sql-syntax.xml 2007-06-14 18:02:19 UTC (rev 6792)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 1; 687 bytes
@@ -25429,7 +25429,10 @@
<para>
SQL syntax for prepared statements can be used within stored
- procedures, but not in stored functions or triggers.
+ procedures, but not in stored functions or triggers. However, you
+ cannot open a cursor on a prepared statment. That is, you cannot
+ prepare a <literal>DECLARE ... CURSOR</literal> statement, execute
+ it, and then open that cursor.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6792 - in trunk: . refman-5.0 refman-5.1 refman-5.2 | paul | 14 Jun |
