Author: paul
Date: 2006-07-31 21:59:44 +0200 (Mon, 31 Jul 2006)
New Revision: 2907
Log:
r9384@kite-hub: paul | 2006-07-31 14:56:45 -0500
LOCK TABLES does not lock views.
Modified:
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:12204
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:13080
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:9313
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:12204
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:13080
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:9384
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-07-31 14:28:09 UTC (rev 2906)
+++ trunk/refman-5.0/sql-syntax.xml 2006-07-31 19:59:44 UTC (rev 2907)
Changed blocks: 2, Lines Added: 17, Lines Deleted: 14; 2532 bytes
@@ -11058,14 +11058,14 @@
<remark role="help-description-begin"/>
<para>
- <literal>LOCK TABLES</literal> locks tables for the current
- thread. If any of the tables are locked by other threads, it
- blocks until all locks can be acquired. <literal>UNLOCK
- TABLES</literal> releases any locks held by the current thread.
- All tables that are locked by the current thread are implicitly
- unlocked when the thread issues another <literal>LOCK
- TABLES</literal>, or when the connection to the server is
- closed.
+ <literal>LOCK TABLES</literal> locks base tables (but not views)
+ for the current thread. If any of the tables are locked by other
+ threads, it blocks until all locks can be acquired.
+ <literal>UNLOCK TABLES</literal> releases any locks held by the
+ current thread. All tables that are locked by the current thread
+ are implicitly unlocked when the thread issues another
+ <literal>LOCK TABLES</literal>, or when the connection to the
+ server is closed.
</para>
<para>
@@ -11166,12 +11166,15 @@
<para>
When you use <literal>LOCK TABLES</literal>, you must lock all
- tables that you are going to use in your queries. While the
- locks obtained with a <literal>LOCK TABLES</literal> statement
- are in effect, you cannot access any tables that were not locked
- by the statement. Also, you cannot use a locked table multiple
- times in a single query. Use aliases instead, in which case you
- must obtain a lock for each alias separately.
+ tables that you are going to use in your queries. Because
+ <literal>LOCK TABLES</literal> will not lock views, if the
+ operation that you are performing uses any views, you must also
+ lock all of the base tables on which those views depend. While
+ the locks obtained with a <literal>LOCK TABLES</literal>
+ statement are in effect, you cannot access any tables that were
+ not locked by the statement. Also, you cannot use a locked table
+ multiple times in a single query. Use aliases instead, in which
+ case you must obtain a lock for each alias separately.
</para>
<programlisting>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-07-31 14:28:09 UTC (rev 2906)
+++ trunk/refman-5.1/sql-syntax.xml 2006-07-31 19:59:44 UTC (rev 2907)
Changed blocks: 2, Lines Added: 17, Lines Deleted: 14; 2532 bytes
@@ -12352,14 +12352,14 @@
<remark role="help-description-begin"/>
<para>
- <literal>LOCK TABLES</literal> locks tables for the current
- thread. If any of the tables are locked by other threads, it
- blocks until all locks can be acquired. <literal>UNLOCK
- TABLES</literal> releases any locks held by the current thread.
- All tables that are locked by the current thread are implicitly
- unlocked when the thread issues another <literal>LOCK
- TABLES</literal>, or when the connection to the server is
- closed.
+ <literal>LOCK TABLES</literal> locks base tables (but not views)
+ for the current thread. If any of the tables are locked by other
+ threads, it blocks until all locks can be acquired.
+ <literal>UNLOCK TABLES</literal> releases any locks held by the
+ current thread. All tables that are locked by the current thread
+ are implicitly unlocked when the thread issues another
+ <literal>LOCK TABLES</literal>, or when the connection to the
+ server is closed.
</para>
<para>
@@ -12454,12 +12454,15 @@
<para>
When you use <literal>LOCK TABLES</literal>, you must lock all
- tables that you are going to use in your queries. While the
- locks obtained with a <literal>LOCK TABLES</literal> statement
- are in effect, you cannot access any tables that were not locked
- by the statement. Also, you cannot use a locked table multiple
- times in a single query. Use aliases instead, in which case you
- must obtain a lock for each alias separately.
+ tables that you are going to use in your queries. Because
+ <literal>LOCK TABLES</literal> will not lock views, if the
+ operation that you are performing uses any views, you must also
+ lock all of the base tables on which those views depend. While
+ the locks obtained with a <literal>LOCK TABLES</literal>
+ statement are in effect, you cannot access any tables that were
+ not locked by the statement. Also, you cannot use a locked table
+ multiple times in a single query. Use aliases instead, in which
+ case you must obtain a lock for each alias separately.
</para>
<programlisting>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r2907 - in trunk: . refman-5.0 refman-5.1 | paul | 31 Jul |
