List:Internals« Previous MessageNext Message »
From:paul Date:July 20 2005 11:59pm
Subject:bk commit - mysqldoc@docsrva tree (paul:1.3093)
View as plain text  
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-&gt;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-&gt;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&gt; <userinput>SELECT 1/7;</userinput>
++--------+
+| 1/7    |
++--------+
+| 0.1429 |
++--------+
+mysql&gt; <userinput>SET div_precision_increment = 12;</userinput>
+mysql&gt; <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-&gt;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&gt; <userinput>SELECT 1/7;</userinput>
++--------+
+| 1/7    |
++--------+
+| 0.1429 |
++--------+
+mysql&gt; <userinput>SET div_precision_increment = 12;</userinput>
+mysql&gt; <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)paul21 Jul