MySQL Lists: commits: svn commit - mysqldoc@docsrva: r3562 - in trunk: . refman-4.1 refman-5.0 refman-5.1

List:	Commits	« Previous Message Next Message »
From:	paul	Date:	October 6 2006 5:19am
Subject:	svn commit - mysqldoc@docsrva: r3562 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text
Author: paul
Date: 2006-10-06 05:19:54 +0200 (Fri, 06 Oct 2006)
New Revision: 3562

Log:
 r10719@frost:  paul | 2006-10-05 22:18:40 -0500
 Document bugfixes:
 Bug#5505
 Bug#19960
 Bug#20305
 Bug#20877
 Bug#21081
 Bug#21449
 Bug#22271


Modified:
   trunk/refman-4.1/data-types.xml
   trunk/refman-4.1/news-4.1.xml
   trunk/refman-5.0/data-types.xml
   trunk/refman-5.0/news-5.0.xml
   trunk/refman-5.1/data-types.xml
   trunk/refman-5.1/news-5.1.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:14265
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:10717
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10466
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:14265
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:10719
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10466


Modified: trunk/refman-4.1/data-types.xml
===================================================================
--- trunk/refman-4.1/data-types.xml	2006-10-06 02:32:11 UTC (rev 3561)
+++ trunk/refman-4.1/data-types.xml	2006-10-06 03:19:54 UTC (rev 3562)
Changed blocks: 2, Lines Added: 2, Lines Deleted: 2; 960 bytes

@@ -629,7 +629,7 @@
           </para>
 
           <para>
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits and <replaceable>D</replaceable> is the number of
             digits following the decimal point. If
             <replaceable>M</replaceable> and

@@ -700,7 +700,7 @@
           </para>
 
           <para>
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits and <replaceable>D</replaceable> is the number of
             digits following the decimal point. If
             <replaceable>M</replaceable> and


Modified: trunk/refman-4.1/news-4.1.xml
===================================================================
--- trunk/refman-4.1/news-4.1.xml	2006-10-06 02:32:11 UTC (rev 3561)
+++ trunk/refman-4.1/news-4.1.xml	2006-10-06 03:19:54 UTC (rev 3562)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 912 bytes

@@ -209,6 +209,17 @@
 
       <listitem>
         <para>
