From: jon
Date: February 13 2008 8:29am
Subject: svn commit - mysqldoc@docsrva: r9816 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0
List-Archive: http://lists.mysql.com/commits/42195
Message-Id: <200802130829.m1D8TxC0029677@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2008-02-13 09:29:59 +0100 (Wed, 13 Feb 2008)
New Revision: 9816

Log:

The Boolean logic implemented by MATCH ... IN BOOLEAN MODE is implied.

(Response to user feedback)



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


Modified: trunk/refman-4.1/functions-core.xml
===================================================================
--- trunk/refman-4.1/functions-core.xml	2008-02-13 03:24:51 UTC (rev 9815)
+++ trunk/refman-4.1/functions-core.xml	2008-02-13 08:29:59 UTC (rev 9816)
Changed blocks: 1, Lines Added: 31, Lines Deleted: 0; 1204 bytes

@@ -10995,6 +10995,37 @@
         <quote>YourSQL</quote>.
       </para>
 
+      <note>
+        <para>
+          In implementing this feature, MySQL uses what is sometimes
+          referred to as <firstterm>implied Boolean logic</firstterm>,
+          in which
+
+          <itemizedlist>
+
+            <listitem>
+              <para>
+                <literal>+</literal> stands for <literal>AND</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                <literal>-</literal> stands for <literal>NOT</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                [<emphasis>no operator</emphasis>] implies
+                <literal>OR</literal>
+              </para>
+            </listitem>
+
+          </itemizedlist>
+        </para>
+      </note>
+
       <para>
         Boolean full-text searches have these characteristics:
       </para>


Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml	2008-02-13 03:24:51 UTC (rev 9815)
+++ trunk/refman-5.0/functions-core.xml	2008-02-13 08:29:59 UTC (rev 9816)
Changed blocks: 1, Lines Added: 31, Lines Deleted: 0; 1204 bytes

@@ -11240,6 +11240,37 @@
         <quote>YourSQL</quote>.
       </para>
 
+      <note>
+        <para>
+          In implementing this feature, MySQL uses what is sometimes
+          referred to as <firstterm>implied Boolean logic</firstterm>,
+          in which
+
+          <itemizedlist>
+
+            <listitem>
+              <para>
+                <literal>+</literal> stands for <literal>AND</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                <literal>-</literal> stands for <literal>NOT</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                [<emphasis>no operator</emphasis>] implies
+                <literal>OR</literal>
+              </para>
+            </listitem>
+
+          </itemizedlist>
+        </para>
+      </note>
+
       <para>
         Boolean full-text searches have these characteristics:
       </para>


Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml	2008-02-13 03:24:51 UTC (rev 9815)
+++ trunk/refman-5.1/functions-core.xml	2008-02-13 08:29:59 UTC (rev 9816)
Changed blocks: 1, Lines Added: 31, Lines Deleted: 0; 1204 bytes

@@ -11219,6 +11219,37 @@
         <quote>YourSQL</quote>.
       </para>
 
+      <note>
+        <para>
+          In implementing this feature, MySQL uses what is sometimes
+          referred to as <firstterm>implied Boolean logic</firstterm>,
+          in which
+
+          <itemizedlist>
+
+            <listitem>
+              <para>
+                <literal>+</literal> stands for <literal>AND</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                <literal>-</literal> stands for <literal>NOT</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                [<emphasis>no operator</emphasis>] implies
+                <literal>OR</literal>
+              </para>
+            </listitem>
+
+          </itemizedlist>
+        </para>
+      </note>
+
       <para>
         Boolean full-text searches have these characteristics:
       </para>


Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml	2008-02-13 03:24:51 UTC (rev 9815)
+++ trunk/refman-6.0/functions-core.xml	2008-02-13 08:29:59 UTC (rev 9816)
Changed blocks: 1, Lines Added: 31, Lines Deleted: 0; 1204 bytes

@@ -11536,6 +11536,37 @@
         <quote>YourSQL</quote>.
       </para>
 
+      <note>
+        <para>
+          In implementing this feature, MySQL uses what is sometimes
+          referred to as <firstterm>implied Boolean logic</firstterm>,
+          in which
+
+          <itemizedlist>
+
+            <listitem>
+              <para>
+                <literal>+</literal> stands for <literal>AND</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                <literal>-</literal> stands for <literal>NOT</literal>
+              </para>
+            </listitem>
+
+            <listitem>
+              <para>
+                [<emphasis>no operator</emphasis>] implies
+                <literal>OR</literal>
+              </para>
+            </listitem>
+
+          </itemizedlist>
+        </para>
+      </note>
+
       <para>
         Boolean full-text searches have these characteristics:
       </para>