From: paul
Date: December 7 2005 3:40pm
Subject: svn commit - mysqldoc@docsrva: r515 - in trunk: . refman-5.0 refman-5.1 refman-common
List-Archive: http://lists.mysql.com/commits/19
Message-Id: <200512071540.jB7FerYE001082@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: paul
Date: 2005-12-07 16:40:53 +0100 (Wed, 07 Dec 2005)
New Revision: 515

Log:
 r4574@frost:  paul | 2005-12-07 09:38:53 -0600
 REPAIR/BACKUP/RESTORE TABLES now prohibited in stored routines.
 (Bug#13012)


Modified:
   trunk/
   trunk/refman-5.0/restrictions.xml
   trunk/refman-5.1/restrictions.xml
   trunk/refman-common/news-5.0.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4569
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1505
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4574
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1505

Modified: trunk/refman-5.0/restrictions.xml
===================================================================
--- trunk/refman-5.0/restrictions.xml	2005-12-07 15:40:20 UTC (rev 514)
+++ trunk/refman-5.0/restrictions.xml	2005-12-07 15:40:53 UTC (rev 515)
@@ -72,20 +72,24 @@
 
       <listitem>
         <para>
-          <literal>CHECK TABLES</literal>
+          The table-maintenance statements <literal>BACKUP
+          TABLES</literal>, <literal>CHECK TABLES</literal>,
+          <literal>OPTIMIZE TABLES</literal>, and <literal>REPAIR
+          TABLES</literal>, <literal>RESTORE TABLES</literal>.
         </para>
       </listitem>
 
       <listitem>
         <para>
-          <literal>LOCK TABLES</literal>, <literal>UNLOCK
-          TABLES</literal>
+          The locking statements <literal>LOCK TABLES</literal>,
+          <literal>UNLOCK TABLES</literal>.
         </para>
       </listitem>
 
       <listitem>
         <para>
-          <literal>LOAD DATA</literal>, <literal>LOAD TABLE</literal>
+          <literal>LOAD DATA</literal> and <literal>LOAD
+          TABLE</literal>.
         </para>
       </listitem>
 
@@ -101,12 +105,6 @@
         </para>
       </listitem>
 
-      <listitem>
-        <para>
-          <literal>OPTIMIZE TABLE</literal>
-        </para>
-      </listitem>
-
     </itemizedlist>
 
     <para>

Modified: trunk/refman-5.1/restrictions.xml
===================================================================
--- trunk/refman-5.1/restrictions.xml	2005-12-07 15:40:20 UTC (rev 514)
+++ trunk/refman-5.1/restrictions.xml	2005-12-07 15:40:53 UTC (rev 515)
@@ -72,20 +72,24 @@
 
       <listitem>
         <para>
-          <literal>CHECK TABLES</literal>
+          The table-maintenance statements <literal>BACKUP
+          TABLES</literal>, <literal>CHECK TABLES</literal>,
+          <literal>OPTIMIZE TABLES</literal>, and <literal>REPAIR
+          TABLES</literal>, <literal>RESTORE TABLES</literal>.
         </para>
       </listitem>
 
       <listitem>
         <para>
-          <literal>LOCK TABLES</literal>, <literal>UNLOCK
-          TABLES</literal>
+          The locking statements <literal>LOCK TABLES</literal>,
+          <literal>UNLOCK TABLES</literal>.
         </para>
       </listitem>
 
       <listitem>
         <para>
-          <literal>LOAD DATA</literal>, <literal>LOAD TABLE</literal>
+          <literal>LOAD DATA</literal> and <literal>LOAD
+          TABLE</literal>.
         </para>
       </listitem>
 
@@ -101,12 +105,6 @@
         </para>
       </listitem>
 
-      <listitem>
-        <para>
-          <literal>OPTIMIZE TABLE</literal>
-        </para>
-      </listitem>
-
     </itemizedlist>
 
     <para>

Modified: trunk/refman-common/news-5.0.xml
===================================================================
--- trunk/refman-common/news-5.0.xml	2005-12-07 15:40:20 UTC (rev 514)
+++ trunk/refman-common/news-5.0.xml	2005-12-07 15:40:53 UTC (rev 515)
@@ -219,6 +219,15 @@
 
       <listitem>
         <para>
+          <literal>REPAIR TABLES</literal>, <literal>BACKUP
+          TABLES</literal>, <literal>RESTORE TABLES</literal> within a
+          stored routine caused a server crash. These statements now are
+          prohibited within stored routines. (Bug #13012)
+        </para>
+      </listitem>
+
+      <listitem>
+        <para>
           Creating a view that referenced a stored function that
           selected from a view caused a crash upon selection from the
           view. (Bug #15096)