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>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r611 - in trunk: refman-5.0 refman-5.1 refman-common | jon | 21 Dec |
