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

[jon]

Author: jstephens
Date: 2005-12-06 11:38:47 +0100 (Tue, 06 Dec 2005)
New Revision: 494

Log:

Fix some issues noted by Kolbe.



Modified:
   trunk/refman-5.1/partitioning.xml

Modified: trunk/refman-5.1/partitioning.xml
===================================================================
--- trunk/refman-5.1/partitioning.xml	2005-12-05 20:56:02 UTC (rev 493)
+++ trunk/refman-5.1/partitioning.xml	2005-12-06 10:38:47 UTC (rev 494)
@@ -1286,7 +1286,7 @@
 
         <para>
           For example, suppose that the table <literal>t1</literal>,
-          using linear hash partitioning and having 4 partitions, is
+          using linear hash partitioning and having 6 partitions, is
           created using this statement:
         </para>
 
@@ -1324,13 +1324,13 @@
   = 1998 &amp; 7
   = 6
 
-(<emphasis>6 &gt;= 4 is TRUE: additional step required</emphasis>)
+(<emphasis>6 &gt;= 6 is TRUE: additional step required</emphasis>)
 
 <replaceable>N</replaceable> = 6 &amp; CEILING(5 / 2)
   = 6 &amp; 3
   = 2
 
-(<emphasis>2 &gt;= 4 is FALSE: record stored in partition #2</emphasis>)
+(<emphasis>2 &gt;= 6 is FALSE: record stored in partition #2</emphasis>)
 </programlisting>
 
         <para>
@@ -2079,9 +2079,9 @@
 </programlisting>
 
     <para>
-      This has the same effect as dropping the table and re-creating it
-      using <literal>CREATE TABLE trb3 PARTITION BY KEY(id) PARTITIONS
-      2;</literal>.
+      This has the same effect on the structure of the table as dropping
+      the table and re-creating it using <literal>CREATE TABLE trb3
+        PARTITION BY KEY(id) PARTITIONS 2;</literal>.
     </para>
 
     <section id="partitioning-management-range-list">
@@ -2332,7 +2332,9 @@
       </para>
 
 <programlisting>
-mysql&gt; <userinput>ALTER TABLE members ADD PARTITION (PARTITION p3 VALUES
LESS THAN (1960));</userinput>
+mysql&gt; <userinput>ALTER TABLE members</userinput>
+     &gt;     <userinput>ADD PARTITION (</userinput>
+     &gt;     <userinput>PARTITION p3 VALUES LESS THAN
(1960));</userinput>
 ERROR 1463 (HY000): VALUES LESS THAN value must be strictly increasing for each partition
 </programlisting>
 
@@ -2371,7 +2373,8 @@
       </para>
 
 <programlisting>
-mysql&gt; <userinput>ALTER TABLE tt ADD PARTITION (PARTITION np VALUES IN (4,
8, 12));</userinput>
+mysql&gt; <userinput>ALTER TABLE tt ADD PARTITION </userinput>
+     &gt;     <userinput>(PARTITION np VALUES IN (4, 8, 12));</userinput>
 ERROR 1465 (HY000): Multiple definition of same constant in list partitioning
 </programlisting>
 
@@ -2476,7 +2479,9 @@
       </para>
 
 <programlisting>
-ALTER TABLE <replaceable>tbl_name</replaceable> REORGANIZE PARTITION
<replaceable>partition_list</replaceable> INTO
(<replaceable>partition_definitions</replaceable>);
+ALTER TABLE <replaceable>tbl_name</replaceable> 
+    REORGANIZE PARTITION <replaceable>partition_list</replaceable> 
+    INTO (<replaceable>partition_definitions</replaceable>);
 </programlisting>
 
       <para>
@@ -2864,8 +2869,8 @@
 
         <listitem>
           <para>
-            <literal>Repairing partitions</literal>: This repairs
-            corrupted partitions.
+            <emphasis role="bold">Repairing partitions</emphasis>: This
+            repairs corrupted partitions.
           </para>
 
           <para>