svn commit - mysqldoc@docsrva: r12762 - in trunk: . dynamic-docs/changelog

[paul.dubois]

Author: paul
Date: 2008-12-03 22:15:26 +0100 (Wed, 03 Dec 2008)
New Revision: 12762

Log:
 r36398@frost:  paul | 2008-12-03 14:59:36 -0500
 Document bugfixes:
 Bug#31616: div_precision_incrementdescription looks wrong
 Bug#33461: SELECT ... FROM <view> USE INDEX (...) throws an error
 Bug#36772: When using UTF8, CONVERT with GROUP BY returns truncated results
 Bug#37460: Assertion failed: !table->file || table->file->inited ==
handler::NONE
 Bug#37527: mysqlcheck fails to report entire database when InnoDB frm file corruption
 Bug#37553: MySql Error Compare TimeDiff & Time
 Bug#40365: Prepared statements may insert invalid dates.


Modified:
   trunk/dynamic-docs/changelog/mysqld-1.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:36397
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:34988
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:36398
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:34988


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2008-12-03 21:15:19 UTC (rev 12761)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2008-12-03 21:15:26 UTC (rev 12762)
Changed blocks: 1, Lines Added: 192, Lines Deleted: 0; 4081 bytes

@@ -35210,4 +35210,196 @@
 
   </logentry>
 
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="prepared statements"/>
+      <manual type="ALLOW_INVALID_DATES"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="40365"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.74"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Prepared statements allowed invalid dates to be inserted when
+        the <literal>ALLOW_INVALID_DATES</literal> SQL mode was not
+        enabled.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="TIMEDIFF()"/>
+      <manual type="CAST()"/>
+      <manual type="TIME"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="37553"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.74"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <literal role="func">TIMEDIFF()</literal> was erroneously
+        treated as always returning a positive result. Also,
+        <literal role="func">CAST()</literal> of
+        <literal role="type">TIME</literal> values to
+        <literal role="type">DECIMAL</literal> dropped the sign of
+        negative values.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="mysqlcheck"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="37527"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.74"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <command>mysqlcheck</command> used
+        <literal role="stmt" condition="show-tables">SHOW FULL
+        TABLES</literal> to get the list of tables in a database. For
+        some problems, such as an empty <filename>.frm</filename> file
+        for a table, this would fail and <command>mysqlcheck</command>
+        then would neglect to check other tables in the database.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="views"/>
+      <manual type="subqueries"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="37460"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.74"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Updating a view with a subquery in the <literal>CHECK</literal>
+        option could cause an assertion failure.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="CONVERT"/>
+      <manual type="GROUP BY"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="36772"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.74"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Use of <literal role="func">CONVERT()</literal> with
+        <literal>GROUP BY</literal> to convert numeric values to
+        <literal role="type">CHAR</literal> could return truncated
+        results.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="views"/>
+      <manual type="index hints"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="33461"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.74"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Previously, use of index hints with views (which do not have
+        indexes) produced the error <errortext>ERROR 1221 (HY000):
+        Incorrect usage of USE/IGNORE INDEX and VIEW</errortext>. Now
+        this produces <errortext>ERROR 1176 (HY000): Key '...' doesn't
+        exist in table '...'</errortext>, the same error as for base
+        tables without an appropriate index.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <bugs>
+      <fixes bugid="31616"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.74"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Some division operations produced a result with incorrect
+        precision.
+      </para>
+
+    </message>
+
+  </logentry>
+
 </changelog>