From: Date: October 17 2007 10:06am
Subject: svn commit - mysqldoc@docsrva: r8133 - in trunk: refman-5.1 refman-5.2
List-Archive: http://lists.mysql.com/commits/35734
Message-Id: <200710170806.l9H86APQ021814@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2007-10-17 10:06:08 +0200 (Wed, 17 Oct 2007)
New Revision: 8133

Log:

What "Partitioned tables do not support foreign keys" means.

Fixes Docs Bug #14353.



Modified:
   trunk/refman-5.1/partitioning.xml
   trunk/refman-5.2/partitioning.xml


Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml	2007-10-17 03:37:36 UTC (rev 8132)
+++ trunk/refman-5.1/partitioning.xml	2007-10-17 08:06:08 UTC (rev 8133)
Changed blocks: 2, Lines Added: 25, Lines Deleted: 4; 1504 bytes

@@ -4470,7 +4470,7 @@
       <listitem>
         <formalpara>
 
-          <title>Foreign keys</title>
+          <title>Foreign keys not supported</title>
 
           <indexterm>
             <primary>partitioning</primary>

@@ -4478,9 +4478,30 @@
           </indexterm>
 
           <para>
-            Partitioned tables do not support foreign keys. This
-            includes partitioned tables employing the
-            <literal>InnoDB</literal> storage engine.
+            Partitioned tables do not support foreign keys. This means
+            that:
+
+            <orderedlist>
+
+              <listitem>
+                <para>
+                  Definitions of tables employing user-defined
+                  partitioning may not contain foreign key references to
+                  other tables.
+                </para>
+              </listitem>
+
+              <listitem>
+                <para>
+                  No table may contain a foreign key reference to a
+                  partitioned table.
+                </para>
+              </listitem>
+
+            </orderedlist>
+
+            The scope of these restrictions includes partitioned tables
+            employing the <literal>InnoDB</literal> storage engine.
           </para>
 
         </formalpara>


Modified: trunk/refman-5.2/partitioning.xml
===================================================================
--- trunk/refman-5.2/partitioning.xml	2007-10-17 03:37:36 UTC (rev 8132)
+++ trunk/refman-5.2/partitioning.xml	2007-10-17 08:06:08 UTC (rev 8133)
Changed blocks: 2, Lines Added: 25, Lines Deleted: 4; 1504 bytes

@@ -4364,7 +4364,7 @@
       <listitem>
         <formalpara>
 
-          <title>Foreign keys</title>
+          <title>Foreign keys not supported</title>
 
           <indexterm>
             <primary>partitioning</primary>

@@ -4372,9 +4372,30 @@
           </indexterm>
 
           <para>
-            Partitioned tables do not support foreign keys. This
-            includes partitioned tables employing the
-            <literal>InnoDB</literal> storage engine.
+            Partitioned tables do not support foreign keys. This means
+            that:
+
+            <orderedlist>
+
+              <listitem>
+                <para>
+                  Definitions of tables employing user-defined
+                  partitioning may not contain foreign key references to
+                  other tables.
+                </para>
+              </listitem>
+
+              <listitem>
+                <para>
+                  No table may contain a foreign key reference to a
+                  partitioned table.
+                </para>
+              </listitem>
+
+            </orderedlist>
+
+            The scope of these restrictions includes partitioned tables
+            employing the <literal>InnoDB</literal> storage engine.
           </para>
 
         </formalpara>