svn commit - mysqldoc@docsrva: r1850 - in trunk: refman-4.1 refman-5.0 refman-5.1

[jon]

Author: jstephens
Date: 2006-04-18 09:43:06 +0200 (Tue, 18 Apr 2006)
New Revision: 1850

Log:

CLuster: Clarification regarding indexes. (Suggested by user)



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

Modified: trunk/refman-4.1/ndbcluster.xml
===================================================================
--- trunk/refman-4.1/ndbcluster.xml	2006-04-17 20:10:25 UTC (rev 1849)
+++ trunk/refman-4.1/ndbcluster.xml	2006-04-18 07:43:06 UTC (rev 1850)
@@ -9256,7 +9256,7 @@
 
           <listitem>
             <para>
-              Not all charsets and collations supported; see
+              Not all charsets and collations are supported; see
               <xref linkend="mysql-cluster-news-4-1-6"/>, for a list of
               those that are supported.
             </para>
@@ -9271,7 +9271,13 @@
 
           <listitem>
             <para>
-              Text indexes are not supported.
+              Text indexes are not supported. That is, you cannot create
+              indexes on columns of any of the <literal>TEXT</literal>
+              datatypes, nor does the <literal>NDB</literal> storage
+              engine support <literal>FULLTEXT</literal> indexes (these
+              are supported by <literal>MyISAM</literal> only). However,
+              you can index <literal>VARCHAR</literal> columns of
+              <literal>NDB</literal> tables. 
             </para>
           </listitem>
 

Modified: trunk/refman-5.0/ndbcluster.xml
===================================================================
--- trunk/refman-5.0/ndbcluster.xml	2006-04-17 20:10:25 UTC (rev 1849)
+++ trunk/refman-5.0/ndbcluster.xml	2006-04-18 07:43:06 UTC (rev 1850)
@@ -9243,12 +9243,25 @@
 
           <listitem>
             <para>
-              Text indexes are not supported.
+              There are no prefix indexes; only entire fields can be
+              indexed.
             </para>
           </listitem>
 
           <listitem>
             <para>
+              Text indexes are not supported. That is, you cannot create
+              indexes on columns of any of the <literal>TEXT</literal>
+              datatypes, nor does the <literal>NDB</literal> storage
+              engine support <literal>FULLTEXT</literal> indexes (these
+              are supported by <literal>MyISAM</literal> only). However,
+              you can index <literal>VARCHAR</literal> columns of
+              <literal>NDB</literal> tables. 
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
               A <literal>BIT</literal> column cannot be a primary key or
               part of a composite primary key.
             </para>

Modified: trunk/refman-5.1/ndbcluster.xml
===================================================================
--- trunk/refman-5.1/ndbcluster.xml	2006-04-17 20:10:25 UTC (rev 1849)
+++ trunk/refman-5.1/ndbcluster.xml	2006-04-18 07:43:06 UTC (rev 1850)
@@ -11286,12 +11286,25 @@
 
           <listitem>
             <para>
-              Text indexes are not supported.
+              There are no prefix indexes; only entire fields can be
+              indexed.
             </para>
           </listitem>
 
           <listitem>
             <para>
+              Text indexes are not supported. That is, you cannot create
+              indexes on columns of any of the <literal>TEXT</literal>
+              datatypes, nor does the <literal>NDB</literal> storage
+              engine support <literal>FULLTEXT</literal> indexes (these
+              are supported by <literal>MyISAM</literal> only). However,
+              you can index <literal>VARCHAR</literal> columns of
+              <literal>NDB</literal> tables. 
+            </para>
+          </listitem>
+
+          <listitem>
+            <para>
               A <literal>BIT</literal> column cannot be a primary key or
               part of a composite primary key.
             </para>