Author: paul
Date: 2009-01-12 21:11:31 +0100 (Mon, 12 Jan 2009)
New Revision: 13108
Log:
r37205@frost: paul | 2009-01-12 14:12:32 -0500
Document bugfixes:
Bug#8457: Precision math: DIV returns incorrect result with large decimal value
Bug#41131: "Questions" fails to increment - ignores statements instead stored procs
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/refman-4.1/functions-core.xml
trunk/refman-5.0/dba-mysqld-server-core.xml
trunk/refman-5.0/functions-core.xml
trunk/refman-5.1/dba-mysqld-server-core.xml
trunk/refman-5.1/functions-core.xml
trunk/refman-6.0/dba-mysqld-server-core.xml
trunk/refman-6.0/functions-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:40875
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:37203
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:35335
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:40875
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:37205
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:35335
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 2, Lines Added: 63, Lines Deleted: 0; 1986 bytes
@@ -26928,6 +26928,7 @@
</bugs>
<versions>
+ <version ver="5.0.72"/>
<version ver="5.1.31"/>
<version ver="6.0.6"/>
</versions>
@@ -39788,4 +39789,66 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="8457"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="DIV"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.10"/>
+ </versions>
+
+ <message>
+
+ <para>
+ For the <literal role="op">DIV</literal> operator, incorrect
+ results could occur for non-integer operands that exceed
+ <literal role="type">BIGINT</literal> range. Now, if either
+ operand has a non-integer type, the operands are converted to
+ <literal role="type">DECIMAL</literal> and divided using
+ <literal role="type">DECIMAL</literal> arithmetic before
+ converting the result to <literal role="type">BIGINT</literal>.
+ If the result exceeds <literal>BIGINT</literal> range, an error
+ occurs.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="feature">
+
+ <tags>
+ <manual type="Queries"/>
+ <manual type="Questions"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="XXX"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.76"/>
+ </versions>
+
+ <message>
+
+ <para>
+ A new status variable,
+ <literal role="statvar">Queries</literal>, indicates the number
+ of statements executed by the server. This includes statements
+ executed within stored programs, unlike the
+ <literal role="statvar">Questions</literal> variable which
+ includes only statements sent to the server by clients.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 23, Lines Deleted: 0; 891 bytes
@@ -4306,6 +4306,29 @@
</mysqloption>
+ <mysqloption section="server" id="Queries">
+
+ <xrefto id="statvar_Queries"/>
+
+ <name>Queries</name>
+
+ <shortdescription lang="en">
+ The number of statements executed by the server
+ </shortdescription>
+
+ <types>
+ <vartype isdynamic="no" class="status" scope="both"/>
+ </types>
+
+ <values vartype="numeric" platform="all"/>
+
+ <versions>
+ <manual version="5.0"/>
+ <introduced version="5.0.76"/>
+ </versions>
+
+ </mysqloption>
+
<mysqloption section="server" id="Questions">
<xrefto id="statvar_Questions"/>
Modified: trunk/refman-4.1/functions-core.xml
===================================================================
--- trunk/refman-4.1/functions-core.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/refman-4.1/functions-core.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 727 bytes
@@ -5737,7 +5737,9 @@
<para>
Integer division. Similar to
<literal role="func">FLOOR()</literal>, but is safe with
- <literal role="type">BIGINT</literal> values.
+ <literal role="type">BIGINT</literal> values. Incorrect
+ results may occur for non-integer operands that exceed
+ <literal role="type">BIGINT</literal> range.
</para>
<remark role="help-description-end"/>
Modified: trunk/refman-5.0/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-5.0/dba-mysqld-server-core.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/refman-5.0/dba-mysqld-server-core.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 18, Lines Deleted: 1; 1292 bytes
@@ -11436,12 +11436,29 @@
</listitem>
<listitem>
+ <para id="statvar_Queries">
+ <literal role="statvar">Queries</literal>
+ </para>
+
+ <para>
+ The number of statements executed by the server. This variable
+ includes statements executed within stored programs, unlike
+ the <literal>Questions</literal> variable. This variable was
+ added in MySQL 5.0.76.
+ </para>
+ </listitem>
+
+ <listitem>
<para id="statvar_Questions">
<literal role="statvar">Questions</literal>
</para>
<para>
- The number of statements that clients have sent to the server.
+ The number of statements executed by the server. As of MySQL
+ 5.0.72, this includes only statements sent to the server by
+ clients and no longer includes statements executed within
+ stored programs, unlike the <literal>Queries</literal>
+ variable.
</para>
</listitem>
Modified: trunk/refman-5.0/functions-core.xml
===================================================================
--- trunk/refman-5.0/functions-core.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/refman-5.0/functions-core.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 727 bytes
@@ -5930,7 +5930,9 @@
<para>
Integer division. Similar to
<literal role="func">FLOOR()</literal>, but is safe with
- <literal role="type">BIGINT</literal> values.
+ <literal role="type">BIGINT</literal> values. Incorrect
+ results may occur for non-integer operands that exceed
+ <literal role="type">BIGINT</literal> range.
</para>
<remark role="help-description-end"/>
Modified: trunk/refman-5.1/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-5.1/dba-mysqld-server-core.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/refman-5.1/dba-mysqld-server-core.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 1; 686 bytes
@@ -12063,7 +12063,10 @@
</para>
<para>
- The number of statements that clients have sent to the server.
+ The number of statements executed by the server. As of MySQL
+ 5.1.31, this includes only statements sent to the server by
+ clients and no longer includes statements executed within
+ stored programs.
</para>
</listitem>
Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/refman-5.1/functions-core.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 1; 727 bytes
@@ -5860,7 +5860,9 @@
<para>
Integer division. Similar to
<literal role="func">FLOOR()</literal>, but is safe with
- <literal role="type">BIGINT</literal> values.
+ <literal role="type">BIGINT</literal> values. Incorrect
+ results may occur for non-integer operands that exceed
+ <literal role="type">BIGINT</literal> range.
</para>
<remark role="help-description-end"/>
Modified: trunk/refman-6.0/dba-mysqld-server-core.xml
===================================================================
--- trunk/refman-6.0/dba-mysqld-server-core.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/refman-6.0/dba-mysqld-server-core.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 1; 685 bytes
@@ -12278,7 +12278,10 @@
</para>
<para>
- The number of statements that clients have sent to the server.
+ The number of statements executed by the server. As of MySQL
+ 6.0.6, this includes only statements sent to the server by
+ clients and no longer includes statements executed within
+ stored programs.
</para>
</listitem>
Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml 2009-01-12 18:43:38 UTC (rev 13107)
+++ trunk/refman-6.0/functions-core.xml 2009-01-12 20:11:31 UTC (rev 13108)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 0; 1079 bytes
@@ -6305,6 +6305,19 @@
<literal role="type">BIGINT</literal> values.
</para>
+ <para>
+ As of MySQL 6.0.10, if either operand has a non-integer
+ type, the operands are converted to
+ <literal role="type">DECIMAL</literal> and divided using
+ <literal role="type">DECIMAL</literal> arithmetic before
+ converting the result to
+ <literal role="type">BIGINT</literal>. If the result exceeds
+ <literal>BIGINT</literal> range, an error occurs. Before
+ MySQL 6.0.10, incorrect results may occur for non-integer
+ operands that exceed <literal role="type">BIGINT</literal>
+ range.
+ </para>
+
<remark role="help-description-end"/>
<remark role="help-example"/>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r13108 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul.dubois | 12 Jan |