+          <literal>PROCEDURE ANALYSE()</literal> returned incorrect
+          values of <replaceable>M</replaceable>
+          <literal>FLOAT(<replaceable>M</replaceable>,
+          <replaceable>D</replaceable>)</literal> and
+          <literal>DOUBLE(<replaceable>M</replaceable>,
+          <replaceable>D</replaceable>)</literal>. (Bug #20305)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           A query that used <literal>GROUP BY</literal> and an
           <literal>ALL</literal> or <literal>ANY</literal>
quantified
           subquery in a <literal>HAVING</literal> clause could trigger


Modified: trunk/refman-5.0/data-types.xml
===================================================================
--- trunk/refman-5.0/data-types.xml	2006-10-06 02:32:11 UTC (rev 3561)
+++ trunk/refman-5.0/data-types.xml	2006-10-06 03:19:54 UTC (rev 3562)
Changed blocks: 3, Lines Added: 3, Lines Deleted: 3; 1397 bytes

@@ -636,7 +636,7 @@
           </para>
 
           <para>
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits and <replaceable>D</replaceable> is the number of
             digits following the decimal point. If
             <replaceable>M</replaceable> and

@@ -707,7 +707,7 @@
           </para>
 
           <para>
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits and <replaceable>D</replaceable> is the number of
             digits following the decimal point. If
             <replaceable>M</replaceable> and

@@ -847,7 +847,7 @@
 
           <para>
             A packed <quote>exact</quote> fixed-point number.
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits (the precision) and <replaceable>D</replaceable> is
             the number of digits after the decimal point (the scale).
             The decimal point and (for negative numbers) the


Modified: trunk/refman-5.0/news-5.0.xml
===================================================================
--- trunk/refman-5.0/news-5.0.xml	2006-10-06 02:32:11 UTC (rev 3561)
+++ trunk/refman-5.0/news-5.0.xml	2006-10-06 03:19:54 UTC (rev 3562)
Changed blocks: 2, Lines Added: 54, Lines Deleted: 0; 2593 bytes

@@ -209,6 +209,16 @@
 
       <listitem>
         <para>
+          Incorrect results could be obtained from re-execution of a
+          parametrized prepared statement or a stored routine with a
+          <literal>SELECT</literal> that uses <literal>LEFT
+          JOIN</literal> with a second table having only one row. (Bug
+          #21081)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           An <literal>UPDATE</literal> that referred to a key column in
           the <literal>WHERE</literal> clause and activated a trigger
           that modified the column resulted in a loop. (Bug #20670)

@@ -348,6 +358,50 @@
 
       <listitem>
         <para>
+          Conversion of values inserted into a <literal>BIT</literal>
+          column could affect adjacent columns. (Bug #22271)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          The URL into the online manual that is printed in the stack
+          trace message by the server was out of date. (Bug #21449)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>PROCEDURE ANALYSE()</literal> returned incorrect
+          values of <replaceable>M</replaceable>
+          <literal>FLOAT(<replaceable>M</replaceable>,
+          <replaceable>D</replaceable>)</literal> and
+          <literal>DOUBLE(<replaceable>M</replaceable>,
+          <replaceable>D</replaceable>)</literal>. (Bug #20305)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Join conditions using partial indexes on
+          <literal>utf8</literal> columns of
<literal>InnoDB</literal>
+          tables incorrectly ignored rows where the length of the actual
+          value was greater than the length of the partial index. (Bug
+          #19960)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          On an <literal>INSERT</literal> into an updatable but
+          non-insertable view, an error message was issued stating that
+          the view was not updatable. Now the message says the view is
+          not insertable-into. (Bug #5505)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           <literal>INSERT DELAYED</literal> did not honor <literal>SET
           INSERT_ID</literal> or the
<literal>auto_increment_*</literal>
           system variables. (Bug #20627, Bug# 20830)


Modified: trunk/refman-5.1/data-types.xml
===================================================================
--- trunk/refman-5.1/data-types.xml	2006-10-06 02:32:11 UTC (rev 3561)
+++ trunk/refman-5.1/data-types.xml	2006-10-06 03:19:54 UTC (rev 3562)
Changed blocks: 3, Lines Added: 3, Lines Deleted: 3; 1397 bytes

@@ -628,7 +628,7 @@
           </para>
 
           <para>
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits and <replaceable>D</replaceable> is the number of
             digits following the decimal point. If
             <replaceable>M</replaceable> and

@@ -699,7 +699,7 @@
           </para>
 
           <para>
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits and <replaceable>D</replaceable> is the number of
             digits following the decimal point. If
             <replaceable>M</replaceable> and

@@ -835,7 +835,7 @@
 
           <para>
             A packed <quote>exact</quote> fixed-point number.
-            <replaceable>M</replaceable> is the total number of decimal
+            <replaceable>M</replaceable> is the total number of
             digits (the precision) and <replaceable>D</replaceable> is
             the number of digits after the decimal point (the scale).
             The decimal point and (for negative numbers) the


Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml	2006-10-06 02:32:11 UTC (rev 3561)
+++ trunk/refman-5.1/news-5.1.xml	2006-10-06 03:19:54 UTC (rev 3562)
Changed blocks: 2, Lines Added: 62, Lines Deleted: 0; 2656 bytes

@@ -719,6 +719,14 @@
         </para>
       </listitem>
 
+      <listitem>
+        <para>
+          Memory consumption of the <literal>InnoDB</literal> data
+          dictionary cache was roughly halved by cleaning up the data
+          structures. (Bug #20877)
+        </para>
+      </listitem>
+
     </itemizedlist>
 
     <para>

@@ -795,6 +803,60 @@
 
       <listitem>
         <para>
+          Conversion of values inserted into a <literal>BIT</literal>
+          column could affect adjacent columns. (Bug #22271)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          The URL into the online manual that is printed in the stack
+          trace message by the server was out of date. (Bug #21449)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Incorrect results could be obtained from re-execution of a
+          parametrized prepared statement or a stored routine with a
+          <literal>SELECT</literal> that uses <literal>LEFT
+          JOIN</literal> with a second table having only one row. (Bug
+          #21081)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>PROCEDURE ANALYSE()</literal> returned incorrect
+          values of <replaceable>M</replaceable>
+          <literal>FLOAT(<replaceable>M</replaceable>,
+          <replaceable>D</replaceable>)</literal> and
+          <literal>DOUBLE(<replaceable>M</replaceable>,
+          <replaceable>D</replaceable>)</literal>. (Bug #20305)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Join conditions using partial indexes on
+          <literal>utf8</literal> columns of
<literal>InnoDB</literal>
+          tables incorrectly ignored rows where the length of the actual
+          value was greater than the length of the partial index. (Bug
+          #19960)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          On an <literal>INSERT</literal> into an updatable but
+          non-insertable view, an error message was issued stating that
+          the view was not updatable. Now the message says the view is
+          not insertable-into. (Bug #5505)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           <literal>INSERT DELAYED</literal> did not honor <literal>SET
           INSERT_ID</literal> or the
<literal>auto_increment_*</literal>
           system variables. (Bug #20627, Bug# 20830)
Thread
• svn commit - mysqldoc@docsrva: r3562 - in trunk: . refman-4.1 refman-5.0 refman-5.1	paul	6 Oct