bk commit - mysqldoc@docsrva tree (paul:1.2816)

[paul]

Below is the list of changes that have just been committed into a local
mysqldoc repository of paul. When paul does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.2816 05/06/17 12:21:43 paul@stripped +1 -0
  news.xml:
    Re-do edits that were undone by a party who will remain unnamed.

  refman/news.xml
    1.8 05/06/17 12:21:16 paul@stripped +54 -2
    Re-do edits that were undone by a party who will remain unnamed.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	paul
# Host:	frost.snake.net
# Root:	/Volumes/frost2/MySQL/bk/mysqldoc

--- 1.7/refman/news.xml	2005-06-17 11:54:12 -05:00
+++ 1.8/refman/news.xml	2005-06-17 12:21:16 -05:00
@@ -232,6 +232,21 @@
    <itemizedlist>
 
     <listitem><para>
+     Fixed a problem where a stored procedure caused a server crash if
+     the query cache was enabled. (Bug #9715)
+    </para></listitem>
+
+    <listitem><para>
+     <literal>SHOW CREATE DATABASE INFORMATION_SCHEMA</literal> returned
+     an <quote>unknown database</quote> error. (Bug #9434)
+    </para></listitem>
+
+    <listitem><para>
+     Corrected a problem with <literal>IFNULL()</literal> returning an
+     incorrect result on 64-bit systems. (Bug #11235)
+    </para></listitem>
+
+    <listitem><para>
      Fixed a problem resolving table names with
      <literal>lower_case_table_names=2</literal> when the table name
      lettercase differed in the <literal>FROM</literal> and
@@ -410,6 +425,14 @@
      before).
     </para></listitem>
 
+    <listitem><para>
+     <literal>InnoDB</literal>: In stored procedures and functions,
+     <literal>InnoDB</literal> no longer takes full explicit table locks
+     for every involved table. Only `intention' locks are taken, similar
+     to those in the execution of an ordinary SQL statement. This
+     greatly reduces the number of deadlocks.
+    </para></listitem>
+
    </itemizedlist>
 
    <para>
@@ -419,6 +442,12 @@
    <itemizedlist>
 
     <listitem><para>
+     Corrected a problem where an incorrect column type was returned in
+     the result set metadata when using a prepared <literal>SELECT
+     DISTINCT</literal> statement to select from a view. (Bug #11111)
+    </para></listitem>
+
+    <listitem><para>
      Fixed bug in the MySQL Instance manager that caused the version to
      always be <literal>unknown</literal> when <literal>SHOW INSTANCE
      STATUS</literal> was issued. (Bug #10229)
@@ -595,6 +624,20 @@
     </para></listitem>
 
     <listitem><para>
+     <literal>InnoDB</literal>: Fixed a duplicate key error that
+     occurred with <literal>REPLACE</literal> in a table with an
+     <literal>AUTO-INC</literal> column. (Bug #11005)
+    </para></listitem>
+
+    <listitem><para>
+     Fixed that MySQL would pass a wrong key length to storage engines
+     in <literal>MIN()</literal>. This could cause warnings
+     <literal>InnoDB: Warning: using a partial-field key prefix in
+     search.</literal> in the <filename>.err</filename> log. (Bug
+     #11039)
+    </para></listitem>
+
+    <listitem><para>
      Fixed a server crash for <literal>INSERT</literal> or
      <literal>UPDATE</literal> when the <literal>WHERE</literal>
clause
      contained a correlated subquery that referred to a column of the
@@ -1016,8 +1059,8 @@
     </para></listitem>
 
     <listitem><para>
-     Fixed server crash resulting from multiple calls to stored
-     procedure that assigned result of subquery to a variable or
+     Fixed server crash resulting from multiple calls to a stored
+     procedure that assigned the result of a subquery to a variable or
      compared it to a value with <literal>IN</literal>. (Bug #5963)
     </para></listitem>
 
@@ -4044,6 +4087,15 @@
    </para>
 
    <itemizedlist>
+
+    <listitem><para>
+     Added the <option>--log-slow-admin-statements</option> server
+     option to request logging of slow administrative statements such as
+     <literal>OPTIMIZE TABLE</literal>, <literal>ANALYZE
+     TABLE</literal>, and <literal>ALTER TABLE</literal> to the slow
+     query log. These statements were logged in MySQL 4.0, but not in
+     4.1. (Bug #9141)
+    </para></listitem>
 
     <listitem><para>
      <literal>SHOW BINARY LOGS</literal> now displays a