svn commit - mysqldoc@docsrva: r7093 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2

[paul]

Author: paul
Date: 2007-07-12 02:24:19 +0200 (Thu, 12 Jul 2007)
New Revision: 7093

Log:
 r22686@frost:  paul | 2007-07-11 17:54:24 -0500
 Document bugfixes:
 Bug#27333
 Bug#27741
 Bug#28846
 Bug#29247
 Bug#29251


Modified:
   trunk/refman-4.1/news-4.1.xml
   trunk/refman-5.0/apis-c.xml
   trunk/refman-5.0/releasenotes-cs-5.0.xml
   trunk/refman-5.0/releasenotes-es-5.0.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/apis-c.xml
   trunk/refman-5.1/news-5.1.xml
   trunk/refman-5.1/sql-syntax.xml
   trunk/refman-5.2/sql-syntax.xml

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


Modified: trunk/refman-4.1/news-4.1.xml
===================================================================
--- trunk/refman-4.1/news-4.1.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-4.1/news-4.1.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 0; 996 bytes

@@ -199,6 +199,19 @@
 
       <listitem>
         <para>
+          If an <literal>ENUM</literal> column contained
+          <literal>''</literal> as one of its members (represented with
+          numeric value greater than 0), and the column contained error
+          values (represented as 0 and displayed as
+          <literal>''</literal>), using <literal>ALTER
TABLE</literal>
+          to modify the column definition caused the 0 values to be
+          given the numeric value of the non-zero <literal>''</literal>
+          member. (Bug #29251)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           The semantics of <literal>BIGINT</literal> depended on
           platform-specific characteristics. (Bug #29079)
         </para>


Modified: trunk/refman-5.0/apis-c.xml
===================================================================
--- trunk/refman-5.0/apis-c.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.0/apis-c.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 0; 1112 bytes

@@ -5160,6 +5160,19 @@
             5.0.13 and provides a way to set reconnection behavior
             explicitly.
           </para>
+
+          <para>
+            Note: <literal>mysql_real_connect()</literal> incorrectly
+            reset the <literal>MYSQL_OPT_RECONNECT</literal> option to
+            its default value before MySQL 5.0.19. Therefore, prior to
+            that version, if you want reconnect to be enabled for each
+            connection, you must call <literal>mysql_options()</literal>
+            with the <literal>MYSQL_OPT_RECONNECT</literal> option after
+            each call to <literal>mysql_real_connect()</literal>. This
+            is not necessary as of 5.0.19: Call
+            <literal>mysql_options()</literal> only before
+            <literal>mysql_real_connect()</literal> as usual.
+          </para>
         </listitem>
 
         <listitem>


Modified: trunk/refman-5.0/releasenotes-cs-5.0.xml
===================================================================
--- trunk/refman-5.0/releasenotes-cs-5.0.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.0/releasenotes-cs-5.0.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 2, Lines Added: 12, Lines Deleted: 1; 1248 bytes

@@ -164,7 +164,8 @@
         <para>
           <emphasis role="bold">Security Fix</emphasis>:
<literal>CREATE
           TABLE LIKE</literal> did not require any privileges on the
-          source table. (Bug #25578)
+          source table. Now it requires the <literal>SELECT</literal>
+          privilege. (Bug #25578)
         </para>
 
         <para>

@@ -285,6 +286,16 @@
 
       <listitem>
         <para>
+          On some systems, <filename>udf_example.c</filename> returned
+          an incorrect result length. Also on some systems,
+          <command>mysql-test-run.pl</command> could not find the shared
+          object built from <filename>udf_example.c</filename>. (Bug
+          #27741)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           The <literal>-lmtmalloc</literal> library was removed from the
           output of <command>mysql_config</command> on Solaris, as it
           caused problems when building <literal>DBD::mysql</literal>


Modified: trunk/refman-5.0/releasenotes-es-5.0.xml
===================================================================
--- trunk/refman-5.0/releasenotes-es-5.0.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.0/releasenotes-es-5.0.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 3, Lines Added: 50, Lines Deleted: 1; 2845 bytes

@@ -102,6 +102,44 @@
 
       <listitem>
         <para>
+          <literal>ALTER VIEW</literal> is not supported as a prepared
+          statement but was not being rejected. <literal>ALTER
+          VIEW</literal> is now prohibited as a prepared statement or
+          when called within stored routines. (Bug #28846)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Calling <literal>mysql_options()</literal> after
+          <literal>mysql_real_connect()</literal> could cause clients to
+          crash. (Bug #29247)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          If an <literal>ENUM</literal> column contained
+          <literal>''</literal> as one of its members (represented with
+          numeric value greater than 0), and the column contained error
+          values (represented as 0 and displayed as
+          <literal>''</literal>), using <literal>ALTER
TABLE</literal>
+          to modify the column definition caused the 0 values to be
+          given the numeric value of the non-zero <literal>''</literal>
+          member. (Bug #29251)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Aggregations in subqueries that refer to outer query columns
+          were not always correctly referenced to the proper outer
+          query. (Bug #27333)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Use of <literal>SHOW BINLOG EVENTS</literal> for a
           non-existent log file followed by <literal>PURGE MASTER
           LOGS</literal> caused a server crash. (Bug #29420)

@@ -640,7 +678,8 @@
         <para>
           <emphasis role="bold">Security Fix</emphasis>:
<literal>CREATE
           TABLE LIKE</literal> did not require any privileges on the
-          source table. (Bug #25578)
+          source table. Now it requires the <literal>SELECT</literal>
+          privilege. (Bug #25578)
         </para>
 
         <para>

@@ -761,6 +800,16 @@
 
       <listitem>
         <para>
+          On some systems, <filename>udf_example.c</filename> returned
+          an incorrect result length. Also on some systems,
+          <command>mysql-test-run.pl</command> could not find the shared
+          object built from <filename>udf_example.c</filename>. (Bug
+          #27741)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           The <literal>-lmtmalloc</literal> library was removed from the
           output of <command>mysql_config</command> on Solaris, as it
           caused problems when building <literal>DBD::mysql</literal>


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.0/sql-syntax.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 542 bytes

@@ -2939,7 +2939,8 @@
 
       <para>
         The copy is created using the same version of the table storage
-        format as the original table.
+        format as the original table. The <literal>SELECT</literal>
+        privilege is required on the original table.
       </para>
 
       <para>


Modified: trunk/refman-5.1/apis-c.xml
===================================================================
--- trunk/refman-5.1/apis-c.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.1/apis-c.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 0; 1123 bytes

@@ -5220,6 +5220,19 @@
             by default; this option provides a way to set reconnection
             behavior explicitly.
           </para>
+
+          <para>
+            Note: <literal>mysql_real_connect()</literal> incorrectly
+            reset the <literal>MYSQL_OPT_RECONNECT</literal> option to
+            its default value before MySQL 5.1.6. Therefore, prior to
+            that version, if you want reconnect to be enabled for each
+            connection, you must call <literal>mysql_options()</literal>
+            with the <literal>MYSQL_OPT_RECONNECT</literal> option after
+            each call to <literal>mysql_real_connect()</literal>. This
+            is not necessary as of 5.1.6: Call
+            <literal>mysql_options()</literal> only before
+            <literal>mysql_real_connect()</literal> as usual.
+          </para>
         </listitem>
 
         <listitem>


Modified: trunk/refman-5.1/news-5.1.xml
===================================================================
--- trunk/refman-5.1/news-5.1.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.1/news-5.1.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 3, Lines Added: 50, Lines Deleted: 1; 2818 bytes

@@ -164,6 +164,44 @@
 
       <listitem>
         <para>
+          <literal>ALTER VIEW</literal> is not supported as a prepared
+          statement but was not being rejected. <literal>ALTER
+          VIEW</literal> is now prohibited as a prepared statement or
+          when called within stored routines. (Bug #28846)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Calling <literal>mysql_options()</literal> after
+          <literal>mysql_real_connect()</literal> could cause clients to
+          crash. (Bug #29247)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          If an <literal>ENUM</literal> column contained
+          <literal>''</literal> as one of its members (represented with
+          numeric value greater than 0), and the column contained error
+          values (represented as 0 and displayed as
+          <literal>''</literal>), using <literal>ALTER
TABLE</literal>
+          to modify the column definition caused the 0 values to be
+          given the numeric value of the non-zero <literal>''</literal>
+          member. (Bug #29251)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
+          Aggregations in subqueries that refer to outer query columns
+          were not always correctly referenced to the proper outer
+          query. (Bug #27333)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Use of <literal>SHOW BINLOG EVENTS</literal> for a
           non-existent log file followed by <literal>PURGE MASTER
           LOGS</literal> caused a server crash. (Bug #29420)

@@ -977,7 +1015,8 @@
         <para>
           <emphasis role="bold">Security Fix</emphasis>:
<literal>CREATE
           TABLE LIKE</literal> did not require any privileges on the
-          source table. (Bug #25578)
+          source table. Now it requires the <literal>SELECT</literal>
+          privilege. (Bug #25578)
         </para>
 
         <para>

@@ -1241,6 +1280,16 @@
 
       <listitem>
         <para>
+          On some systems, <filename>udf_example.c</filename> returned
+          an incorrect result length. Also on some systems,
+          <command>mysql-test-run.pl</command> could not find the shared
+          object built from <filename>udf_example.c</filename>. (Bug
+          #27741)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           The server made strong assumptions about the structure of the
           <literal>general_log</literal> and
<literal>slow_log</literal>
           log tables: It supported only the table structure defined in


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.1/sql-syntax.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 542 bytes

@@ -4415,7 +4415,8 @@
 
       <para>
         The copy is created using the same version of the table storage
-        format as the original table.
+        format as the original table. The <literal>SELECT</literal>
+        privilege is required on the original table.
       </para>
 
       <para>


Modified: trunk/refman-5.2/sql-syntax.xml
===================================================================
--- trunk/refman-5.2/sql-syntax.xml	2007-07-11 23:01:15 UTC (rev 7092)
+++ trunk/refman-5.2/sql-syntax.xml	2007-07-12 00:24:19 UTC (rev 7093)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 542 bytes

@@ -4432,7 +4432,8 @@
 
       <para>
         The copy is created using the same version of the table storage
-        format as the original table.
+        format as the original table. The <literal>SELECT</literal>
+        privilege is required on the original table.
       </para>
 
       <para>