bk commit - mysqldoc tree (paul:1.2765)

[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.2765 05/03/23 11:29:46 paul@stripped +1 -0
  manual.texi:
    Stored routines: clarify a few statements; fix some broken syntax

  Docs/manual.texi
    1.2599 05/03/23 11:25:57 paul@stripped +10 -12
    Stored routines: clarify a few statements; fix some broken syntax

# 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:	kite-hub.kitebird.com
# Root:	/src/extern/MySQL/bk/mysqldoc

--- 1.2598/Docs/manual.texi	2005-03-22 15:47:47 -06:00
+++ 1.2599/Docs/manual.texi	2005-03-23 11:25:57 -06:00
@@ -79887,8 +79887,8 @@
 specified as an expression; it need not be a constant.
 
 The scope of a local variable is within the @code{BEGIN ... END} block where it
-is declared.  It can be used in nested blocks those that declare a variable
-with the same name.
+is declared.  It can be used in nested blocks except those that declare a
+variable with the same name.
 
 
 @node SET Statement, SELECT INTO Statement, DECLARE Local Variables, Variables in Stored Procedures
@@ -79923,8 +79923,7 @@
 @end example
 
 This @code{SELECT} syntax stores selected columns directly into variables.
-Therefore, only a single row may be retrieved. This statement is also
-extremely useful when used in combination with cursors.
+Therefore, only a single row may be retrieved.
 
 @example
 SELECT id,data INTO x,y FROM test.t1 LIMIT 1;
@@ -80061,8 +80060,8 @@
 Asensitive means that the server may or may not make a copy of its result
 table.
 
-Cursors must be declared before declaring handlers, and variables must
-be declared before declaring either cursors or handlers.
+Cursors must be declared before declaring handlers, and variables and
+conditions must be declared before declaring either cursors or handlers.
 
 For example:
 
@@ -80112,8 +80111,8 @@
 @end example
 
 This statement declares a cursor.
-Multiple cursors may be defined in a routine, but each must have a unique
-name.
+Multiple cursors may be defined in a routine, but each cursor in a block
+must have a unique name.
 
 The @code{SELECT} statement cannot have an @code{INTO} clause.
 
@@ -80188,8 +80187,7 @@
 
 @example
 IF @var{search_condition} THEN @var{statement_list}
-    [ELSEIF @var{search_condition} THEN @var{statement_list}]
-    ...
+    [ELSEIF @var{search_condition} THEN @var{statement_list}] ...
     [ELSE @var{statement_list}]
 END IF
 @end example
@@ -80213,7 +80211,7 @@
 @example
 CASE @var{case_value}
     WHEN @var{when_value} THEN @var{statement_list}
-    [WHEN @var{when_value} THEN @var{statement_list} ...]
+    [WHEN @var{when_value} THEN @var{statement_list}] ...
     [ELSE @var{statement_list}]
 END CASE
 @end example
@@ -80223,7 +80221,7 @@
 @example
 CASE
     WHEN @var{search_condition} THEN @var{statement_list}
-    [WHEN @var{search_condition} THEN @var{statement_list} ...]
+    [WHEN @var{search_condition} THEN @var{statement_list}] ...
     [ELSE @var{statement_list}]
 END CASE
 @end example