bk commit - mysqldoc@docsrva tree (paul:1.2764)

[paul]

Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.2764 05/06/13 11:47:13 paul@stripped +1 -0
  manual.texi:
    Add note about prohibition on result-set-producing
    statements in stored functions.

  Docs/manual.texi
    1.2983 05/06/13 10:20:48 paul@stripped +11 -0
    Add note about prohibition on result-set-producing
    statements in stored functions.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	paul
# Host:	frost.snake.net
# Root:	/Volumes/frost2/MySQL/bk/mysqldoc

--- 1.2982/Docs/manual.texi	2005-06-12 07:15:09 -05:00
+++ 1.2983/Docs/manual.texi	2005-06-13 10:20:48 -05:00
@@ -80550,6 +80550,17 @@
 statements, but excludes some @code{SELECT} statements.  This limitation
 will be lifted as soon as possible.
 
+Statements that return a result set cannot be used within a stored function.
+This includes @code{SELECT} statements that do not use @code{INTO} to fetch
+column values into variables, @code{SHOW} statements, and other statements
+such as @code{EXPLAIN}.  For statements that can be determined at function
+definition time to return a result set, a @code{Not allowed to return a
+result set from a function} error occurs (@code{ER_SP_NO_RETSET_IN_FUNC}).
+For statements that can be determined only at runtime to return a result
+set, a @code{PROCEDURE %s can't return a result set in the given context}
+error occurs (@code{ER_SP_BADSELECT}).
+
+
 The following is an example of a simple stored procedure that uses
 an @code{OUT} parameter.
 The example uses the @command{mysql} client @code{delimiter} command to change