Author: paul
Date: 2009-11-26 17:16:22 +0100 (Thu, 26 Nov 2009)
New Revision: 17845
Log:
r46935@frost: paul | 2009-11-26 10:10:08 -0500
Document bug fixes:
Bug#27525: table not found when using multi-table-deletes with aliases over several databas
Bug#43618: MyISAM&Maria returns wrong results with 'between' on timestamp
Bug#46018: group_concat(distinct ...) uses max_heap_table_size for memory allocations
(Bug#27525 is a 5.6.0 change, it's in the 5.5 manual for now)
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/changelog/mysqld.xml
trunk/refman-5.5/Notes
trunk/refman-5.5/sql-syntax-data-manipulation.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:28120
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:46934
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
+ 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:28120
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:46935
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2009-11-26 16:16:15 UTC (rev 17844)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2009-11-26 16:16:22 UTC (rev 17845)
Changed blocks: 1, Lines Added: 55, Lines Deleted: 0; 1438 bytes
@@ -78525,4 +78525,59 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="GROUP_CONCAT()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="46018"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.14"/>
+ </versions>
+
+ <message>
+
+ <para>
+ For queries that used <literal role="func">GROUP_CONCAT(DISTINCT
+ ...)</literal>, the value of
+ <literal role="sysvar">max_heap_table_size</literal> was used
+ for memory allocation, which could be excessive. Now the minimum
+ of <literal role="sysvar">max_heap_table_size</literal> and
+ <literal role="sysvar">tmp_table_size</literal> is used.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="optimizer"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="43618"/>
+ </bugs>
+
+ <versions>
+ <version ver="6.0.14"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Queries for <literal role="se">MyISAM</literal> tables that were
+ processed using index condition pushdown could return incorrect
+ results.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/dynamic-docs/changelog/mysqld.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld.xml 2009-11-26 16:16:15 UTC (rev 17844)
+++ trunk/dynamic-docs/changelog/mysqld.xml 2009-11-26 16:16:22 UTC (rev 17845)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 400 bytes
@@ -37021,6 +37021,7 @@
</bugs>
<versions>
+ <version ver="5.6.0"/>
<version ver="6.0.5"/>
</versions>
Modified: trunk/refman-5.5/Notes
===================================================================
--- trunk/refman-5.5/Notes 2009-11-26 16:16:15 UTC (rev 17844)
+++ trunk/refman-5.5/Notes 2009-11-26 16:16:22 UTC (rev 17845)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 315 bytes
@@ -54,3 +54,4 @@
#5724 mysqladmin
#10374 GET_LOCK()
#33544 UDF
+#27525 multiple-table DELETE
Modified: trunk/refman-5.5/sql-syntax-data-manipulation.xml
===================================================================
--- trunk/refman-5.5/sql-syntax-data-manipulation.xml 2009-11-26 16:16:15 UTC (rev 17844)
+++ trunk/refman-5.5/sql-syntax-data-manipulation.xml 2009-11-26 16:16:22 UTC (rev 17845)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 0; 780 bytes
@@ -668,6 +668,12 @@
</programlisting>
<para>
+ Before MySQL 5.6.0, alias declarations are allowed in other than
+ the <replaceable>table_references</replaceable> part, but should
+ be avoided for the reason just mentioned.
+ </para>
+
+ <para>
Cross-database deletes are supported for multiple-table deletes,
but you should be aware that in the list of tables from which to
delete rows, aliases will have a default database unless one is
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r17845 - in trunk: . dynamic-docs/changelog refman-5.5 | paul.dubois | 26 Nov |
