Author: paul
Date: 2006-09-26 22:11:34 +0200 (Tue, 26 Sep 2006)
New Revision: 3468
Log:
r14062@polar: paul | 2006-09-26 15:12:28 -0500
Document bugfixes:
Bug#18875
Bug#21555
Modified:
trunk/refman-4.1/news-4.1.xml
trunk/refman-5.0/news-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:14061
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8616
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:14062
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:8616
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/news-4.1.xml
===================================================================
--- trunk/refman-4.1/news-4.1.xml 2006-09-26 20:11:14 UTC (rev 3467)
+++ trunk/refman-4.1/news-4.1.xml 2006-09-26 20:11:34 UTC (rev 3468)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 780 bytes
@@ -209,6 +209,16 @@
<listitem>
<para>
+ For <literal>INSERT ... ON DUPLICATE KEY UPDATE</literal>, use
+ of
+ <literal>VALUES(<replaceable>col_name</replaceable>)</literal>
+ within the <literal>UPDATE</literal> clause sometimes was
+ handled incorrectly. (Bug #21555)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Table aliases in multiple-table <literal>DELETE</literal>
statements sometimes were not resolved. (Bug #21392)
</para>
Modified: trunk/refman-5.0/news-5.0.xml
===================================================================
--- trunk/refman-5.0/news-5.0.xml 2006-09-26 20:11:14 UTC (rev 3467)
+++ trunk/refman-5.0/news-5.0.xml 2006-09-26 20:11:34 UTC (rev 3468)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 847 bytes
@@ -238,6 +238,16 @@
<listitem>
<para>
+ For <literal>INSERT ... ON DUPLICATE KEY UPDATE</literal>, use
+ of
+ <literal>VALUES(<replaceable>col_name</replaceable>)</literal>
+ within the <literal>UPDATE</literal> clause sometimes was
+ handled incorrectly. (Bug #21555)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Row equalities (such as <literal>WHERE (a,b) = (c,d)</literal>
were not taken into account by the optimizer, resulting in
slow query execution. Now they are treated as conjunctions of
Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml 2006-09-26 20:11:14 UTC (rev 3467)
+++ trunk/refman-5.1/news-5.1.xml 2006-09-26 20:11:34 UTC (rev 3468)
Changed blocks: 2, Lines Added: 20, Lines Deleted: 0; 1276 bytes
@@ -652,6 +652,16 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ The default value of the <literal>tmp_table_size</literal>
+ system variable was lowered from 32MB to 16MB because it is
+ bounded by the value of
+ <literal>max_heap_table_size</literal>, which has a default of
+ 16MB. (Bug #18875)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -728,6 +738,16 @@
<listitem>
<para>
+ For <literal>INSERT ... ON DUPLICATE KEY UPDATE</literal>, use
+ of
+ <literal>VALUES(<replaceable>col_name</replaceable>)</literal>
+ within the <literal>UPDATE</literal> clause sometimes was
+ handled incorrectly. (Bug #21555)
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
Row equalities (such as <literal>WHERE (a,b) = (c,d)</literal>
were not taken into account by the optimizer, resulting in
slow query execution. Now they are treated as conjunctions of
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3468 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 26 Sep |
