From: jon
Date: December 21 2005 3:42pm
Subject: svn commit - mysqldoc@docsrva: r611 - in trunk: refman-5.0 refman-5.1 refman-common
List-Archive: http://lists.mysql.com/commits/326
Message-Id: <200512211542.jBLFg9nK009293@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2005-12-21 16:42:08 +0100 (Wed, 21 Dec 2005)
New Revision: 611

Log:

Documenting bugfixes:

  Bug #12770, Bug #13640, Bug #15209 (5.0)
  Bug #7947 (4.1/5.0)
  Bug #10932 (5.0/5.1)
  
  Updated 5.0/5.1 storage-engines: new --with-indexes-128 ./configure option.
  (See Bug #10932 - remarks from Ingo)



Modified:
   trunk/refman-5.0/storage-engines.xml
   trunk/refman-5.1/storage-engines.xml
   trunk/refman-common/news-4.1.xml
   trunk/refman-common/news-5.0.xml
   trunk/refman-common/news-5.1.xml

Modified: trunk/refman-5.0/storage-engines.xml
===================================================================
--- trunk/refman-5.0/storage-engines.xml	2005-12-21 13:12:32 UTC (rev 610)
+++ trunk/refman-5.0/storage-engines.xml	2005-12-21 15:42:08 UTC (rev 611)
@@ -559,9 +559,16 @@
       <listitem>
         <para>
           The maximum number of indexes per <literal>MyISAM</literal>
-          table is 64. This can be changed by recompiling. The maximum
-          number of columns per index is 16.
+          table is 64. This can be changed by recompiling; beginning
+          with MySQL 5.1.4, you can configure the build using the
+          <option>--with-indexes-128</option> option in order to enable
+          support for up to 128 indexes per <literal>MyISAM</literal>
+          table.
         </para>
+        
+        <para>
+          The maximum number of columns per index is 16.
+        </para>
       </listitem>
 
       <listitem>

Modified: trunk/refman-5.1/storage-engines.xml
===================================================================
--- trunk/refman-5.1/storage-engines.xml	2005-12-21 13:12:32 UTC (rev 610)
+++ trunk/refman-5.1/storage-engines.xml	2005-12-21 15:42:08 UTC (rev 611)
@@ -563,9 +563,16 @@
       <listitem>
         <para>
           The maximum number of indexes per <literal>MyISAM</literal>
-          table is 64. This can be changed by recompiling. The maximum
-          number of columns per index is 16.
+          table is 64. This can be changed by recompiling; beginning
+          with MySQL 5.1.4, you can configure the build using the
+          <option>--with-indexes-128</option> option in order to enable
+          support for up to 128 indexes per <literal>MyISAM</literal>
+          table.
         </para>
+        
+        <para>
+          The maximum number of columns per index is 16.
+        </para>
       </listitem>
 
       <listitem>

Modified: trunk/refman-common/news-4.1.xml
===================================================================
--- trunk/refman-common/news-4.1.xml	2005-12-21 13:12:32 UTC (rev 610)
+++ trunk/refman-common/news-4.1.xml	2005-12-21 15:42:08 UTC (rev 611)
@@ -375,6 +375,30 @@
     </remark>
 
     <itemizedlist>
+      
+      <listitem>
+        <para>
+          <literal>InnoDB</literal>: During replication, There was a
+          failure to record events in the binary log that still occurred
+          even in the event of a <literal>ROLLBACK</literal>. For
+          example, this sequence of commands:
+        </para>
+        
+<programlisting>
+BEGIN;
+CREATE TEMPORARY TABLE t1 (a INT) ENGINE=INNODB;
+ROLLBACK;
+INSERT INTO t1 VALUES (1);
+</programlisting>
+        
+        <para>
+          would succeed on the replication master as expected. However,
+          the <literal>INSERT</literal> would fail on the slave because
+          the <literal>ROLLBACK</literal> would (erroneously) cause the
+          <literal>CREATE TEMPORARY TABLE</literal> statement not to be
+          written to the binlog. (Bug #7947) 
+        </para>
+      </listitem>
 
       <listitem>
         <para>

Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml	2005-12-21 13:12:32 UTC (rev 610)
+++ trunk/refman-common/news-5.0.xml	2005-12-21 15:42:08 UTC (rev 611)
@@ -176,6 +176,13 @@
     </para>
 
     <itemizedlist>
+      
+      <para>
+        It is now possible to build the server such that
+        <literal>MyISAM</literal> tables can support up to 128 keys
+        rather than the standard 64. This can be done by configuring the
+        build using the option <option>--with-indexes-128</option>.
+      </para>
 
       <listitem>
         <para>
@@ -208,6 +215,19 @@
       
       <listitem>
         <para>
+          The server would not compile under Cygwin. (Bug #13640)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          <literal>DESCRIBE</literal> did not function with temporary
+          tables. (Bug #12770)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
           Reversing the order of operands in a <literal>WHERE</literal>
           clause testing a simple equality (such as <literal>WHERE
             t1.col1 = t2.col2</literal>) would produce different
@@ -403,8 +423,37 @@
 
     <itemizedlist>
       
+      <para>
+        <command>mysqld</command> would not start on Windows 9X
+        operating systems including Windows Me. (Bug #15209)
+      </para>
+      
       <listitem>
         <para>
+          <literal>InnoDB</literal>: During replication, There was a
+          failure to record events in the binary log that still occurred
+          even in the event of a <literal>ROLLBACK</literal>. For
+          example, this sequence of commands:
+        </para>
+        
+<programlisting>
+BEGIN;
+CREATE TEMPORARY TABLE t1 (a INT) ENGINE=INNODB;
+ROLLBACK;
+INSERT INTO t1 VALUES (1);
+</programlisting>
+        
+        <para>
+          would succeed on the replication master as expected. However,
+          the <literal>INSERT</literal> would fail on the slave because
+          the <literal>ROLLBACK</literal> would (erroneously) cause the
+          <literal>CREATE TEMPORARY TABLE</literal> statement not to be
+          written to the binlog. (Bug #7947) 
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
           A bug in <filename>mysql-test/t/mysqltest.test</filename>
           caused that test to fail. (Bug #15605)
         </para>

Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml	2005-12-21 13:12:32 UTC (rev 610)
+++ trunk/refman-common/news-5.1.xml	2005-12-21 15:42:08 UTC (rev 611)
@@ -54,6 +54,14 @@
     </para>
 
     <itemizedlist>
+      
+      <para>
+        It is now possible to build the server such that
+        <literal>MyISAM</literal> tables can support up to 128 keys
+        rather than the standard 64. This can be done by configuring the
+        build using the option <option>--with-indexes-128</option>. (Bug
+        #10932)
+      </para>
 
       <listitem>
         <para>