List:Commits« Previous MessageNext Message »
From:paul Date:July 8 2008 8:30pm
Subject:svn commit - mysqldoc@docsrva: r11133 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0
View as plain text  
Author: paul
Date: 2008-07-08 20:30:09 +0200 (Tue, 08 Jul 2008)
New Revision: 11133

Log:
 r32013@arctic:  paul | 2008-07-08 13:28:48 -0500
 You need SELECT for columns read but not modified in INSERT ... ON DUPLICATE
 KEY UPDATE ...


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

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


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2008-07-08 18:29:54 UTC (rev 11132)
+++ trunk/refman-4.1/sql-syntax.xml	2008-07-08 18:30:09 UTC (rev 11133)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 925 bytes

@@ -4897,7 +4897,12 @@
         UPDATE</literal> clause is used and a duplicate key causes an
         <literal>UPDATE</literal> to be performed instead, the statement
         requires the <literal>UPDATE</literal> privilege for the columns
-        to be updated.
+        to be updated. For columns that are read but not modified you
+        need only the <literal>SELECT</literal> privilege (such as for a
+        column referenced only on the right hand side of an
+       
<replaceable>col_name</replaceable>=<replaceable>expr</replaceable>
+        assignment in an <literal>ON DUPLICATE KEY UPDATE</literal>
+        clause).
       </para>
 
       <section id="insert-select">


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2008-07-08 18:29:54 UTC (rev 11132)
+++ trunk/refman-5.0/sql-syntax.xml	2008-07-08 18:30:09 UTC (rev 11133)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 925 bytes

@@ -4951,7 +4951,12 @@
         UPDATE</literal> clause is used and a duplicate key causes an
         <literal>UPDATE</literal> to be performed instead, the statement
         requires the <literal>UPDATE</literal> privilege for the columns
-        to be updated.
+        to be updated. For columns that are read but not modified you
+        need only the <literal>SELECT</literal> privilege (such as for a
+        column referenced only on the right hand side of an
+       
<replaceable>col_name</replaceable>=<replaceable>expr</replaceable>
+        assignment in an <literal>ON DUPLICATE KEY UPDATE</literal>
+        clause).
       </para>
 
       <section id="insert-select">


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2008-07-08 18:29:54 UTC (rev 11132)
+++ trunk/refman-5.1/sql-syntax.xml	2008-07-08 18:30:09 UTC (rev 11133)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 925 bytes

@@ -7352,7 +7352,12 @@
         UPDATE</literal> clause is used and a duplicate key causes an
         <literal>UPDATE</literal> to be performed instead, the statement
         requires the <literal>UPDATE</literal> privilege for the columns
-        to be updated.
+        to be updated. For columns that are read but not modified you
+        need only the <literal>SELECT</literal> privilege (such as for a
+        column referenced only on the right hand side of an
+       
<replaceable>col_name</replaceable>=<replaceable>expr</replaceable>
+        assignment in an <literal>ON DUPLICATE KEY UPDATE</literal>
+        clause).
       </para>
 
       <section id="insert-select">


Modified: trunk/refman-6.0/sql-syntax.xml
===================================================================
--- trunk/refman-6.0/sql-syntax.xml	2008-07-08 18:29:54 UTC (rev 11132)
+++ trunk/refman-6.0/sql-syntax.xml	2008-07-08 18:30:09 UTC (rev 11133)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 1; 925 bytes

@@ -7239,7 +7239,12 @@
         UPDATE</literal> clause is used and a duplicate key causes an
         <literal>UPDATE</literal> to be performed instead, the statement
         requires the <literal>UPDATE</literal> privilege for the columns
-        to be updated.
+        to be updated. For columns that are read but not modified you
+        need only the <literal>SELECT</literal> privilege (such as for a
+        column referenced only on the right hand side of an
+       
<replaceable>col_name</replaceable>=<replaceable>expr</replaceable>
+        assignment in an <literal>ON DUPLICATE KEY UPDATE</literal>
+        clause).
       </para>
 
       <section id="insert-select">
Thread
• svn commit - mysqldoc@docsrva: r11133 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0paul8 Jul