Author: paul
Date: 2008-01-24 21:54:00 +0100 (Thu, 24 Jan 2008)
New Revision: 9628
Log:
r23383@arctic: paul | 2008-01-24 14:51:57 -0600
Document bugfixes:
Bug#9481: mysql_insert_id() returns 0 after insert ... select
Bug#26921: Problem in mysql_insert_id() Embedded C API function
Bug#30152: MySQLD crash duing alter table causes DROP DATABASE to FAIL due to temp file
Bug#30294: blackhole engine causes 100% with 2 alter table statements running
Bug#30355: Incorrect ordering of UDF results
Bug#33256: CREATE ... SELECT creates obsolete table w/ Field_date instead of Field_newdate
Bug#33794: MySQL crashes executing specific query on specific dump
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/dynamic-docs/changelog/mysqld-versions.xml
trunk/refman-5.0/apis-c.xml
trunk/refman-5.1/news-5.1-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28708
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:23382
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28708
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:23383
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-01-24 20:53:47 UTC (rev 9627)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-01-24 20:54:00 UTC (rev 9628)
Changed blocks: 1, Lines Added: 209, Lines Deleted: 0; 4533 bytes
@@ -5783,4 +5783,213 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="UDF"/>
+ <manual type="optimizer"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="30355"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.54"/>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The optimizer made incorrect assumptions about the value of the
+ <literal>is_member</literal> value for user-defined functions,
+ sometimes resulting in incorrect ordering of UDF results.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="BLACKHOLE"/>
+ <manual type="ALTER TABLE"/>
+ <manual type="locking"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="30294"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.54"/>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Simultaneous <literal>ALTER TABLE</literal> statements for
+ <literal>BLACKHOLE</literal> tables caused 100% CPU use due to
+ locking problems.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="DROP DATABASE"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="30152"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ If the server crashed during an <literal>ALTER TABLE</literal>
+ statement, leaving a temporary file in the database directory, a
+ subsequent <literal>DROP DATABASE</literal> statement failed due
+ to the presence of the temporary file.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="libmysqld"/>
+ <manual type="mysql_insert_id()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="26921"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The <function role="capi">mysql_insert_id()</function> C API
+ function sometimes returned different results for
+ <literal>libmysqld</literal> and
+ <literal>libmysqlclient</literal>.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="mysql_insert_id()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="9481"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.54"/>
+ </versions>
+
+ <message>
+
+ <para>
+ If an <literal>INSERT ... SELECT</literal> statement is
+ executed, and no automatically generated value is successfully
+ inserted, then
+ <function role="capi">mysql_insert_id()</function> returns the
+ ID of the last inserted row.
+ </para>
+
+ <para>
+ If no automatically generated value is successfully inserted,
+ then <function role="capi">mysql_insert_id()</function> returns
+ 0.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="CREATE TABLE"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="33256"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <literal>CREATE TABLE ... SELECT</literal> created tables that
+ for date columns used the obsolete <literal>Field_date</literal>
+ type instead of <literal>Field_newdate</literal>.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="subquery"/>
+ <manual type="optimizer"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="33794"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The server crashed when executing a query that had a subquery
+ containing an equality X=Y where Y referred to a named select
+ list expression from the parent select. The server crashed when
+ trying to use the X=Y equality for <literal>ref</literal>-based
+ access.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/dynamic-docs/changelog/mysqld-versions.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-versions.xml 2008-01-24 20:53:47 UTC (rev 9627)
+++ trunk/dynamic-docs/changelog/mysqld-versions.xml 2008-01-24 20:54:00 UTC (rev 9628)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 750 bytes
@@ -25,6 +25,7 @@
<versionentry ver="5.2.3" reldate="15 February 2007"/>
<versionentry ver="5.2.2" reldate="Not released"/>
<versionentry ver="5.2.1" reldate="Not released"/>
+ <versionentry ver="5.1.24" reldate="Not yet released"/>
<versionentry ver="5.1.23" reldate="Not yet released"/>
<versionentry ver="5.1.23" subver="ndb-6.3.8" reldate="Not yet released"/>
<versionentry ver="5.1.23" subver="ndb-6.2.11" reldate="Not yet released"/>
Modified: trunk/refman-5.0/apis-c.xml
===================================================================
--- trunk/refman-5.0/apis-c.xml 2008-01-24 20:53:47 UTC (rev 9627)
+++ trunk/refman-5.0/apis-c.xml 2008-01-24 20:54:00 UTC (rev 9628)
Changed blocks: 1, Lines Added: 17, Lines Deleted: 0; 1118 bytes
@@ -4041,6 +4041,23 @@
<listitem>
<para>
+ Starting in MySQL 5.0.54, if an <literal>INSERT ...
+ SELECT</literal> statement is executed, and no automatically
+ generated value is successfully inserted, then
+ <function role="capi">mysql_insert_id()</function> returns
+ the ID of the last inserted row.
+ </para>
+
+ <para>
+ If no automatically generated value is successfully
+ inserted, then
+ <function role="capi">mysql_insert_id()</function> returns
+ 0.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
<literal>INSERT</literal> statements that generate an
<literal>AUTO_INCREMENT</literal> value by inserting
<function role="sql">LAST_INSERT_ID(<replaceable>expr</replaceable>)</function>
Modified: trunk/refman-5.1/news-5.1-core.xml
===================================================================
--- trunk/refman-5.1/news-5.1-core.xml 2008-01-24 20:53:47 UTC (rev 9627)
+++ trunk/refman-5.1/news-5.1-core.xml 2008-01-24 20:54:00 UTC (rev 9628)
Changed blocks: 1, Lines Added: 8, Lines Deleted: 0; 645 bytes
@@ -37,6 +37,14 @@
<filename>refman-common</filename> directory.
</remark>
+ <section id="news-5-1-24">
+
+ <title condition="dynamic:changelog:vertitle" role="5.1.24:mysqld:all"/>
+
+ <para condition="dynamic:changelog:entrylist" role="5.1.24:mysqld:all"/>
+
+ </section>
+
<section id="news-5-1-23">
<title condition="dynamic:changelog:vertitle" role="5.1.23:mysqld:all"/>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r9628 - in trunk: . dynamic-docs/changelog refman-5.0 refman-5.1 | paul | 24 Jan |
