List:Commits« Previous MessageNext Message »
From:paul.dubois Date:July 12 2010 3:53pm
Subject:svn commit - mysqldoc@docsrva: r21661 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.5 refman-6.0
View as plain text  
Author: paul
Date: 2010-07-12 17:53:57 +0200 (Mon, 12 Jul 2010)
New Revision: 21661

Log:
 r61053@frost:  paul | 2010-07-12 10:53:47 -0500
 Minor revisions for comparison rules


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

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:40730
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:61051
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
   + 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:35498
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:40730
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:61053
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546


Modified: trunk/refman-4.1/functions-core.xml
===================================================================
--- trunk/refman-4.1/functions-core.xml	2010-07-12 15:04:54 UTC (rev 21660)
+++ trunk/refman-4.1/functions-core.xml	2010-07-12 15:53:57 UTC (rev 21661)
Changed blocks: 3, Lines Added: 18, Lines Deleted: 11; 2220 bytes

@@ -174,7 +174,7 @@
           for the <literal>NULL</literal>-safe
           <literal role="op" condition="equal-to">&lt;=&gt;</literal>
           equality comparison operator. For <literal>NULL &lt;=&gt;
-          NULL</literal>, the result is true.
+          NULL</literal>, the result is true. No conversion is needed.
         </para>
       </listitem>
 

@@ -1404,20 +1404,33 @@
 
             <listitem>
               <para>
-                If any argument is a case-sensitive string, the
-                arguments are compared as case-sensitive strings.
+                If the arguments comprise a mix of numbers and strings,
+                they are compared as numbers.
               </para>
             </listitem>
 
             <listitem>
               <para>
-                In all other cases, the arguments are compared as
-                case-insensitive strings.
+                If any argument is a nonbinary (character) string, the
+                arguments are compared as nonbinary strings.
               </para>
             </listitem>
 
+            <listitem>
+              <para>
+                In all other cases, the arguments are compared as binary
+                strings.
+              </para>
+            </listitem>
+
           </itemizedlist>
 
+          <para>
+            <literal role="func">LEAST()</literal> returns
+            <literal>NULL</literal> only if all arguments are
+            <literal>NULL</literal>.
+          </para>
+
           <remark role="help-description-end"/>
 
           <remark role="help-example"/>

@@ -1432,12 +1445,6 @@
 </programlisting>
 
           <para>
-            <literal role="func">LEAST()</literal> returns
-            <literal>NULL</literal> only if all arguments are
-            <literal>NULL</literal>.
-          </para>
-
-          <para>
             Before MySQL 3.22.5, you can use
             <literal role="func">MIN()</literal> instead of
             <literal role="func">LEAST()</literal>.


Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml	2010-07-12 15:04:54 UTC (rev 21660)
+++ trunk/refman-5.0/functions-core.xml	2010-07-12 15:53:57 UTC (rev 21661)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 5; 1545 bytes

@@ -175,7 +175,7 @@
           for the <literal>NULL</literal>-safe
           <literal role="op" condition="equal-to">&lt;=&gt;</literal>
           equality comparison operator. For <literal>NULL &lt;=&gt;
-          NULL</literal>, the result is true.
+          NULL</literal>, the result is true. No conversion is needed.
         </para>
       </listitem>
 

@@ -1517,18 +1517,25 @@
 
             <listitem>
               <para>
-                If any argument is a case-sensitive string, the
-                arguments are compared as case-sensitive strings.
+                If the arguments comprise a mix of numbers and strings,
+                they are compared as numbers.
               </para>
             </listitem>
 
             <listitem>
               <para>
-                In all other cases, the arguments are compared as
-                case-insensitive strings.
+                If any argument is a nonbinary (character) string, the
+                arguments are compared as nonbinary strings.
               </para>
             </listitem>
 
+            <listitem>
+              <para>
+                In all other cases, the arguments are compared as binary
+                strings.
+              </para>
+            </listitem>
+
           </itemizedlist>
 
           <para>


Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml	2010-07-12 15:04:54 UTC (rev 21660)
+++ trunk/refman-5.1/functions-core.xml	2010-07-12 15:53:57 UTC (rev 21661)
Changed blocks: 3, Lines Added: 19, Lines Deleted: 11; 2289 bytes

@@ -175,7 +175,7 @@
           for the <literal>NULL</literal>-safe
           <literal role="op" condition="equal-to">&lt;=&gt;</literal>
           equality comparison operator. For <literal>NULL &lt;=&gt;
-          NULL</literal>, the result is true.
+          NULL</literal>, the result is true. No conversion is needed.
         </para>
       </listitem>
 

@@ -1486,6 +1486,13 @@
 
             <listitem>
               <para>
+                If any argument is <literal>NULL</literal>, the result
+                is <literal>NULL</literal>. No comparison is needed.
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
                 If the return value is used in an
                 <literal role="type">INTEGER</literal> context or all
                 arguments are integer-valued, they are compared as

@@ -1503,26 +1510,27 @@
 
             <listitem>
               <para>
