svn commit - mysqldoc@docsrva: r2214 - in trunk: . refman-common tools

[paul]

Author: paul
Date: 2006-05-26 19:26:25 +0200 (Fri, 26 May 2006)
New Revision: 2214

Log:
 r10068@polar:  paul | 2006-05-26 12:18:47 -0500
 Document bugfixes:
 Bug#16986
 Bug#18681
 Bug#19077
 Bug#19573
 Bug#20048
 Tweak detagging script.


Modified:
   trunk/
   trunk/refman-common/news-5.0.xml
   trunk/refman-common/news-5.1.xml
   trunk/tools/detag.pl


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:10054
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10755
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:7517
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:10068
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10755
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:7517

Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml	2006-05-26 16:27:19 UTC (rev 2213)
+++ trunk/refman-common/news-5.0.xml	2006-05-26 17:26:25 UTC (rev 2214)
@@ -412,6 +412,62 @@
 
       <listitem>
         <para>
+          Premature optimization of nested subqueries in the
+          <literal>FROM</literal> clause that refer to aggregate
+          functions could lead to incorrect results. (Bug #19077)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          A view definition that referred to an alias in the
+          <literal>HAVING</literal> clause could be saved in the
+          <filename>.frm</filename> file with the alias replaced by the
+          expression that it referred to, causing failure of subsequent
+          <literal>SELECT * FROM
+          <replaceable>view_name</replaceable></literal> statements.
+          (Bug #19573)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Several aspects of view privileges were being checked
+          incorrectly. (Bug #18681)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          A view with a non-existent account in the
+          <literal>DEFINER</literal> clause caused <literal>SHOW CREATE
+          VIEW</literal> to fail. Now <literal>SHOW CREATE
+          VIEW</literal> issues a warning instead. (Bug #20048)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          A bug in NTPL threads on Linux could result in a deadlock with
+          <literal>FLUSH TABLES WITH READ LOCK</literal> under some
+          conditions. (Bug #20048)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>MyISAM</literal> table deadlock was possible if one
+          thread issued a <literal>LOCK TABLES</literal> request for
+          write locks and then an administrative statement such as
+          <literal>OPTIMIZE TABLE</literal>, if between the two
+          statements another client meanwhile issued a multiple-table
+          <literal>SELECT</literal> for some of the locked tables. (Bug
+          #16986)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Subqueries that produced a <literal>BIGINT UNSIGNED</literal>
           value were being treated as returning a signed value. (Bug
           #19700)

Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml	2006-05-26 16:27:19 UTC (rev 2213)
+++ trunk/refman-common/news-5.1.xml	2006-05-26 17:26:25 UTC (rev 2214)
@@ -241,6 +241,14 @@
 
       <listitem>
         <para>
+          Premature optimization of nested subqueries in the
+          <literal>FROM</literal> clause that refer to aggregate
+          functions could lead to incorrect results. (Bug #19077)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           For dates with 4-digit year parts less than 200, an implicit
           conversion to add a century was applied for date arithmetic
           performed with <literal>DATE_ADD()</literal>,
@@ -871,6 +879,38 @@
 
       <listitem>
         <para>
+          A view definition that referred to an alias in the
+          <literal>HAVING</literal> clause could be saved in the
+          <filename>.frm</filename> file with the alias replaced by the
+          expression that it referred to, causing failure of subsequent
+          <literal>SELECT * FROM
+          <replaceable>view_name</replaceable></literal> statements.
+          (Bug #19573)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          A bug in NTPL threads on Linux could result in a deadlock with
+          <literal>FLUSH TABLES WITH READ LOCK</literal> under some
+          conditions. (Bug #20048)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>MyISAM</literal> table deadlock was possible if one
+          thread issued a <literal>LOCK TABLES</literal> request for
+          write locks and then an administrative statement such as
+          <literal>OPTIMIZE TABLE</literal>, if between the two
+          statements another client meanwhile issued a multiple-table
+          <literal>SELECT</literal> for some of the locked tables. (Bug
+          #16986)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           The patch for Bug #17164 introduced the problem that some
           outer joins were incorrectly converted to inner joins. (Bug
           #19816)

Modified: trunk/tools/detag.pl
===================================================================
--- trunk/tools/detag.pl	2006-05-26 16:27:19 UTC (rev 2213)
+++ trunk/tools/detag.pl	2006-05-26 17:26:25 UTC (rev 2214)
@@ -20,6 +20,6 @@
 
 my $hs = HTML::Strip->new (emit_spaces => 0);
 $_ = $hs->parse ($_);
-s/\n +/ /g;
+s/\s+/ /g;
 s/^ +//g;
-print wrap ("", "", $_);
+print wrap ("", "", $_), "\n";