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.1 | jon | 20 Jan |
