Author: paul
Date: 2007-05-10 20:12:28 +0200 (Thu, 10 May 2007)
New Revision: 6425
Log:
r24787@polar: paul | 2007-05-10 13:09:51 -0500
Document bugfixes:
Bug#27670
Bug#27807
Bug#27954
Bug#28133
Bug#28181
Bug#28188
Modified:
trunk/refman-4.1/news-4.1.xml
trunk/refman-5.0/releasenotes-es-5.0.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:24784
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:20228
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:17229
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:24787
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:20228
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:17229
Modified: trunk/refman-4.1/news-4.1.xml
===================================================================
--- trunk/refman-4.1/news-4.1.xml 2007-05-10 18:10:39 UTC (rev 6424)
+++ trunk/refman-4.1/news-4.1.xml 2007-05-10 18:12:28 UTC (rev 6425)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 723 bytes
@@ -304,6 +304,14 @@
<listitem>
<para>
+ Using <literal>CAST()</literal> to convert
+ <literal>DATETIME</literal> values to numeric values did not
+ work. (Bug #23656)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Index hints (<literal>USE INDEX</literal>, <literal>IGNORE
INDEX</literal>, <literal>FORCE INDEX</literal>) cannot be
used with <literal>FULLTEXT</literal> indexes, but were not
Modified: trunk/refman-5.0/releasenotes-es-5.0.xml
===================================================================
--- trunk/refman-5.0/releasenotes-es-5.0.xml 2007-05-10 18:10:39 UTC (rev 6424)
+++ trunk/refman-5.0/releasenotes-es-5.0.xml 2007-05-10 18:12:28 UTC (rev 6425)
Changed blocks: 3, Lines Added: 57, Lines Deleted: 0; 2711 bytes
@@ -176,6 +176,32 @@
<listitem>
<para>
+ For <literal>INSERT ... ON DUPLICATE KEY UPDATE</literal>
+ statements that affected many rows, updates could be applied
+ to the wrong rows. (Bug #27954)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Comparisons of <literal>DATE</literal> or
+ <literal>DATETIME</literal> values for the
+ <literal>IN()</literal> function could yield incorrect
+ results. (Bug #28133)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>LOAD DATA</literal> did not use
+ <literal>CURRENT_TIMESTAMP</literal> as the default value for
+ a <literal>TIMESTAMP</literal> column for which no value was
+ provided. (Bug #27670)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
On Windows, connection handlers did not properly decrement the
server's thread count when exiting. (Bug #25621)
</para>
@@ -199,6 +225,14 @@
<listitem>
<para>
+ Using <literal>CAST()</literal> to convert
+ <literal>DATETIME</literal> values to numeric values did not
+ work. (Bug #23656)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Early <literal>NULL</literal>-filtering optimization did not
work for <literal>eq_ref</literal> table access. (Bug #27939)
</para>
@@ -278,6 +312,29 @@
<listitem>
<para>
+ A performance degradation was observed for outer join queries
+ to which a not-exists optimization was applied. (Bug #28188)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>SELECT * INTO OUTFILE ... FROM
+ INFORMATION_SCHEMA.schemata</literal> failed with an
+ <literal>Access denied</literal> error, even for a user who
+ has the <literal>FILE</literal> privilege. (Bug #28181)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Certain queries that used uncorrelated scalar subqueries
+ caused <literal>EXPLAIN</literal> to to crash. (Bug #27807)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>INSERT...ON DUPLICATE KEY UPDATE</literal> could
cause <literal>Error 1032: Can't find record in ...</literal>
for inserts into an <literal>InnoDB</literal> table unique
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2007-05-10 18:10:39 UTC (rev 6424)
+++ trunk/refman-5.1/news-5.1.xml 2007-05-10 18:12:28 UTC (rev 6425)
Changed blocks: 1, Lines Added: 74, Lines Deleted: 0; 2692 bytes
@@ -30,6 +30,80 @@
<filename>refman-common</filename> directory.
</remark>
+ <section id="news-5-1-19">
+
+ <title>Changes in release 5.1.19 (Not yet released)</title>
+
+ <para role="release-level">
+ This is a new Beta development release, fixing recently discovered
+ bugs.
+ </para>
+
+ <para role="release-non-production">
+ <emphasis role="bold">NOTE:</emphasis> This Beta release, as any
+ other pre-production release, should not be installed on
+ <emphasis>production</emphasis> level systems or systems with
+ critical data. It is good practice to back up your data before
+ installing any new version of software. Although MySQL has worked
+ very hard to ensure a high level of quality, protect your data by
+ making a backup as you would for any software beta release. Please
+ refer to our bug database at <ulink url="http://bugs.mysql.com/"/>
+ for more details about the individual bugs fixed in this version.
+ </para>
+
+ <para>
+ This section documents all changes and bug fixes that have been
+ applied since the last official MySQL release. If you would like
+ to receive more fine-grained and personalized <emphasis>update
+ alerts</emphasis> about fixes that are relevant to the version and
+ features you use, please consider subscribing to <emphasis>MySQL
+ Network</emphasis> (a commercial MySQL offering). For more details
+ please see
+ <ulink url="http://www.mysql.com/network/advisors.html"/>.
+ </para>
+
+<!--
+ <para>
+ Functionality added or changed:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para></para>
+ </listitem>
+
+ </itemizedlist>
+-->
+
+ <para>
+ Bugs fixed:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ Comparisons of <literal>DATE</literal> or
+ <literal>DATETIME</literal> values for the
+ <literal>IN()</literal> function could yield incorrect
+ results. (Bug #28133)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>LOAD DATA</literal> did not use
+ <literal>CURRENT_TIMESTAMP</literal> as the default value for
+ a <literal>TIMESTAMP</literal> column for which no value was
+ provided. (Bug #27670)
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </section>
+
<section id="news-5-1-18">
<title>Changes in release 5.1.18 (Not yet released)</title>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r6425 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 10 May |
