svn commit - mysqldoc@docsrva: r2865 - in trunk: refman-4.1 refman-5.0 refman-5.1

[mcbrown]

Author: mcbrown
Date: 2006-07-28 13:54:26 +0200 (Fri, 28 Jul 2006)
New Revision: 2865

Log:
Documenting #17436



Modified:
   trunk/refman-4.1/sql-syntax.xml
   trunk/refman-5.0/sql-syntax.xml
   trunk/refman-5.1/sql-syntax.xml


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2006-07-28 11:50:02 UTC (rev 2864)
+++ trunk/refman-4.1/sql-syntax.xml	2006-07-28 11:54:26 UTC (rev 2865)
Changed blocks: 2, Lines Added: 11, Lines Deleted: 1; 1101 bytes

@@ -623,7 +623,12 @@
             <xref linkend="innodb-foreign-key-constraints"/>.
           </para>
         </listitem>
-
+        
+        <listitem><para>Pending <literal>INSERT DELAYED</literal>
statements are lost if a table
+          is write locked and <literal>ALTER TABLE</literal> is used to
modify
+          the table structure.</para>
+        </listitem>        
+        
         <listitem>
           <para>
             <indexterm type="function">

@@ -4642,6 +4647,11 @@
             </para>
           </listitem>
 
+          <listitem>
+            <para>Pending <literal>INSERT DELAYED</literal> statements
are lost if a table
+              is write locked and <literal>ALTER TABLE</literal> is used to
modify
+              the table structure. </para></listitem>
+          
         </itemizedlist>
 
         <remark role="help-description-end"/>


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-07-28 11:50:02 UTC (rev 2864)
+++ trunk/refman-5.0/sql-syntax.xml	2006-07-28 11:54:26 UTC (rev 2865)
Changed blocks: 2, Lines Added: 10, Lines Deleted: 1; 1097 bytes

@@ -660,7 +660,12 @@
             <xref linkend="innodb-foreign-key-constraints"/>.
           </para>
         </listitem>
-
+       
+        <listitem><para>Pending <literal>INSERT DELAYED</literal>
statements are lost if a table
+          is write locked and <literal>ALTER TABLE</literal> is used to
modify
+          the table structure.</para>
+        </listitem>        
+                
         <listitem>
           <para>
             <indexterm type="function">

@@ -4574,6 +4579,10 @@
             </para>
           </listitem>
 
+          <listitem>
+            <para>Pending <literal>INSERT DELAYED</literal> statements
are lost if a table
+              is write locked and <literal>ALTER TABLE</literal> is used to
modify
+              the table structure. </para></listitem>
         </itemizedlist>
 
         <remark role="help-description-end"/>


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-07-28 11:50:02 UTC (rev 2864)
+++ trunk/refman-5.1/sql-syntax.xml	2006-07-28 11:54:26 UTC (rev 2865)
Changed blocks: 3, Lines Added: 10, Lines Deleted: 7; 1615 bytes

@@ -704,6 +704,11 @@
           </para>
         </listitem>
 
+        <listitem><para>Pending <literal>INSERT DELAYED</literal>
statements are lost if a table
+        is write locked and <literal>ALTER TABLE</literal> is used to modify
+        the table structure.</para>
+        </listitem>        
+        
         <listitem>
           <para>
             <indexterm type="function">

@@ -5910,13 +5915,6 @@
               <literal>INSERT DELAYED</literal> should be used only for
               <literal>INSERT</literal> statements that specify value
               lists. The server ignores <literal>DELAYED</literal> for
-              <literal>INSERT DELAYED ... SELECT</literal> statements.
-            </para>
-          </listitem>
-
-          <listitem>
-            <para>
-              The server ignores <literal>DELAYED</literal> for
               <literal>INSERT ... SELECT</literal> or <literal>INSERT
               ... ON DUPLICATE KEY UPDATE</literal> statements.
             </para>

@@ -5947,6 +5945,11 @@
               data than the master.
             </para>
           </listitem>
+          
+          <listitem>
+          <para>Pending <literal>INSERT DELAYED</literal> statements
are lost if a table
+          is write locked and <literal>ALTER TABLE</literal> is used to
modify
+            the table structure. </para></listitem>
 
         </itemizedlist>