-                If any argument is a case-sensitive string, the
-                arguments are compared as case-sensitive strings.
+                If the arguments comprise a mix of numbers and strings,
+                they are compared as numbers.
               </para>
             </listitem>
 
             <listitem>
               <para>
-                In all other cases, the arguments are compared as
-                case-insensitive strings.
+                If any argument is a nonbinary (character) string, the
+                arguments are compared as nonbinary strings.
               </para>
             </listitem>
 
+            <listitem>
+              <para>
+                In all other cases, the arguments are compared as binary
+                strings.
+              </para>
+            </listitem>
+
           </itemizedlist>
 
-          <para>
-            <literal role="func">LEAST()</literal> returns
-            <literal>NULL</literal> if any argument is
-            <literal>NULL</literal>.
-          </para>
-
           <remark role="help-description-end"/>
 
           <remark role="help-example"/>


Modified: trunk/refman-5.5/functions-core.xml
===================================================================
--- trunk/refman-5.5/functions-core.xml	2010-07-12 15:04:54 UTC (rev 21660)
+++ trunk/refman-5.5/functions-core.xml	2010-07-12 15:53:57 UTC (rev 21661)
Changed blocks: 3, Lines Added: 19, Lines Deleted: 11; 2289 bytes

@@ -175,7 +175,7 @@
           for the <literal>NULL</literal>-safe
           <literal role="op" condition="equal-to">&lt;=&gt;</literal>
           equality comparison operator. For <literal>NULL &lt;=&gt;
-          NULL</literal>, the result is true.
+          NULL</literal>, the result is true. No conversion is needed.
         </para>
       </listitem>
 

@@ -1652,6 +1652,13 @@
 
             <listitem>
               <para>
+                If any argument is <literal>NULL</literal>, the result
+                is <literal>NULL</literal>. No comparison is needed.
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
                 If the return value is used in an
                 <literal role="type">INTEGER</literal> context or all
                 arguments are integer-valued, they are compared as

@@ -1669,26 +1676,27 @@
 
             <listitem>
               <para>
-                If any argument is a case-sensitive string, the
-                arguments are compared as case-sensitive strings.
+                If the arguments comprise a mix of numbers and strings,
+                they are compared as numbers.
               </para>
             </listitem>
 
             <listitem>
               <para>
-                In all other cases, the arguments are compared as
-                case-insensitive strings.
+                If any argument is a nonbinary (character) string, the
+                arguments are compared as nonbinary strings.
               </para>
             </listitem>
 
+            <listitem>
+              <para>
+                In all other cases, the arguments are compared as binary
+                strings.
+              </para>
+            </listitem>
+
           </itemizedlist>
 
-          <para>
-            <literal role="func">LEAST()</literal> returns
-            <literal>NULL</literal> if any argument is
-            <literal>NULL</literal>.
-          </para>
-
           <remark role="help-description-end"/>
 
           <remark role="help-example"/>


Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml	2010-07-12 15:04:54 UTC (rev 21660)
+++ trunk/refman-6.0/functions-core.xml	2010-07-12 15:53:57 UTC (rev 21661)
Changed blocks: 3, Lines Added: 19, Lines Deleted: 11; 2289 bytes

@@ -175,7 +175,7 @@
           for the <literal>NULL</literal>-safe
           <literal role="op" condition="equal-to">&lt;=&gt;</literal>
           equality comparison operator. For <literal>NULL &lt;=&gt;
-          NULL</literal>, the result is true.
+          NULL</literal>, the result is true. No conversion is needed.
         </para>
       </listitem>
 

@@ -1657,6 +1657,13 @@
 
             <listitem>
               <para>
+                If any argument is <literal>NULL</literal>, the result
+                is <literal>NULL</literal>. No comparison is needed.
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
                 If the return value is used in an
                 <literal role="type">INTEGER</literal> context or all
                 arguments are integer-valued, they are compared as

@@ -1674,26 +1681,27 @@
 
             <listitem>
               <para>
-                If any argument is a case-sensitive string, the
-                arguments are compared as case-sensitive strings.
+                If the arguments comprise a mix of numbers and strings,
+                they are compared as numbers.
               </para>
             </listitem>
 
             <listitem>
               <para>
-                In all other cases, the arguments are compared as
-                case-insensitive strings.
+                If any argument is a nonbinary (character) string, the
+                arguments are compared as nonbinary strings.
               </para>
             </listitem>
 
+            <listitem>
+              <para>
+                In all other cases, the arguments are compared as binary
+                strings.
+              </para>
+            </listitem>
+
           </itemizedlist>
 
-          <para>
-            <literal role="func">LEAST()</literal> returns
-            <literal>NULL</literal> if any argument is
-            <literal>NULL</literal>.
-          </para>
-
           <remark role="help-description-end"/>
 
           <remark role="help-example"/>


Thread
svn commit - mysqldoc@docsrva: r21661 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.5 refman-6.0paul.dubois12 Jul