svn commit - mysqldoc@docsrva: r10318 - in trunk: refman-5.0 refman-5.1 refman-6.0

[jon]

Author: jstephens
Date: 2008-03-19 22:12:41 +0100 (Wed, 19 Mar 2008)
New Revision: 10318

Log:

Missing keyword in IF examples

Fixes Docs Bug #35430



Modified:
   trunk/refman-5.0/stored-procedures.xml
   trunk/refman-5.1/stored-procedures.xml
   trunk/refman-6.0/stored-procedures.xml


Modified: trunk/refman-5.0/stored-procedures.xml
===================================================================
--- trunk/refman-5.0/stored-procedures.xml	2008-03-19 18:11:20 UTC (rev 10317)
+++ trunk/refman-5.0/stored-procedures.xml	2008-03-19 21:12:41 UTC (rev 10318)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 6; 1013 bytes

@@ -2043,16 +2043,18 @@
 <programlisting>
 DELIMITER //
 
-CREATE FUNCTION SimpleCompare(n INT, m INT) RETURNS VARCHAR(20)
+CREATE FUNCTION SimpleCompare(n INT, m INT) 
+  RETURNS VARCHAR(20)
+  
   BEGIN
     DECLARE s VARCHAR(20);
 
-    IF n &gt; m THEN s = '&gt;';
-    ELSEIF n = m THEN s = '=';
-    ELSE s = '&lt;'
+    IF n &gt; m THEN SET s = '&gt;';
+    ELSEIF n = m THEN SET s = '=';
+    ELSE SET s = '&lt;';
     END IF;
 
-    s = CONCAT(n, ' ', s, ' ', m);
+    SET s = CONCAT(n, ' ', s, ' ', m);
 
     RETURN s;
   END //

@@ -2074,7 +2076,9 @@
 <programlisting>
 DELIMITER //
 
-CREATE FUNCTION VerboseCompare (n INT, m INT) RETURNS VARCHAR(50)
+CREATE FUNCTION VerboseCompare (n INT, m INT) 
+  RETURNS VARCHAR(50)
+  
   BEGIN
     DECLARE s VARCHAR(50);
 


Modified: trunk/refman-5.1/stored-procedures.xml
===================================================================
--- trunk/refman-5.1/stored-procedures.xml	2008-03-19 18:11:20 UTC (rev 10317)
+++ trunk/refman-5.1/stored-procedures.xml	2008-03-19 21:12:41 UTC (rev 10318)
Changed blocks: 3, Lines Added: 12, Lines Deleted: 8; 1168 bytes

@@ -2001,16 +2001,18 @@
 <programlisting>
 DELIMITER //
 
-CREATE FUNCTION SimpleCompare(n INT, m INT) RETURNS VARCHAR(20)
+CREATE FUNCTION SimpleCompare(n INT, m INT) 
+  RETURNS VARCHAR(20)
+
   BEGIN
     DECLARE s VARCHAR(20);
 
-    IF n &gt; m THEN s = '&gt;';
-    ELSEIF n = m THEN s = '=';
-    ELSE s = '&lt;'
+    IF n &gt; m THEN SET s = '&gt;';
+    ELSEIF n = m THEN SET s = '=';
+    ELSE SET s = '&lt;';
     END IF;
 
-    s = CONCAT(n, ' ', s, ' ', m);
+    SET s = CONCAT(n, ' ', s, ' ', m);
 
     RETURN s;
   END //

@@ -2032,7 +2034,9 @@
 <programlisting>
 DELIMITER //
 
-CREATE FUNCTION VerboseCompare (n INT, m INT) RETURNS VARCHAR(50)
+CREATE FUNCTION VerboseCompare (n INT, m INT) 
+  RETURNS VARCHAR(50)
+
   BEGIN
     DECLARE s VARCHAR(50);
 

@@ -2044,9 +2048,9 @@
     
       SET s = CONCAT('is ', s, ' than');
     END IF;
-    
+
     SET s = CONCAT(n, ' ', s, ' ', m, '.');
-    
+
     RETURN s;
   END //
 


Modified: trunk/refman-6.0/stored-procedures.xml
===================================================================
--- trunk/refman-6.0/stored-procedures.xml	2008-03-19 18:11:20 UTC (rev 10317)
+++ trunk/refman-6.0/stored-procedures.xml	2008-03-19 21:12:41 UTC (rev 10318)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 6; 1013 bytes

@@ -1999,16 +1999,18 @@
 <programlisting>
 DELIMITER //
 
-CREATE FUNCTION SimpleCompare(n INT, m INT) RETURNS VARCHAR(20)
+CREATE FUNCTION SimpleCompare(n INT, m INT) 
+  RETURNS VARCHAR(20)
+  
   BEGIN
     DECLARE s VARCHAR(20);
 
-    IF n &gt; m THEN s = '&gt;';
-    ELSEIF n = m THEN s = '=';
-    ELSE s = '&lt;'
+    IF n &gt; m THEN SET s = '&gt;';
+    ELSEIF n = m THEN SET s = '=';
+    ELSE SET s = '&lt;';
     END IF;
 
-    s = CONCAT(n, ' ', s, ' ', m);
+    SET s = CONCAT(n, ' ', s, ' ', m);
 
     RETURN s;
   END //

@@ -2030,7 +2032,9 @@
 <programlisting>
 DELIMITER //
 
-CREATE FUNCTION VerboseCompare (n INT, m INT) RETURNS VARCHAR(50)
+CREATE FUNCTION VerboseCompare (n INT, m INT) 
+  RETURNS VARCHAR(50)
+  
   BEGIN
     DECLARE s VARCHAR(50);