List:Commits« Previous MessageNext Message »
From:jon Date:January 20 2006 11:54am
Subject:svn commit - mysqldoc@docsrva: r948 - trunk/refman-5.1
View as plain text  
Author: jstephens
Date: 2006-01-20 12:54:41 +0100 (Fri, 20 Jan 2006)
New Revision: 948

Log:

Added some items to Partitioning Limitations.



Modified:
   trunk/refman-5.1/partitioning.xml

Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml	2006-01-20 11:37:52 UTC (rev 947)
+++ trunk/refman-5.1/partitioning.xml	2006-01-20 11:54:41 UTC (rev 948)
@@ -3274,9 +3274,40 @@
     <itemizedlist>
       <listitem>
         <para>
-          Partitioned tables do not support foreign keys.
+          Partitioned tables do not support foreign keys. This includes
+          partitioned tables employing the <literal>InnoDB</literal>
+          storage engine.
         </para>
       </listitem>
+      
+      <listitem>
+        <para>
+          Partitioned table may use any available MySQL storage engine;
+          however, all of the table's partitions and subpartitions (if
+          there are any of the latter) use the same engine.
+        </para>
+        
+        <para>
+          We expect to lift this restriction in a future MySQL release.
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          A partitioning key must be either an integer column or an
+          expression that resolves to an integer. In either case, the
+          value used must be non-negative. Currently,
+          <literal>NULL</literal> values are also permitted; however,
+          this is subject to change.
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          Subpartitions are limited to <literal>HASH</literal> or
+          <literal>KEY</literal> partitioning.
+        </para>
+      </listitem>
     </itemizedlist>
     
   </section>

Thread
svn commit - mysqldoc@docsrva: r948 - trunk/refman-5.1jon20 Jan