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

[jstephens]

Author: jstephens
Date: 2006-07-31 11:55:48 +0200 (Mon, 31 Jul 2006)
New Revision: 2896

Log:
NDB no longer shows PARTITION BY KEY() for tables that are not explicitly
partitioned, cut reference to former behaviour (Mikael)

Modified:
   trunk/refman-5.1/partitioning.xml


Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml	2006-07-31 06:40:29 UTC (rev 2895)
+++ trunk/refman-5.1/partitioning.xml	2006-07-31 09:55:48 UTC (rev 2896)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 32; 2033 bytes

@@ -1632,41 +1632,14 @@
             MySQL 5.1.6, tables using the <literal>NDB Cluster</literal>
             storage engine are implicitly partitioned by
             <literal>KEY</literal>, again using the table's primary key
-            as the partitioning key. For example, consider a table
-            created using the following statement:
+            as the partitioning key. In the event that the Cluster table
+            has no explicit primary key, the <quote>hidden</quote>
+            primary key generated by the <literal>NDB</literal> storage
+            engine for each Cluster table is used as the partitioning
+            key.
           </para>
 
-<programlisting>
-CREATE TABLE kndb (   
-    id INT NOT NULL PRIMARY KEY,   
-    name VARCHAR(20) NOT NULL 
-)
-ENGINE=NDBCLUSTER;
-</programlisting>
-
           <para>
-            Although there is no <literal>PARTITION BY</literal> clause
-            in the table creation statement, the output of <literal>SHOW
-            CREATE TABLE kndb</literal> is as shown here:
-          </para>
-
-<programlisting>
-CREATE TABLE `kndb` (   
-    `id` int(11) NOT NULL,   
-    `name` varchar(20) NOT NULL.
-    PRIMARY KEY  (`id`) 
-)
-ENGINE=ndbcluster DEFAULT CHARSET=latin1 PARTITION BY KEY ();
-</programlisting>
-
-          <para>
-            In the event that the Cluster table has no explicit primary
-            key, the <quote>hidden</quote> primary key generated by the
-            <literal>NDB</literal> storage engine for each Cluster table
-            is used as the partitioning key.
-          </para>
-
-          <para>
             <emphasis role="bold">Important</emphasis>: For a
             key-partitioned table using any MySQL storage engine other
             than <literal>NDB Cluster</literal>, you cannot execute an