Author: paul
Date: 2008-02-29 20:17:23 +0100 (Fri, 29 Feb 2008)
New Revision: 10077
Log:
r29807@arctic: paul | 2008-02-29 13:05:28 -0600
Document bugfixes:
Bug#26447: "ALTER TABLE .. ORDER" does not work with InnoDB and
auto_increment keys
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/refman-5.1/optimization.xml
trunk/refman-6.0/optimization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29613
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29806
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:29613
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:29807
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-02-29 19:17:10 UTC (rev 10076)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-02-29 19:17:23 UTC (rev 10077)
Changed blocks: 1, Lines Added: 42, Lines Deleted: 0; 1566 bytes
@@ -9910,4 +9910,46 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="InnoDB"/>
+ <manual type="ALTER TABLE"/>
+ <manual type="ORDER BY"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="26447"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ It makes no sense to attempt to use <literal>ALTER TABLE ...
+ ORDER BY</literal> to order an <literal>InnoDB</literal> table
+ if there is a user-defined clustered index, because rows are
+ always ordered by the clustered index. Such attempts now are
+ ignored and produce a warning.
+ </para>
+
+ <para>
+ Also, in some cases, <literal>InnoDB</literal> incorrectly used
+ a secondary index when the clustered index would produce a
+ faster scan. <literal>EXPLAIN</literal> output now indicates use
+ of the clustered index (for tables that have one) as lines with
+ a <literal>type</literal> value of <literal>index</literal>, a
+ <literal>key</literal> value of <literal>PRIMARY</literal>, and
+ without <literal>Using index</literal> in the
+ <literal>Extra</literal> value.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml 2008-02-29 19:17:10 UTC (rev 10076)
+++ trunk/refman-5.1/optimization.xml 2008-02-29 19:17:23 UTC (rev 10077)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 942 bytes
@@ -1630,6 +1630,16 @@
can be used when the query uses only columns that are
part of a single index.
</para>
+
+ <para>
+ For <literal>InnoDB</literal> tables that have a
+ user-defined clustered index, that index can be used
+ even when <literal>Using index</literal> is absent from
+ the <literal>Extra</literal> column. This is the case if
+ if <literal>type</literal> is <literal>index</literal>
+ and <literal>key</literal> is
+ <literal>PRIMARY</literal>.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-6.0/optimization.xml
===================================================================
--- trunk/refman-6.0/optimization.xml 2008-02-29 19:17:10 UTC (rev 10076)
+++ trunk/refman-6.0/optimization.xml 2008-02-29 19:17:23 UTC (rev 10077)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 942 bytes
@@ -1628,6 +1628,16 @@
can be used when the query uses only columns that are
part of a single index.
</para>
+
+ <para>
+ For <literal>InnoDB</literal> tables that have a
+ user-defined clustered index, that index can be used
+ even when <literal>Using index</literal> is absent from
+ the <literal>Extra</literal> column. This is the case if
+ if <literal>type</literal> is <literal>index</literal>
+ and <literal>key</literal> is
+ <literal>PRIMARY</literal>.
+ </para>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10077 - in trunk: . dynamic-docs/changelog refman-5.1 refman-6.0 | paul | 29 Feb |
