Re: svn commit - mysqldoc@docsrva: r11633 - in trunk: dynamic-docs/changelog refman-5.1 refman-6.0

[Mattias Jonsson]

Hi,

(I might have misread the changeset, but as I understand the change):

the ALTER TABLE ... ANALYZE|CHECK|OPTIMIZE|REPAIR PARTITION is also 
enabled again! (I did not see any comment about this in the cset)

And bug#20129 was never about mysqlcheck or myisamchk. (see bug#37537 
for more info)


Regards
Mattias

jon@stripped wrote:
> Author: jstephens
> Date: 2008-09-02 14:14:31 +0200 (Tue, 02 Sep 2008)
> New Revision: 11633
> 
> Log:
> 
> Documented new fix for Partitioning Bug #20129:
> 
> ANALYZE|CHECK|OPTIMIZE|REPAIR TABLE supported with partitioned tables
> in 5.1.27+/6.0.7+.
> 
> 
> 
> Modified:
>    trunk/dynamic-docs/changelog/mysqld-1.xml
>    trunk/refman-5.1/partitioning.xml
>    trunk/refman-5.1/sql-syntax-data-definition.xml
>    trunk/refman-6.0/partitioning.xml
>    trunk/refman-6.0/sql-syntax-data-definition.xml
> 
> 
> Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
> ===================================================================
> --- trunk/dynamic-docs/changelog/mysqld-1.xml	2008-08-30 02:18:16 UTC (rev 11632)
> +++ trunk/dynamic-docs/changelog/mysqld-1.xml	2008-09-02 12:14:31 UTC (rev 11633)
> Changed blocks: 2, Lines Added: 40, Lines Deleted: 1; 1785 bytes
> 
> @@ -3799,9 +3799,11 @@
>      <versions>
>        <version ver="5.1.24"/>
>        <version ver="6.0.5"/>
> +      <version ver="5.1.27"/>
> +      <version ver="6.0.7"/>
>      </versions>
>  
> -    <message>
> +    <message ver="5.1.24,6.0.5">
>  
>        <para>
>          The following statements did not function correctly with
> 
> @@ -3843,6 +3845,43 @@
>  
>      </message>
>  
> +    <message ver="5.1.27,6.0.7">
> +
> +      <para>
> +        The statements <literal>ANALYZE TABLE</literal>,
> <literal>CHECK
> +        TABLE</literal>, <literal>OPTIMIZE TABLE</literal>, and
> +        <literal>REPAIR TABLE</literal> are now supported for
> +        partitioned tables.
> +      </para>
> +
> +    </message>
> +
> +    <message ver="5.1.27">
> +
> +      <para>
> +        This restores functionality missing since the removal of
> +        <literal>ALTER TABLE ... ANALYZE PARTITION</literal>,
> +        <literal>ALTER TABLE ... CHECK PARTITION</literal>,
> +        <literal>ALTER TABLE ... OPTIMIZE PARTITION</literal>, and
> +        <literal>ALTER TABLE ... REPAIR PARTITION</literal> in MySQL
> +        5.1.24.
> +      </para>
> +
> +    </message>
> +
> +    <message ver="6.0.7">
> +
> +      <para>
> +        This restores functionality missing since the removal of
> +        <literal>ALTER TABLE ... ANALYZE PARTITION</literal>,
> +        <literal>ALTER TABLE ... CHECK PARTITION</literal>,
> +        <literal>ALTER TABLE ... OPTIMIZE PARTITION</literal>, and
> +        <literal>ALTER TABLE ... REPAIR PARTITION</literal> in MySQL
> +        6.0.5.
> +      </para>
> +
> +    </message>
> +
>    </logentry>
>  
>    <logentry entrytype="bug">
> 
> 
> Modified: trunk/refman-5.1/partitioning.xml
> ===================================================================
> --- trunk/refman-5.1/partitioning.xml	2008-08-30 02:18:16 UTC (rev 11632)
> +++ trunk/refman-5.1/partitioning.xml	2008-09-02 12:14:31 UTC (rev 11633)
> Changed blocks: 1, Lines Added: 15, Lines Deleted: 9; 1892 bytes
> 
> @@ -4918,19 +4918,25 @@
>            <para>
>              The statements <literal>CHECK TABLE</literal>,
>              <literal>OPTIMIZE TABLE</literal>, <literal>ANALYZE
> -            TABLE</literal>, and <literal>REPAIR TABLE</literal>
> are not
> -            supported for partitioned tables.
> +            TABLE</literal>, and <literal>REPAIR TABLE</literal>
> are
> +            supported for partitioned tables beginning with MySQL
> +            5.1.27. Also in MySQL 5.1.27 and later,
>              <command>mysqlcheck</command> and
> -            <command>myisamchk</command> are also not supported for
> -            partitioned tables. However, you can use <literal>ALTER
> -            TABLE ... REBUILD PARTITION</literal> to rebuild one or more
> -            partitions of a partitioned table; <literal>ALTER TABLE ...
> -            REORGANIZE PARTITION</literal> also causes partitions to be
> -            rebuilt. See <xref linkend="alter-table"/>, for more
> -            information about these two statements.
> +            <command>myisamchk</command> are supported with
> partitioned.
> +            (See Bug #20129.)
>            </para>
>  
>          </formalpara>
> +
> +        <para>
> +          In addition, you can use <literal>ALTER TABLE ... REBUILD
> +          PARTITION</literal> to rebuild one or more partitions of a
> +          partitioned table; <literal>ALTER TABLE ... REORGANIZE
> +          PARTITION</literal> also causes partitions to be rebuilt. Both
> +          of these statements were added in MySQL 5.1.5. See
> +          <xref linkend="alter-table"/>, for more information about
> +          these two statements.
> +        </para>
>        </listitem>
>  
>      </itemizedlist>
> 
> 
> Modified: trunk/refman-5.1/sql-syntax-data-definition.xml
> ===================================================================
> --- trunk/refman-5.1/sql-syntax-data-definition.xml	2008-08-30 02:18:16 UTC (rev
> 11632)
> +++ trunk/refman-5.1/sql-syntax-data-definition.xml	2008-09-02 12:14:31 UTC (rev
> 11633)
> Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 892 bytes
> 
> @@ -1794,6 +1794,17 @@
>            and <literal>REPAIR PARTITION</literal> options were removed
>            in MySQL 5.1.24.
>          </para>
> +
> +        <note>
> +          <para>
> +            Beginning with MySQL 5.1.27, you can use the statements
> +            <literal>ANALYZE TABLE</literal>, <literal>CHECK
> +            TABLE</literal>, <literal>OPTIMIZE TABLE</literal>,
> and
> +            <literal>REPAIR TABLE</literal> on partitioned tables. See
> +            <xref linkend="table-maintenance-sql"/>, for more
> +            information.
> +          </para>
> +        </note>
>        </listitem>
>  
>        <listitem>
> 
> 
> Modified: trunk/refman-6.0/partitioning.xml
> ===================================================================
> --- trunk/refman-6.0/partitioning.xml	2008-08-30 02:18:16 UTC (rev 11632)
> +++ trunk/refman-6.0/partitioning.xml	2008-09-02 12:14:31 UTC (rev 11633)
> Changed blocks: 1, Lines Added: 14, Lines Deleted: 10; 1869 bytes
> 
> @@ -4824,19 +4824,23 @@
>            <para>
>              The statements <literal>CHECK TABLE</literal>,
>              <literal>OPTIMIZE TABLE</literal>, <literal>ANALYZE
> -            TABLE</literal>, and <literal>REPAIR TABLE</literal>
> are not
> -            supported for partitioned tables.
> -            <command>mysqlcheck</command> and
> -            <command>myisamchk</command> are also not supported for
> -            partitioned tables. However, you can use <literal>ALTER
> -            TABLE ... REBUILD PARTITION</literal> to rebuild one or more
> -            partitions of a partitioned table; <literal>ALTER TABLE ...
> -            REORGANIZE PARTITION</literal> also causes partitions to be
> -            rebuilt. See <xref linkend="alter-table"/>, for more
> -            information about these two statements.
> +            TABLE</literal>, and <literal>REPAIR TABLE</literal>
> are
> +            supported for partitioned tables beginning with MySQL 6.0.7.
> +            Also in MySQL 6.0.7 and later,
> <command>mysqlcheck</command>
> +            and <command>myisamchk</command> are supported with
> +            partitioned tables. (See Bug #20129.)
>            </para>
>  
>          </formalpara>
> +
> +        <para>
> +          In addition, you can use <literal>ALTER TABLE ... REBUILD
> +          PARTITION</literal> to rebuild one or more partitions of a
> +          partitioned table; <literal>ALTER TABLE ... REORGANIZE
> +          PARTITION</literal> also causes partitions to be rebuilt. See
> +          <xref linkend="alter-table"/>, for more information about
> +          these two statements.
> +        </para>
>        </listitem>
>  
>      </itemizedlist>
> 
> 
> Modified: trunk/refman-6.0/sql-syntax-data-definition.xml
> ===================================================================
> --- trunk/refman-6.0/sql-syntax-data-definition.xml	2008-08-30 02:18:16 UTC (rev
> 11632)
> +++ trunk/refman-6.0/sql-syntax-data-definition.xml	2008-09-02 12:14:31 UTC (rev
> 11633)
> Changed blocks: 1, Lines Added: 12, Lines Deleted: 3; 1204 bytes
> 
> @@ -1540,10 +1540,19 @@
>            The <literal>ANALYZE PARTITION</literal>,
> <literal>CHECK
>            PARTITION</literal>, <literal>OPTIMIZE
> PARTITION</literal>,
>            and <literal>REPAIR PARTITION</literal> options were removed
> -          in MySQL 6.0.5. We intend to reintroduce them (or replace them
> -          with similar statement providing similar functionality) in a
> -          future MySQL release.
> +          in MySQL 6.0.5.
>          </para>
> +
> +        <note>
> +          <para>
> +            Beginning with MySQL 6.0.7, you can use the statements
> +            <literal>ANALYZE TABLE</literal>, <literal>CHECK
> +            TABLE</literal>, <literal>OPTIMIZE TABLE</literal>,
> and
> +            <literal>REPAIR TABLE</literal> on partitioned tables. See
> +            <xref linkend="table-maintenance-sql"/>, for more
> +            information.
> +          </para>
> +        </note>
>        </listitem>
>  
>        <listitem>
> 
> 
>