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

[paul]

Author: paul
Date: 2006-05-15 21:44:34 +0200 (Mon, 15 May 2006)
New Revision: 2097

Log:
 r10434@frost:  paul | 2006-05-15 14:44:08 -0500
 Documented bugfixes:
 Bug#10418
 Bug#17048
 Bug#19396
 Bug#19490
 Bug#19564


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


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7488
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10388
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:7488
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:10434
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4886

Modified: trunk/refman-common/news-4.1.xml
===================================================================
--- trunk/refman-common/news-4.1.xml	2006-05-15 15:56:18 UTC (rev 2096)
+++ trunk/refman-common/news-4.1.xml	2006-05-15 19:44:34 UTC (rev 2097)
@@ -199,6 +199,14 @@
 
       <listitem>
         <para>
+          <literal>LOAD_FILE()</literal> returned an error if the file
+          did not exist, rather than <literal>NULL</literal> as it
+          should according to the manual. (Bug #10418)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Use of uninitialized user variables in a subquery in the
           <literal>FROM</literal> clause results in bad entries in the
           binary log. (Bug #19136)

Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml	2006-05-15 15:56:18 UTC (rev 2096)
+++ trunk/refman-common/news-5.0.xml	2006-05-15 19:44:34 UTC (rev 2097)
@@ -261,18 +261,52 @@
     </para>
 
     <itemizedlist>
-      
+
       <listitem>
         <para>
           <literal>NDB Cluster</literal>:
<literal>TRUNCATE</literal>
           failed on tables having <literal>BLOB</literal> or
           <literal>TEXT</literal> columns with the error
<errortext>Lock
-            wait timeout exceeded</errortext>. (Bug #19201) 
+          wait timeout exceeded</errortext>. (Bug #19201)
         </para>
       </listitem>
 
       <listitem>
         <para>
+          Selecting from a view that used <literal>GROUP BY</literal> on
+          a non-constant temporal interval (such as
+          <literal>DATE(<replaceable>col</replaceable>) + INTERVAL
+          TIME_TO_SEC(<replaceable>col</replaceable>) SECOND</literal>
+          could cause a server crash. (Bug #19490)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          An outer join of two views that was written using <literal>{
+          OJ ... }</literal> syntax could cause a server crash. (Bug
+          #19396)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>LOAD_FILE()</literal> returned an error if the file
+          did not exist, rather than <literal>NULL</literal> as it
+          should according to the manual. (Bug #10418)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          For certain <literal>CREATE TABLE ... SELECT</literal>
+          statements, the selected values were truncated when inserted
+          into the new table. (Bug #17048)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Use of uninitialized user variables in a subquery in the
           <literal>FROM</literal> clause results in bad entries in the
           binary log. (Bug #19136)
@@ -315,7 +349,7 @@
       <listitem>
         <para>
           <command>mysql</command> displayed
<literal>NULL</literal> for
-          strings that are empty or contain only spaces. (Bug #16372)
+          strings that are empty or contain only spaces. (Bug #19564)
         </para>
       </listitem>
 

Modified: trunk/refman-common/news-5.1.xml
===================================================================
--- trunk/refman-common/news-5.1.xml	2006-05-15 15:56:18 UTC (rev 2096)
+++ trunk/refman-common/news-5.1.xml	2006-05-15 19:44:34 UTC (rev 2097)
@@ -89,14 +89,14 @@
     </para>
 
     <itemizedlist>
-      
+
       <listitem>
         <para>
           <literal>NDB Cluster</literal>:
<literal>TRUNCATE</literal>
           failed on tables having <literal>BLOB</literal> or
           <literal>TEXT</literal> columns with the error
<errortext>Lock
-            wait timeout exceeded</errortext>. This affected both
-          in-memory and Disk Data tables. (Bug #19201) 
+          wait timeout exceeded</errortext>. This affected both
+          in-memory and Disk Data tables. (Bug #19201)
         </para>
       </listitem>
 
@@ -117,13 +117,6 @@
 
       <listitem>
         <para>
-          <command>mysql</command> displayed
<literal>NULL</literal> for
-          strings that are empty or contain only spaces. (Bug #16372)
-        </para>
-      </listitem>
-
-      <listitem>
-        <para>
           Concurrent reading and writing of privilege structures could
           crash the server. (Bug #16372)
         </para>
@@ -398,7 +391,7 @@
           (Bug #17667)
         </para>
       </listitem>
-      
+
       <listitem>
         <para>
           <literal>NDB Cluster</literal>:
<command>mysqld</command>
@@ -417,6 +410,31 @@
 
       <listitem>
         <para>
+          Selecting from a view that used <literal>GROUP BY</literal> on
+          a non-constant temporal interval (such as
+          <literal>DATE(<replaceable>col</replaceable>) + INTERVAL
+          TIME_TO_SEC(<replaceable>col</replaceable>) SECOND</literal>
+          could cause a server crash. (Bug #19490)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          An outer join of two views that was written using <literal>{
+          OJ ... }</literal> syntax could cause a server crash. (Bug
+          #19396)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <command>mysql</command> displayed
<literal>NULL</literal> for
+          strings that are empty or contain only spaces. (Bug #19564)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           A range access optimizer heuristic was invalid, causing some
           queries to be much slower in MySQL 5.0 than in 4.0. (Bug
           #17379, Bug #18940)