bk commit - mysqldoc@docsrva tree (Mike.Hillyer:1.3186)

[mhillyer]

Below is the list of changes that have just been committed into a local
mysqldoc repository of root. When root 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.3186 05/08/06 20:16:36 Mike.Hillyer@stripped +7 -0
  Documented bugfixes:
  
  12109,10351,9968,12144,12233,11402,9947,12075,11602,11126,12266,12097,11335,3716,7308

  refman/titles.ent
    1.46 05/08/06 20:16:35 Mike.Hillyer@stripped +2 -1
    Added 5.0.12 entity.

  refman/client-side-scripts.xml
    1.12 05/08/06 20:16:35 Mike.Hillyer@stripped +11 -0
    Sync

  refman-common/news-5.1.xml
    1.4 05/08/06 20:16:35 Mike.Hillyer@stripped +13 -5
    Document Bugfixes.

  refman-common/news-5.0.xml
    1.23 05/08/06 20:16:35 Mike.Hillyer@stripped +124 -0
    Document Bugfixes.

  refman-common/news-4.1.xml
    1.16 05/08/06 20:16:35 Mike.Hillyer@stripped +75 -0
    Document Bugfixes.

  refman-5.0/client-side-scripts.xml
    1.2 05/08/06 20:16:35 Mike.Hillyer@stripped +11 -0
    Sync

  refman-4.1/client-side-scripts.xml
    1.10 05/08/06 20:16:35 Mike.Hillyer@stripped +11 -0
    Sync

# 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:	Mike.Hillyer
# Host:	www.openwin.org
# Root:	/home/mysqldoc/mysqldoc

--- 1.15/refman-common/news-4.1.xml	2005-08-05 16:55:12 -06:00
+++ 1.16/refman-common/news-4.1.xml	2005-08-06 20:16:35 -06:00
@@ -212,6 +212,14 @@
         </para>
       </listitem>
 
