Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html
ChangeSet
1.3093 05/07/20 16:59:43 paul@stripped +7 -0
Document div_precision_increment system variable,
MYSQL_TYPE_NEWDECIMAL symbol.
refman/news.xml
1.88 05/07/20 16:59:40 paul@stripped +9 -0
Document div_precision_increment system variable.
refman/mysql-database-administration.xml
1.30 05/07/20 16:59:40 paul@stripped +41 -0
Document div_precision_increment system variable.
refman/mysql-apis.xml
1.16 05/07/20 16:59:39 paul@stripped +35 -26
Update FIELD_TYPE_ symbols to the current
MYSQL_TYPE_ names. Add MYSQL_TYPE_NEWDECIMAL.
refman-5.0/news.xml
1.74 05/07/20 16:59:39 paul@stripped +9 -0
Sync.
refman-5.0/mysql-database-administration.xml
1.32 05/07/20 16:59:39 paul@stripped +41 -0
Sync.
refman-5.0/mysql-apis.xml
1.16 05/07/20 16:59:38 paul@stripped +32 -26
Sync.
refman-4.1/mysql-apis.xml
1.14 05/07/20 16:59:38 paul@stripped +30 -26
Sync.
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: paul
# Host: frost.snake.net
# Root: /Volumes/frost2/MySQL/bk/mysqldoc
--- 1.13/refman-4.1/mysql-apis.xml 2005-07-19 16:33:20 -05:00
+++ 1.14/refman-4.1/mysql-apis.xml 2005-07-20 16:59:38 -05:00
@@ -602,7 +602,11 @@
<para>
The type of the field. The <literal>type</literal> value may
- be one of the following:
+ be one of the <literal>MYSQL_TYPE_</literal> symbols shown
+ in the following table. Before MySQL 4.1, the symbol names
+ begin with <literal>FIELD_TYPE_</literal> rather than
+ <literal>MYSQL_TYPE_</literal>. The older types still are
+ recognized for backward compatibility.
</para>
<informaltable>
@@ -615,86 +619,86 @@
<entry><emphasis role="bold">Type
Description</emphasis></entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TINY</literal></entry>
+
<entry><literal>MYSQL_TYPE_TINY</literal></entry>
<entry><literal>TINYINT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_SHORT</literal></entry>
+
<entry><literal>MYSQL_TYPE_SHORT</literal></entry>
<entry><literal>SMALLINT</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_LONG</literal></entry>
+
<entry><literal>MYSQL_TYPE_LONG</literal></entry>
<entry><literal>INTEGER</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_INT24</literal></entry>
+
<entry><literal>MYSQL_TYPE_INT24</literal></entry>
<entry><literal>MEDIUMINT</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_LONGLONG</literal></entry>
+
<entry><literal>MYSQL_TYPE_LONGLONG</literal></entry>
<entry><literal>BIGINT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DECIMAL</literal></entry>
+
<entry><literal>MYSQL_TYPE_DECIMAL</literal></entry>
<entry><literal>DECIMAL</literal> or
<literal>NUMERIC</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_FLOAT</literal></entry>
+
<entry><literal>MYSQL_TYPE_FLOAT</literal></entry>
<entry><literal>FLOAT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DOUBLE</literal></entry>
+
<entry><literal>MYSQL_TYPE_DOUBLE</literal></entry>
<entry><literal>DOUBLE</literal> or
<literal>REAL</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TIMESTAMP</literal></entry>
+
<entry><literal>MYSQL_TYPE_TIMESTAMP</literal></entry>
<entry><literal>TIMESTAMP</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DATE</literal></entry>
+
<entry><literal>MYSQL_TYPE_DATE</literal></entry>
<entry><literal>DATE</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TIME</literal></entry>
+
<entry><literal>MYSQL_TYPE_TIME</literal></entry>
<entry><literal>TIME</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DATETIME</literal></entry>
+
<entry><literal>MYSQL_TYPE_DATETIME</literal></entry>
<entry><literal>DATETIME</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_YEAR</literal></entry>
+
<entry><literal>MYSQL_TYPE_YEAR</literal></entry>
<entry><literal>YEAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_STRING</literal></entry>
+
<entry><literal>MYSQL_TYPE_STRING</literal></entry>
<entry><literal>CHAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_VAR_STRING</literal></entry>
+
<entry><literal>MYSQL_TYPE_VAR_STRING</literal></entry>
<entry><literal>VARCHAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_BLOB</literal></entry>
+
<entry><literal>MYSQL_TYPE_BLOB</literal></entry>
<entry><literal>BLOB</literal> or
<literal>TEXT</literal> field (use
<literal>max_length</literal> to determine the
maximum length)</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_SET</literal></entry>
+
<entry><literal>MYSQL_TYPE_SET</literal></entry>
<entry><literal>SET</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_ENUM</literal></entry>
+
<entry><literal>MYSQL_TYPE_ENUM</literal></entry>
<entry><literal>ENUM</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_NULL</literal></entry>
+
<entry><literal>MYSQL_TYPE_NULL</literal></entry>
<entry><literal>NULL</literal>-type
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_CHAR</literal></entry>
- <entry>Deprecated; use
<literal>FIELD_TYPE_TINY</literal> instead</entry>
+
<entry><literal>MYSQL_TYPE_CHAR</literal></entry>
+ <entry>Deprecated; use
<literal>MYSQL_TYPE_TINY</literal> instead</entry>
</row>
</tbody>
</tgroup>
@@ -823,10 +827,10 @@
because they indicate the type of a field rather than an
attribute of its type. It is preferable to test
<literal>field->type</literal> against
- <literal>FIELD_TYPE_BLOB</literal>,
- <literal>FIELD_TYPE_ENUM</literal>,
- <literal>FIELD_TYPE_SET</literal>, or
- <literal>FIELD_TYPE_TIMESTAMP</literal> instead.
+ <literal>MYSQL_TYPE_BLOB</literal>,
+ <literal>MYSQL_TYPE_ENUM</literal>,
+ <literal>MYSQL_TYPE_SET</literal>, or
+ <literal>MYSQL_TYPE_TIMESTAMP</literal> instead.
</para>
<para>
--- 1.15/refman-5.0/mysql-apis.xml 2005-07-19 21:58:17 -05:00
+++ 1.16/refman-5.0/mysql-apis.xml 2005-07-20 16:59:38 -05:00
@@ -602,7 +602,8 @@
<para>
The type of the field. The <literal>type</literal> value may
- be one of the following:
+ be one of the <literal>MYSQL_TYPE_</literal> symbols shown
+ in the following table.
</para>
<informaltable>
@@ -615,86 +616,91 @@
<entry><emphasis role="bold">Type
Description</emphasis></entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TINY</literal></entry>
+
<entry><literal>MYSQL_TYPE_TINY</literal></entry>
<entry><literal>TINYINT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_SHORT</literal></entry>
+
<entry><literal>MYSQL_TYPE_SHORT</literal></entry>
<entry><literal>SMALLINT</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_LONG</literal></entry>
+
<entry><literal>MYSQL_TYPE_LONG</literal></entry>
<entry><literal>INTEGER</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_INT24</literal></entry>
+
<entry><literal>MYSQL_TYPE_INT24</literal></entry>
<entry><literal>MEDIUMINT</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_LONGLONG</literal></entry>
+
<entry><literal>MYSQL_TYPE_LONGLONG</literal></entry>
<entry><literal>BIGINT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DECIMAL</literal></entry>
+
<entry><literal>MYSQL_TYPE_DECIMAL</literal></entry>
<entry><literal>DECIMAL</literal> or
<literal>NUMERIC</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_FLOAT</literal></entry>
+
<entry><literal>MYSQL_TYPE_NEWDECIMAL</literal></entry>
+ <entry>Precision math <literal>DECIMAL</literal> or
<literal>NUMERIC</literal>
+ field (MySQL 5.0.3 and up)</entry>
+ </row>
+ <row>
+
<entry><literal>MYSQL_TYPE_FLOAT</literal></entry>
<entry><literal>FLOAT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DOUBLE</literal></entry>
+
<entry><literal>MYSQL_TYPE_DOUBLE</literal></entry>
<entry><literal>DOUBLE</literal> or
<literal>REAL</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TIMESTAMP</literal></entry>
+
<entry><literal>MYSQL_TYPE_TIMESTAMP</literal></entry>
<entry><literal>TIMESTAMP</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DATE</literal></entry>
+
<entry><literal>MYSQL_TYPE_DATE</literal></entry>
<entry><literal>DATE</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TIME</literal></entry>
+
<entry><literal>MYSQL_TYPE_TIME</literal></entry>
<entry><literal>TIME</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DATETIME</literal></entry>
+
<entry><literal>MYSQL_TYPE_DATETIME</literal></entry>
<entry><literal>DATETIME</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_YEAR</literal></entry>
+
<entry><literal>MYSQL_TYPE_YEAR</literal></entry>
<entry><literal>YEAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_STRING</literal></entry>
+
<entry><literal>MYSQL_TYPE_STRING</literal></entry>
<entry><literal>CHAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_VAR_STRING</literal></entry>
+
<entry><literal>MYSQL_TYPE_VAR_STRING</literal></entry>
<entry><literal>VARCHAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_BLOB</literal></entry>
+
<entry><literal>MYSQL_TYPE_BLOB</literal></entry>
<entry><literal>BLOB</literal> or
<literal>TEXT</literal> field (use
<literal>max_length</literal> to determine the
maximum length)</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_SET</literal></entry>
+
<entry><literal>MYSQL_TYPE_SET</literal></entry>
<entry><literal>SET</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_ENUM</literal></entry>
+
<entry><literal>MYSQL_TYPE_ENUM</literal></entry>
<entry><literal>ENUM</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_NULL</literal></entry>
+
<entry><literal>MYSQL_TYPE_NULL</literal></entry>
<entry><literal>NULL</literal>-type
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_CHAR</literal></entry>
- <entry>Deprecated; use
<literal>FIELD_TYPE_TINY</literal> instead</entry>
+
<entry><literal>MYSQL_TYPE_CHAR</literal></entry>
+ <entry>Deprecated; use
<literal>MYSQL_TYPE_TINY</literal> instead</entry>
</row>
</tbody>
</tgroup>
@@ -823,10 +829,10 @@
because they indicate the type of a field rather than an
attribute of its type. It is preferable to test
<literal>field->type</literal> against
- <literal>FIELD_TYPE_BLOB</literal>,
- <literal>FIELD_TYPE_ENUM</literal>,
- <literal>FIELD_TYPE_SET</literal>, or
- <literal>FIELD_TYPE_TIMESTAMP</literal> instead.
+ <literal>MYSQL_TYPE_BLOB</literal>,
+ <literal>MYSQL_TYPE_ENUM</literal>,
+ <literal>MYSQL_TYPE_SET</literal>, or
+ <literal>MYSQL_TYPE_TIMESTAMP</literal> instead.
</para>
<para>
--- 1.31/refman-5.0/mysql-database-administration.xml 2005-07-19 21:54:55 -05:00
+++ 1.32/refman-5.0/mysql-database-administration.xml 2005-07-20 16:59:39 -05:00
@@ -4877,6 +4877,7 @@
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
+| div_precision_increment | 4
|
| expire_logs_days | 0
|
| flush | OFF
|
| flush_time | 0
|
@@ -5866,6 +5867,41 @@
<listitem>
<para>
+ <literal>div_precision_increment</literal>
+ </para>
+
+ <para>
+ This variable indicates the number of digits of precision by
+ which to increase the result of division operations
+ performed with the <literal>/</literal> operator. The
+ default value is 4. The minimum and maximum values are 0 and
+ 30, respectively. The following example illustrates the
+ effect of increasing the default value.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 1/7;</userinput>
++--------+
+| 1/7 |
++--------+
+| 0.1429 |
++--------+
+mysql> <userinput>SET div_precision_increment = 12;</userinput>
+mysql> <userinput>SELECT 1/7;</userinput>
++----------------+
+| 1/7 |
++----------------+
+| 0.142857142857 |
++----------------+
+</programlisting>
+
+ <para>
+ This variable was added in MySQL 5.0.6.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>expire_logs_days</literal>
</para>
@@ -8348,6 +8384,11 @@
<entry><literal>delayed_queue_size</literal></entry>
<entry>numeric</entry>
<entry><literal>GLOBAL</literal></entry>
+ </row>
+ <row>
+
<entry><literal>div_precision_increment</literal></entry>
+ <entry>numeric</entry>
+ <entry><literal>GLOBAL</literal> |
<literal>SESSION</literal></entry>
</row>
<row>
<entry><literal>error_count</literal></entry>
--- 1.73/refman-5.0/news.xml 2005-07-20 12:12:42 -05:00
+++ 1.74/refman-5.0/news.xml 2005-07-20 16:59:39 -05:00
@@ -2159,6 +2159,15 @@
<listitem>
<para>
+ Added the <literal>div_precision_increment</literal> system
+ variable, which indicates the number of digits of precision
+ by which to increase the result of division operations
+ performed with the <literal>/</literal> operator.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Added the <literal>log_bin_trust_routine_creators</literal>
system variable, which applies when binary logging is
enabled. It controls whether stored routine creators can be
--- 1.15/refman/mysql-apis.xml 2005-07-19 21:58:18 -05:00
+++ 1.16/refman/mysql-apis.xml 2005-07-20 16:59:39 -05:00
@@ -602,7 +602,11 @@
<para>
The type of the field. The <literal>type</literal> value may
- be one of the following:
+ be one of the <literal>MYSQL_TYPE_</literal> symbols shown
+ in the following table. Before MySQL 4.1, the symbol names
+ begin with <literal>FIELD_TYPE_</literal> rather than
+ <literal>MYSQL_TYPE_</literal>. The older types still are
+ recognized for backward compatibility.
</para>
<informaltable>
@@ -615,86 +619,91 @@
<entry><emphasis role="bold">Type
Description</emphasis></entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TINY</literal></entry>
+
<entry><literal>MYSQL_TYPE_TINY</literal></entry>
<entry><literal>TINYINT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_SHORT</literal></entry>
+
<entry><literal>MYSQL_TYPE_SHORT</literal></entry>
<entry><literal>SMALLINT</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_LONG</literal></entry>
+
<entry><literal>MYSQL_TYPE_LONG</literal></entry>
<entry><literal>INTEGER</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_INT24</literal></entry>
+
<entry><literal>MYSQL_TYPE_INT24</literal></entry>
<entry><literal>MEDIUMINT</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_LONGLONG</literal></entry>
+
<entry><literal>MYSQL_TYPE_LONGLONG</literal></entry>
<entry><literal>BIGINT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DECIMAL</literal></entry>
+
<entry><literal>MYSQL_TYPE_DECIMAL</literal></entry>
<entry><literal>DECIMAL</literal> or
<literal>NUMERIC</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_FLOAT</literal></entry>
+
<entry><literal>MYSQL_TYPE_NEWDECIMAL</literal></entry>
+ <entry>Precision math <literal>DECIMAL</literal> or
<literal>NUMERIC</literal>
+ field (MySQL 5.0.3 and up)</entry>
+ </row>
+ <row>
+
<entry><literal>MYSQL_TYPE_FLOAT</literal></entry>
<entry><literal>FLOAT</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DOUBLE</literal></entry>
+
<entry><literal>MYSQL_TYPE_DOUBLE</literal></entry>
<entry><literal>DOUBLE</literal> or
<literal>REAL</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TIMESTAMP</literal></entry>
+
<entry><literal>MYSQL_TYPE_TIMESTAMP</literal></entry>
<entry><literal>TIMESTAMP</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DATE</literal></entry>
+
<entry><literal>MYSQL_TYPE_DATE</literal></entry>
<entry><literal>DATE</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_TIME</literal></entry>
+
<entry><literal>MYSQL_TYPE_TIME</literal></entry>
<entry><literal>TIME</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_DATETIME</literal></entry>
+
<entry><literal>MYSQL_TYPE_DATETIME</literal></entry>
<entry><literal>DATETIME</literal>
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_YEAR</literal></entry>
+
<entry><literal>MYSQL_TYPE_YEAR</literal></entry>
<entry><literal>YEAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_STRING</literal></entry>
+
<entry><literal>MYSQL_TYPE_STRING</literal></entry>
<entry><literal>CHAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_VAR_STRING</literal></entry>
+
<entry><literal>MYSQL_TYPE_VAR_STRING</literal></entry>
<entry><literal>VARCHAR</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_BLOB</literal></entry>
+
<entry><literal>MYSQL_TYPE_BLOB</literal></entry>
<entry><literal>BLOB</literal> or
<literal>TEXT</literal> field (use
<literal>max_length</literal> to determine the
maximum length)</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_SET</literal></entry>
+
<entry><literal>MYSQL_TYPE_SET</literal></entry>
<entry><literal>SET</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_ENUM</literal></entry>
+
<entry><literal>MYSQL_TYPE_ENUM</literal></entry>
<entry><literal>ENUM</literal> field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_NULL</literal></entry>
+
<entry><literal>MYSQL_TYPE_NULL</literal></entry>
<entry><literal>NULL</literal>-type
field</entry>
</row>
<row>
-
<entry><literal>FIELD_TYPE_CHAR</literal></entry>
- <entry>Deprecated; use
<literal>FIELD_TYPE_TINY</literal> instead</entry>
+
<entry><literal>MYSQL_TYPE_CHAR</literal></entry>
+ <entry>Deprecated; use
<literal>MYSQL_TYPE_TINY</literal> instead</entry>
</row>
</tbody>
</tgroup>
@@ -823,10 +832,10 @@
because they indicate the type of a field rather than an
attribute of its type. It is preferable to test
<literal>field->type</literal> against
- <literal>FIELD_TYPE_BLOB</literal>,
- <literal>FIELD_TYPE_ENUM</literal>,
- <literal>FIELD_TYPE_SET</literal>, or
- <literal>FIELD_TYPE_TIMESTAMP</literal> instead.
+ <literal>MYSQL_TYPE_BLOB</literal>,
+ <literal>MYSQL_TYPE_ENUM</literal>,
+ <literal>MYSQL_TYPE_SET</literal>, or
+ <literal>MYSQL_TYPE_TIMESTAMP</literal> instead.
</para>
<para>
--- 1.29/refman/mysql-database-administration.xml 2005-07-19 21:54:56 -05:00
+++ 1.30/refman/mysql-database-administration.xml 2005-07-20 16:59:40 -05:00
@@ -5058,6 +5058,7 @@
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
+| div_precision_increment | 4
|
| expire_logs_days | 0
|
| flush | OFF
|
| flush_time | 1800
|
@@ -6086,6 +6087,41 @@
<listitem>
<para>
+ <literal>div_precision_increment</literal>
+ </para>
+
+ <para>
+ This variable indicates the number of digits of precision by
+ which to increase the result of division operations
+ performed with the <literal>/</literal> operator. The
+ default value is 4. The minimum and maximum values are 0 and
+ 30, respectively. The following example illustrates the
+ effect of increasing the default value.
+ </para>
+
+<programlisting>
+mysql> <userinput>SELECT 1/7;</userinput>
++--------+
+| 1/7 |
++--------+
+| 0.1429 |
++--------+
+mysql> <userinput>SET div_precision_increment = 12;</userinput>
+mysql> <userinput>SELECT 1/7;</userinput>
++----------------+
+| 1/7 |
++----------------+
+| 0.142857142857 |
++----------------+
+</programlisting>
+
+ <para>
+ This variable was added in MySQL 5.0.6.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>expire_logs_days</literal>
</para>
@@ -8687,6 +8723,11 @@
<entry><literal>delayed_queue_size</literal></entry>
<entry>numeric</entry>
<entry><literal>GLOBAL</literal></entry>
+ </row>
+ <row>
+
<entry><literal>div_precision_increment</literal></entry>
+ <entry>numeric</entry>
+ <entry><literal>GLOBAL</literal> |
<literal>SESSION</literal></entry>
</row>
<row>
<entry><literal>error_count</literal></entry>
--- 1.87/refman/news.xml 2005-07-20 12:12:42 -05:00
+++ 1.88/refman/news.xml 2005-07-20 16:59:40 -05:00
@@ -2153,6 +2153,15 @@
<listitem>
<para>
+ Added the <literal>div_precision_increment</literal> system
+ variable, which indicates the number of digits of precision
+ by which to increase the result of division operations
+ performed with the <literal>/</literal> operator.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Added the <literal>log_bin_trust_routine_creators</literal>
system variable, which applies when binary logging is
enabled. It controls whether stored routine creators can be
| Thread |
|---|
| • bk commit - mysqldoc@docsrva tree (paul:1.3093) | paul | 21 Jul |