List:Commits« Previous MessageNext Message »
From:paul Date:March 9 2006 1:31pm
Subject:svn commit - mysqldoc@docsrva: r1542 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2006-03-09 14:31:30 +0100 (Thu, 09 Mar 2006)
New Revision: 1542

Log:
 r8509@frost:  paul | 2006-03-09 07:31:14 -0600
 Off-by-one error in RAND() formula.  (Bug#17502)


Modified:
   trunk/
   trunk/refman-4.1/functions.xml
   trunk/refman-5.0/functions.xml
   trunk/refman-5.1/functions.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:8505
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3795
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:8509
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:3795

Modified: trunk/refman-4.1/functions.xml
===================================================================
--- trunk/refman-4.1/functions.xml	2006-03-09 13:19:59 UTC (rev 1541)
+++ trunk/refman-4.1/functions.xml	2006-03-09 13:31:30 UTC (rev 1542)
@@ -5449,13 +5449,13 @@
             <replaceable>j</replaceable>, use the expression
             <literal>FLOOR(<replaceable>i</replaceable> &plus; RAND() *
             (<replaceable>j</replaceable> &minus;
-            <replaceable>i</replaceable> &plus; 1))</literal>. For
+            <replaceable>i</replaceable>)</literal>. For
             example, to obtain a random integer in the range of 7 to 12
             inclusive, you could use the following statement:
           </para>
 
 <programlisting>
-SELECT FLOOR(7 &plus; (RAND() * 6));
+SELECT FLOOR(7 &plus; (RAND() * 5));
 </programlisting>
 
           <para>

Modified: trunk/refman-5.0/functions.xml
===================================================================
--- trunk/refman-5.0/functions.xml	2006-03-09 13:19:59 UTC (rev 1541)
+++ trunk/refman-5.0/functions.xml	2006-03-09 13:31:30 UTC (rev 1542)
@@ -5535,13 +5535,13 @@
             <replaceable>j</replaceable>, use the expression
             <literal>FLOOR(<replaceable>i</replaceable> &plus; RAND() *
             (<replaceable>j</replaceable> &minus;
-            <replaceable>i</replaceable> &plus; 1))</literal>. For
+            <replaceable>i</replaceable>)</literal>. For
             example, to obtain a random integer in the range of 7 to 12
             inclusive, you could use the following statement:
           </para>
 
 <programlisting>
-SELECT FLOOR(7 &plus; (RAND() * 6));
+SELECT FLOOR(7 &plus; (RAND() * 5));
 </programlisting>
 
           <para>

Modified: trunk/refman-5.1/functions.xml
===================================================================
--- trunk/refman-5.1/functions.xml	2006-03-09 13:19:59 UTC (rev 1541)
+++ trunk/refman-5.1/functions.xml	2006-03-09 13:31:30 UTC (rev 1542)
@@ -5507,13 +5507,13 @@
             <replaceable>j</replaceable>, use the expression
             <literal>FLOOR(<replaceable>i</replaceable> &plus; RAND() *
             (<replaceable>j</replaceable> &minus;
-            <replaceable>i</replaceable> &plus; 1))</literal>. For
+            <replaceable>i</replaceable>)</literal>. For
             example, to obtain a random integer in the range of 7 to 12
             inclusive, you could use the following statement:
           </para>
 
 <programlisting>
-SELECT FLOOR(7 &plus; (RAND() * 6));
+SELECT FLOOR(7 &plus; (RAND() * 5));
 </programlisting>
 
           <para>
Thread
• svn commit - mysqldoc@docsrva: r1542 - in trunk: . refman-4.1 refman-5.0 refman-5.1paul9 Mar