Author: paul
Date: 2005-11-23 22:00:45 +0100 (Wed, 23 Nov 2005)
New Revision: 405
Log:
r1223@kite-hub: paul | 2005-11-23 11:36:56 -0600
Update IN operator description. (Bug#9578)
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:4035
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1221
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4035
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1223
Modified: trunk/refman-4.1/functions.xml
===================================================================
--- trunk/refman-4.1/functions.xml 2005-11-23 16:54:38 UTC (rev 404)
+++ trunk/refman-4.1/functions.xml 2005-11-23 21:00:45 UTC (rev 405)
@@ -905,17 +905,17 @@
<para>
Returns <literal>1</literal> if
- <replaceable>expr</replaceable> is any of the values in the
- <literal>IN</literal> list, else returns
+ <replaceable>expr</replaceable> is equal to any of the
+ values in the <literal>IN</literal> list, else returns
<literal>0</literal>. If all values are constants, they are
evaluated according to the type of
<replaceable>expr</replaceable> and sorted. The search for
the item then is done using a binary search. This means
<literal>IN</literal> is very quick if the
<literal>IN</literal> value list consists entirely of
- constants. If <replaceable>expr</replaceable> is a
- case-sensitive string expression, the string comparison is
- performed in case-sensitive fashion.
+ constants. Otherwise, type conversion takes place according
+ to the rules described at the beginning of this section, but
+ applied to all the arguments.
</para>
<remark role="help-description-end"/>
Modified: trunk/refman-5.0/functions.xml
===================================================================
--- trunk/refman-5.0/functions.xml 2005-11-23 16:54:38 UTC (rev 404)
+++ trunk/refman-5.0/functions.xml 2005-11-23 21:00:45 UTC (rev 405)
@@ -966,17 +966,17 @@
<para>
Returns <literal>1</literal> if
- <replaceable>expr</replaceable> is any of the values in the
- <literal>IN</literal> list, else returns
+ <replaceable>expr</replaceable> is equal to any of the
+ values in the <literal>IN</literal> list, else returns
<literal>0</literal>. If all values are constants, they are
evaluated according to the type of
<replaceable>expr</replaceable> and sorted. The search for
the item then is done using a binary search. This means
<literal>IN</literal> is very quick if the
<literal>IN</literal> value list consists entirely of
- constants. If <replaceable>expr</replaceable> is a
- case-sensitive string expression, the string comparison is
- performed in case-sensitive fashion.
+ constants. Otherwise, type conversion takes place according
+ to the rules described at the beginning of this section, but
+ applied to all the arguments.
</para>
<remark role="help-description-end"/>
Modified: trunk/refman-5.1/functions.xml
===================================================================
--- trunk/refman-5.1/functions.xml 2005-11-23 16:54:38 UTC (rev 404)
+++ trunk/refman-5.1/functions.xml 2005-11-23 21:00:45 UTC (rev 405)
@@ -957,17 +957,17 @@
<para>
Returns <literal>1</literal> if
- <replaceable>expr</replaceable> is any of the values in the
- <literal>IN</literal> list, else returns
+ <replaceable>expr</replaceable> is equal to any of the
+ values in the <literal>IN</literal> list, else returns
<literal>0</literal>. If all values are constants, they are
evaluated according to the type of
<replaceable>expr</replaceable> and sorted. The search for
the item then is done using a binary search. This means
<literal>IN</literal> is very quick if the
<literal>IN</literal> value list consists entirely of
- constants. If <replaceable>expr</replaceable> is a
- case-sensitive string expression, the string comparison is
- performed in case-sensitive fashion.
+ constants. Otherwise, type conversion takes place according
+ to the rules described at the beginning of this section, but
+ applied to all the arguments.
</para>
<remark role="help-description-end"/>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r405 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 23 Nov |