+      <listitem>
+        <para>
+          Added an optimization that avoids key access with
+          <literal>NULL</literal> keys for the
<literal>ref</literal>
+          method when used in outer joins. (Bug #12144)
+        </para>
+      </listitem>
+
     </itemizedlist>
 
     <para>
@@ -225,6 +233,52 @@
 
       <listitem>
         <para>
+          Performing <literal>DATE(LEFT(column,8))</literal> on a
+          <literal>DATE</literal> column produces incorrect results.
+          (Bug #12266)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>max_connections_per_hour</literal> setting was being
+          capped by unrelated <literal>max_user_connections</literal>
+          setting. (Bug #9947)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>big5</literal> strings were not being stored in
+          <literal>FULLTEXT</literal> index. (Bug #12075)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Updated dependency list for RPM builds to include missing
+          dependencies such as <literal>useradd</literal> and
+          <literal>groupadd</literal>. (Bug #12233)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Multiplying <literal>ABS()</literal> output by a negative
+          number would return incorrect results. (Bug #11402)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>SELECT @@local...</literal> returned
+          <literal>@@session...</literal> in the column header. (Bug
+          #10724)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Character data truncated when GBK characters
           <literal>0xA3A0</literal> and <literal>0xA1</literal>
are
           present. (Bug #11987)
@@ -249,6 +303,13 @@
 
       <listitem>
         <para>
+          Two threads could potentially initialize different characters
+          sets and overwrite each other. (Bug #12109)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           <literal>NDB</literal>: Attempting to create or drop tables
           during a backup would cause the cluster to shut down. (Bug
           #11942)
@@ -448,6 +509,13 @@
         </para>
       </listitem>
 
+      <listitem>
+        <para>
+          <literal>ISO-8601</literal> formatted dates were not being
+          parsed correctly. (Bug #7308)
+        </para>
+      </listitem>
+
     </itemizedlist>
 
   </section>
@@ -479,6 +547,13 @@
           in a buffer overflow and code execution.
           (<ulink
url="http://cve.mitre.org/cgi-bin/cvename.cgi?name=CAN-2005-2096">CAN-2005-2096</ulink>)
           (Bug #11844)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Added <literal>--add-drop-database</literal> option to
+          <literal>mysqldump</literal>. (Bug #3716)
         </para>
       </listitem>
 

--- 1.22/refman-common/news-5.0.xml	2005-08-05 16:55:12 -06:00
+++ 1.23/refman-common/news-5.0.xml	2005-08-06 20:16:35 -06:00
@@ -163,6 +163,47 @@
     for each individual 5.0.x release.
   </para>
 
+  <section id="news-5-0-12">
+
+    <title id="title-news-5-0-12">&title-news-5-0-12;</title>
+
+    <para>
+      Functionality added or changed:
+    </para>
+
+    <itemizedlist>
+
+      <listitem>
+        <para></para>
+      </listitem>
+
+    </itemizedlist>
+
+    <para>
+      Bugs fixed:
+    </para>
+
+    <itemizedlist>
+
+      <listitem>
+        <para>
+          Columns defined as <literal>TINYINT(1)</literal> redefined as
+          <literal>TINYINT(4)</literal> when incorporated into a
+          <literal>VIEW</literal>. (Bug #11335)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>ISO-8601</literal> formatted dates were not being
+          parsed correctly. (Bug #7308)
+        </para>
+      </listitem>
+
+    </itemizedlist>
+
+  </section>
+
   <section id="news-5-0-11">
 
     <title id="title-news-5-0-11">&title-news-5-0-11;</title>
@@ -217,6 +258,21 @@
         </para>
       </listitem>
 
+      <listitem>
+        <para>
+          Added an optimization that avoids key access with
+          <literal>NULL</literal> keys for the
<literal>ref</literal>
+          method when used in outer joins. (Bug #12144)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Maximum size of stored procedures increased from 64k to 4Gb.
+          (Bug #11602)
+        </para>
+      </listitem>
+
     </itemizedlist>
 
     <para>
@@ -227,6 +283,52 @@
 
       <listitem>
         <para>
+          <literal>big5</literal> strings were not being stored in
+          <literal>FULLTEXT</literal> index. (Bug #12075)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          When <literal>DROP DATABASE</literal> was called concurrently
+          with a <literal>DROP TABLE</literal> of any table the MySQL
+          Server crashed. (Bug #12212)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>max_connections_per_hour</literal> setting was being
+          capped by unrelated <literal>max_user_connections</literal>
+          setting. (Bug #9947)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>SELECT @@local...</literal> returned
+          <literal>@@session...</literal> in the column header. (Bug
+          #10724)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Multiplying <literal>ABS()</literal> output by a negative
+          number would return incorrect results. (Bug #11402)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Updated dependency list for RPM builds to include missing
+          dependencies such as <literal>useradd</literal> and
+          <literal>groupadd</literal>. (Bug #12233)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           <literal>mysql_install_db</literal> used static
           <literal>localhost</literal> value in
<literal>GRANT</literal>
           tables even when server hostname is not
@@ -402,6 +504,28 @@
           <literal>InnoDB</literal>: True
<literal>VARCHAR</literal>:
           Return <literal>NULL</literal> columns in the format expected
           by MySQL. (Bug #12186)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Two threads could potentially initialize different characters
+          sets and overwrite each other. (Bug #12109)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Unsigned <literal>LONG</literal> system variables may return
+          incorrect value when retreived with a
+          <literal>SELECT</literal> for certain values. (Bug #10351)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Prepared statements were not being written to the Slow Query
+          log. (Bug #9968)
         </para>
       </listitem>
 

--- 1.3/refman-common/news-5.1.xml	2005-08-01 10:50:41 -06:00
+++ 1.4/refman-common/news-5.1.xml	2005-08-06 20:16:35 -06:00
@@ -56,13 +56,21 @@
     </para>
 
     <itemizedlist>
-      
+
       <listitem>
         <para>
-          <literal>NDB</literal>: Specifying the wrong nodegroup in a 
-          <literal>CREATE TABLE</literal> using partitioning would lead 
-          to the table name being locked after the <literal>CREATE 
-          TABLE</literal> statement failed (that is, the table name 
+          Performing a <literal>CREATE TABLE</literal> statement with a
+          <literal>PARTITION BY</literal> clause in a prepared statement
+          could crash a server running in debug mode. (Bug #12097)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          <literal>NDB</literal>: Specifying the wrong nodegroup in a
+          <literal>CREATE TABLE</literal> using partitioning would lead
+          to the table name being locked after the <literal>CREATE
+          TABLE</literal> statement failed (that is, the table name
           could not be re-used). (Bug #12114)
         </para>
       </listitem>

--- 1.9/refman-4.1/client-side-scripts.xml	2005-08-03 15:26:41 -06:00
+++ 1.10/refman-4.1/client-side-scripts.xml	2005-08-06 20:16:35 -06:00
@@ -5474,6 +5474,17 @@
         </para>
       </listitem>
 
+<listitem>
+        <para>
+          <option>--add-drop-database</option>
+        </para>
+
+        <para>
+          Add a <literal>DROP DATABASE</literal> statement before each
+          <literal>CREATE DATABASE</literal> statement.
+        </para>
+      </listitem>
+
       <listitem>
         <para>
           <option>--add-drop-table</option>

--- 1.11/refman/client-side-scripts.xml	2005-08-03 15:26:41 -06:00
+++ 1.12/refman/client-side-scripts.xml	2005-08-06 20:16:35 -06:00
@@ -5474,6 +5474,17 @@
         </para>
       </listitem>
 
+<listitem>
+        <para>
+          <option>--add-drop-database</option>
+        </para>
+
+        <para>
+          Add a <literal>DROP DATABASE</literal> statement before each
+          <literal>CREATE DATABASE</literal> statement.
+        </para>
+      </listitem>
+
       <listitem>
         <para>
           <option>--add-drop-table</option>

--- 1.45/refman/titles.ent	2005-08-05 06:55:32 -06:00
+++ 1.46/refman/titles.ent	2005-08-06 20:16:35 -06:00
@@ -1,7 +1,8 @@
 <?xml version='1.0' encoding='utf-8'?>
 <!ENTITY top "MySQL Reference Manual"><!-- "MySQL Reference Manual" -->
 <!ENTITY current-version "5.0.9-beta"><!-- "5.0.9-beta" --><!-- Current
MySQL Version - update with new releases -->
-<!ENTITY title-news-5-0-11 "Changes in release 5.0.11 (Not yet released)"><!--
"Changes in release 5.0.10 (Not yet released)" -->
+<!ENTITY title-news-5-0-12 "Changes in release 5.0.12 (Not yet released)"><!--
"Changes in release 5.0.12 (Not yet released)" -->
+<!ENTITY title-news-5-0-11 "Changes in release 5.0.11 (Not yet released)"><!--
"Changes in release 5.0.11 (Not yet released)" -->
 <!ENTITY title-news-5-0-10 "Changes in release 5.0.10 (Not yet released)"><!--
"Changes in release 5.0.10 (Not yet released)" -->
 <!ENTITY title-news-5-0-9 "Changes in release 5.0.9 (15 July 2005)"><!--
"Changes in release 5.0.9 (Not yet released)" -->
 <!ENTITY title-news-4-0-26 "Changes in release 4.0.26 (Not yet released)"><!--
"Changes in release 4.0.26 (Not yet released)" -->

--- 1.1/refman-5.0/client-side-scripts.xml	2005-08-05 11:11:25 -06:00
+++ 1.2/refman-5.0/client-side-scripts.xml	2005-08-06 20:16:35 -06:00
@@ -4887,6 +4887,17 @@
         </para>
       </listitem>
 
+<listitem>
+        <para>
+          <option>--add-drop-database</option>
+        </para>
+
+        <para>
+          Add a <literal>DROP DATABASE</literal> statement before each
+          <literal>CREATE DATABASE</literal> statement.
+        </para>
+      </listitem>
+
       <listitem>
         <para>
           <option>--add-drop-table</option>