Author: paul
Date: 2008-02-01 19:42:31 +0100 (Fri, 01 Feb 2008)
New Revision: 9682
Log:
r28899@arctic: paul | 2008-02-01 12:33:44 -0600
Document bugfixes:
Bug#30252: Com_create_function is not incremented.
Bug#30793: Add option to set the random seed in mysqlslap
Bug#30889: filesort and order by with float/numeric crashes server
Bug#33143: Incorrect ORDER BY for ROUND()/TRUNCATE() result
Bug#33697: "order by col DESC" in a query may give a result set in a wrong order
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/command-optvars/mysqlslap.xml
trunk/refman-6.0/programs-client-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28822
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:23457
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28822
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:28899
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-02-01 18:35:26 UTC (rev 9681)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-02-01 18:42:31 UTC (rev 9682)
Changed blocks: 1, Lines Added: 152, Lines Deleted: 0; 3501 bytes
@@ -6445,4 +6445,156 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="filesort"/>
+ <manual type="DECIMAL"/>
+ <manual type="ORDER BY"/>
+ <manual type="ROUND()"/>
+ <manual type="TRUNCATE()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="30889"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <function role="sql">ROUND(<replaceable>X</replaceable>,<replaceable>D</replaceable>)</function>
+ or
+ <function role="sql">TRUNCATE(<replaceable>X</replaceable>,<replaceable>D</replaceable>)</function>
+ for non-constant values of <replaceable>D</replaceable> could
+ crash the server if these functions were used in an
+ <literal>ORDER BY</literal> that was resolved using
+ <literal>filesort</literal>.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="DECIMAL"/>
+ <manual type="ORDER BY"/>
+ <manual type="ROUND()"/>
+ <manual type="TRUNCATE()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="33143"/>
+ <seealsobug bugid="33402"/>
+ <seealsobug bugid="30617"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ For <literal>DECIMAL</literal> columns used with the
+ <function role="sql">ROUND(<replaceable>X</replaceable>,<replaceable>D</replaceable>)</function>
+ or
+ <function role="sql">TRUNCATE(<replaceable>X</replaceable>,<replaceable>D</replaceable>)</function>
+ function with a non-constant value of
+ <replaceable>D</replaceable>, adding an <literal>ORDER
+ BY</literal> for the function result produced misordered output.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="feature">
+
+ <tags>
+ <manual type="mysqlslap"/>
+ <manual type="set-random-seed"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="30793"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.2.6"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Added the <option>--set-random-seed</option> option to
+ <command>mysqlslap</command> to enable a seed value to be
+ provided for the randomizer.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="ORDER BY"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="33697"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <literal>ORDER BY ... DESC</literal> sorts could produce
+ misordered results.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="SHOW STATUS"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="30252"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The <literal>Com_create_function</literal> status variable was
+ not incremented properly.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/dynamic-docs/command-optvars/mysqlslap.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqlslap.xml 2008-02-01 18:35:26 UTC (rev 9681)
+++ trunk/dynamic-docs/command-optvars/mysqlslap.xml 2008-02-01 18:42:31 UTC (rev 9682)
Changed blocks: 1, Lines Added: 25, Lines Deleted: 0; 944 bytes
@@ -562,6 +562,31 @@
</mysqloption>
+ <mysqloption id="set-random-seed">
+
+ <xrefto id="option_mysqlslap_set-random-seed"/>
+
+ <name>set-random-seed</name>
+
+ <shortdescription lang="en">
+ The seed value for the randomizer
+ </shortdescription>
+
+ <types>
+ <optype class="cmdline" format="--set-random-seed=N"/>
+ <optype class="mycnf"/>
+ </types>
+
+ <values vartype="numeric" platform="all"/>
+
+ <versions>
+ <manual version="5.2"/>
+ <introduced version="5.2.6"/>
+ <manual version="6.0"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption id="silent">
<xrefto id="option_mysqlslap_silent"/>
Modified: trunk/refman-6.0/programs-client-core.xml
===================================================================
--- trunk/refman-6.0/programs-client-core.xml 2008-02-01 18:35:26 UTC (rev 9681)
+++ trunk/refman-6.0/programs-client-core.xml 2008-02-01 18:42:31 UTC (rev 9682)
Changed blocks: 1, Lines Added: 20, Lines Deleted: 0; 1036 bytes
@@ -9291,6 +9291,26 @@
</listitem>
<listitem>
+ <para id="option_mysqlslap_set-random-seed">
+ <indexterm>
+ <primary>mysqlslap</primary>
+ <secondary>set-random-seed option</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>set-random-seed option</primary>
+ <secondary>mysqlslap</secondary>
+ </indexterm>
+
+ <option>--set-random-seed=<replaceable>value</replaceable></option>,
+ </para>
+
+ <para>
+ The seed value for the randomizer.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="option_mysqlslap_silent">
<indexterm>
<primary>mysqlslap</primary>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r9682 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-6.0 | paul | 1 Feb |
