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

[paul]

Author: paul
Date: 2006-10-30 20:10:14 +0100 (Mon, 30 Oct 2006)
New Revision: 3802

Log:
 r15008@polar:  paul | 2006-10-30 13:09:03 -0600
 Tip for avoiding "ambiguous column" in INSERT ... SELECT. (Bug#20916)


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

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


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2006-10-30 18:24:15 UTC (rev 3801)
+++ trunk/refman-4.1/sql-syntax.xml	2006-10-30 19:10:14 UTC (rev 3802)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 807 bytes

@@ -4535,6 +4535,17 @@
             </para>
           </listitem>
 
+          <listitem>
+            <para>
+              To avoid ambigious column reference problems when the
+              <literal>SELECT</literal> and the
+              <literal>INSERT</literal> refer to the same table, provide
+              a unique alias for each table used in the
+              <literal>SELECT</literal> part, and qualify column names
+              in that part with the appropriate alias.
+            </para>
+          </listitem>
+
         </itemizedlist>
 
         <para>


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-10-30 18:24:15 UTC (rev 3801)
+++ trunk/refman-5.0/sql-syntax.xml	2006-10-30 19:10:14 UTC (rev 3802)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 807 bytes

@@ -4469,6 +4469,17 @@
             </para>
           </listitem>
 
+          <listitem>
+            <para>
+              To avoid ambigious column reference problems when the
+              <literal>SELECT</literal> and the
+              <literal>INSERT</literal> refer to the same table, provide
+              a unique alias for each table used in the
+              <literal>SELECT</literal> part, and qualify column names
+              in that part with the appropriate alias.
+            </para>
+          </listitem>
+
         </itemizedlist>
 
         <para>


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-10-30 18:24:15 UTC (rev 3801)
+++ trunk/refman-5.1/sql-syntax.xml	2006-10-30 19:10:14 UTC (rev 3802)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 807 bytes

@@ -5885,6 +5885,17 @@
             </para>
           </listitem>
 
+          <listitem>
+            <para>
+              To avoid ambigious column reference problems when the
+              <literal>SELECT</literal> and the
+              <literal>INSERT</literal> refer to the same table, provide
+              a unique alias for each table used in the
+              <literal>SELECT</literal> part, and qualify column names
+              in that part with the appropriate alias.
+            </para>
+          </listitem>
+
         </itemizedlist>
 
         <para>