Author: paul
Date: 2008-01-28 19:18:20 +0100 (Mon, 28 Jan 2008)
New Revision: 9646
Log:
r23426@arctic: paul | 2008-01-28 12:16:01 -0600
Document bugfixes:
Bug#25347: Patch: mysqlcheck -A -r doesn't repair table marked as crashed
Bug#27427: resolveip fails on hostnames with a leading digit
Bug#32770: LAST_DAY() returns a DATE, but somehow internally keeps track of the TIME.
Bug#32798: DISTINCT in GROUP_CONCAT clause fails when ordering by a column with null values
Bug#32848: Data type conversion bug in union subselects in MySQL 5.0.38
Bug#33699: UPDATE allows NULL as new value on NOT NULL columns (= default datatype value)
Modified:
trunk/dynamic-docs/changelog/mysqld-1.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:28770
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:23408
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:34985
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:28770
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:23426
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-01-28 14:58:42 UTC (rev 9645)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-01-28 18:18:20 UTC (rev 9646)
Changed blocks: 1, Lines Added: 174, Lines Deleted: 0; 3805 bytes
@@ -6271,4 +6271,178 @@
</logentry>
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="mysqlcheck"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="25347"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <command>mysqlcheck -A -r</command> did not correctly identify
+ all tables that needed repairing.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="resolveip"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="27427"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ <command>resolveip</command> failed to produce correct results
+ for hostnames that begin with a digit.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="UNION"/>
+ <manual type="subqueries"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="32848"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The correct data type for a <literal>NULL</literal> column
+ resulting from a <literal>UNION</literal> could be determined
+ incorrectly in some cases: 1) Not correctly inferred as
+ <literal>NULL</literal> depending on the number of selects; 2)
+ Not inferred correctly as <literal>NULL</literal> if one select
+ used a subquery.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="GROUP_CONCAT()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="32798"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.56"/>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ For queries containing <literal>GROUP_CONCAT(DISTINCT
+ <replaceable>col_list</replaceable> ORDER BY
+ <replaceable>col_list</replaceable>)</literal>, there was a
+ limitation that the <literal>DISTINCT</literal> columns had to
+ be the same as <literal>ORDER BY</literal> columns. Incorrect
+ results could be returned if this was not true.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="LAST_DAY()"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="XXX"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.54"/>
+ <version ver="5.1.23"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The <function role="sql">LAST_DAY()</function> function returns
+ a <literal>DATE</literal> value, but internally the value did
+ not have the time fields zeroed and calculations involving the
+ value could return incorrect results.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="UPDATE"/>
+ <manual type="NULL"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="33699"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.1.24"/>
+ <version ver="6.0.5"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The UPDATE statement allowed <literal>NULL</literal> to be
+ assigned to <literal>NOT NULL</literal> columns (the default
+ data type value was assigned). An error occurs now.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r9646 - in trunk: . dynamic-docs/changelog | paul | 28 Jan |
