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"><=></literal>
equality comparison operator. For <literal>NULL <=>
- 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"><=></literal>
equality comparison operator. For <literal>NULL <=>
- 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"><=></literal>
equality comparison operator. For <literal>NULL <=>
- 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"><=></literal>
equality comparison operator. For <literal>NULL <=>
- 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"><=></literal>
equality comparison operator. For <literal>NULL <=>
- 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.0 | paul.dubois | 12 Jul |
