From: jon
Date: December 21 2005 12:17pm
Subject: svn commit - mysqldoc@docsrva: r609 - trunk/refman-common
List-Archive: http://lists.mysql.com/commits/315
Message-Id: <200512211217.jBLCHS4b003849@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2005-12-21 13:17:27 +0100 (Wed, 21 Dec 2005)
New Revision: 609

Log:

Documenting bugfixes:
  Bug #14614, Bug #15550, Bug #15772, Bug#14861, Bug #15106, Bug #15602, Bug 
  #15605 (5.0)
  Bug #15268, Bug #12762 (5.0/5.1)
  Bug #15536 (4.1/5.0/5.1)



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

Modified: trunk/refman-common/news-4.1.xml
===================================================================
--- trunk/refman-common/news-4.1.xml	2005-12-20 19:22:30 UTC (rev 608)
+++ trunk/refman-common/news-4.1.xml	2005-12-21 12:17:27 UTC (rev 609)
@@ -179,6 +179,16 @@
     </para>
 
     <itemizedlist>
+      
+      <listitem>
+        <para>
+          <literal>BDB</literal>: A <literal>DELETE</literal>,
+          <literal>INSERT</literal>, or <literal>UPDATE</literal> of a
+          <literal>BDB</literal> table could cause the server to crash
+          where the query contained a subquery using an index read. (Bug
+          #15536)
+        </para>
+      </listitem>
 
       <listitem>
         <para>

Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml	2005-12-20 19:22:30 UTC (rev 608)
+++ trunk/refman-common/news-5.0.xml	2005-12-21 12:17:27 UTC (rev 609)
@@ -205,6 +205,78 @@
     </para>
 
     <itemizedlist>
+      
+      <listitem>
+        <para>
+          Reversing the order of operands in a <literal>WHERE</literal>
+          clause testing a simple equality (such as <literal>WHERE
+            t1.col1 = t2.col2</literal>) would produce different
+          output from <literal>EXPLAIN</literal>. (Bug #15106)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          Column aliases were displayed incorrectly in a
+          <literal>SELECT</literal> from a view following an update to a
+          base table of the view. (Bug #14861) 
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          Set functions could not be aggregated in outer subqueries.
+          (Bug #12762)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          When a connection using yaSSL was aborted, the server would
+          continue to try to read the closed socket, and the thread
+          continued to appear in the output of <literal>SHOW
+            PROCESSLIST</literal>. Note that this issue did not affect
+          secure connection attempts using OpenSSL. (Bug #15772) 
+        </para>
+      </listitem>      
+      
+      <listitem>
+        <para>
+          <literal>InnoDB</literal>: Having two tables in a parent-child
+          relationship enforced by a foreign key where one table used
+          <literal>ROW_FORMAT=COMPACT</literal> and the other used
+          <literal>ROW_FORMAT=REDUNDANT</literal> could result in a
+          MySQL server crash. Note that this problem did not exist prior
+          to MySQL 5.0.3, when the compact row format for
+          <literal>InnoDB</literal> was introduced. (Bug #15550) 
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          <literal>BDB</literal>: A <literal>DELETE</literal>,
+          <literal>INSERT</literal>, or <literal>UPDATE</literal> of a
+          <literal>BDB</literal> table could cause the server to crash
+          where the query contained a subquery using an index read. (Bug
+          #15536)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          A left join on a column that having a <literal>NULL</literal>
+          value could cause the server to crash. (Bug #15268)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          A replication slave server could sometimes crash on a
+          <literal>BEFORE UPDATE</literal> trigger if the
+          <literal>UPDATE</literal> query was not executed in the same
+          database as the table with the trigger. (Bug #14614)
+        </para>
+      </listitem>
 
       <listitem>
         <para>
@@ -330,6 +402,21 @@
     </para>
 
     <itemizedlist>
+      
+      <listitem>
+        <para>
+          A bug in <filename>mysql-test/t/mysqltest.test</filename>
+          caused that test to fail. (Bug #15605)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          The <literal>CREATE</literal> test case in
+          <command>mysql-test-run.pl</command> failed on AIX and SCO.
+          (Bug #15607)
+        </para>
+      </listitem>
 
       <listitem>
         <para>

Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml	2005-12-20 19:22:30 UTC (rev 608)
+++ trunk/refman-common/news-5.1.xml	2005-12-21 12:17:27 UTC (rev 609)
@@ -89,6 +89,23 @@
     </para>
 
     <itemizedlist>
+      
+      <listitem>
+        <para>
+          <literal>BDB</literal>: A <literal>DELETE</literal>,
+          <literal>INSERT</literal>, or <literal>UPDATE</literal> of a
+          <literal>BDB</literal> table could cause the server to crash
+          where the query contained a subquery using an index read. (Bug
+          #15536)
+        </para>
+      </listitem>
+      
+      <listitem>
+        <para>
+          A left join on a column that having a <literal>NULL</literal>
+          value could cause the server to crash. (Bug #15268)
+        </para>
+      </listitem>
 
       <listitem>
         <para>
@@ -442,7 +459,23 @@
       </listitem>
 
     </itemizedlist>
-
+    
+    <para>
+      Bugs fixed:
+    </para>
+    
+    <itemizedlist>
+      
+      <listitem>
+        <para>
+          Set functions could not be aggregated in outer subqueries.
+          (Bug #12762)
+        </para>
+      </listitem>
+      
+    </itemizedlist>
+    
+    
   </section>
 
   <section id="news-5-1-2">