svn commit - mysqldoc@docsrva: r761 - trunk/refman-5.1

[jon]

Author: jstephens
Date: 2006-01-11 12:23:33 +0100 (Wed, 11 Jan 2006)
New Revision: 761

Log:

Cluster tables in 5.1 don't support DROP PARTITION. (Thanks, Mikael!)



Modified:
   trunk/refman-5.1/ndbcluster.xml
   trunk/refman-5.1/partitioning.xml
   trunk/refman-5.1/sql-syntax.xml

Modified: trunk/refman-5.1/ndbcluster.xml
===================================================================
--- trunk/refman-5.1/ndbcluster.xml	2006-01-11 05:18:17 UTC (rev 760)
+++ trunk/refman-5.1/ndbcluster.xml	2006-01-11 11:23:33 UTC (rev 761)
@@ -10398,6 +10398,21 @@
               however, spatial indexes are not supported.
             </para>
           </listitem>
+          
+          <listitem>
+            <para>
+              It is not possible to drop partitions from
+              <literal>NDB</literal> tables using <literal>ALTER TABLE
+                ... DROP PARTITION</literal>. The other partitioning
+              extensions to <literal>ALTER TABLE</literal> &mdash;
+              <literal>ADD PARTITION</literal>, <literal>REORGANIZE
+                PARTITION</literal>, and <literal>COALESCE
+                  PARTITION</literal> &mdash; are supported for Cluster
+              tables, but use copying and so are not optimised. See 
+              <xref linkend="partitioning-management-range-list"/> 
+              and <xref linkend="alter-table"/>.
+            </para>
+          </listitem>
 
         </itemizedlist>
       </listitem>

Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml	2006-01-11 05:18:17 UTC (rev 760)
+++ trunk/refman-5.1/partitioning.xml	2006-01-11 11:23:33 UTC (rev 761)
@@ -2179,6 +2179,14 @@
 mysql&gt; <userinput>ALTER TABLE tr DROP PARTITION p2;</userinput>
 Query OK, 0 rows affected (0.03 sec)
 </programlisting>
+      
+      <para>
+        Note: In MySQL &current-series;, the <literal>NDB
+          Cluster</literal> storage engine does not support
+        <literal>ALTER TABLE ... DROP PARTITION</literal>. It does,
+        however, support the other partitioning-related extensions to
+        <literal>ALTER TABLE</literal> that are described in this chapter. 
+      </para>
 
       <para>
         It is very important to remember that, <emphasis>when you drop a

Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-01-11 05:18:17 UTC (rev 760)
+++ trunk/refman-5.1/sql-syntax.xml	2006-01-11 11:23:33 UTC (rev 761)
@@ -856,7 +856,15 @@
 
 <programlisting>
 ALTER TABLE DROP PARTITION p0, p1;
-</programlisting>
+</programlisting>          
+          
+          <para>
+            Note that <literal>DROP PARTITION</literal> does not work
+            with tables that use the <literal>NDB Cluster</literal>
+            storage engine. See 
+            <xref linkend="partitioning-management-range-list"/> and
+            <xref linkend="mysql-cluster-limitations"/>.
+          </para>
 
           <para>
             <literal>ADD PARTITION</literal> and <literal>DROP