List:Commits« Previous MessageNext Message »
From:paul Date:January 31 2006 2:16pm
Subject:svn commit - mysqldoc@docsrva: r1148 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2006-01-31 15:16:40 +0100 (Tue, 31 Jan 2006)
New Revision: 1148

Log:
 r6971@frost:  paul | 2006-01-31 08:13:58 -0600
 Update description for START TRANSACTION WITH CONSISTENT SNAPSHOT.


Modified:
   trunk/
   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
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6970
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2719
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:6971
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2719

Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2006-01-31 14:15:01 UTC (rev 1147)
+++ trunk/refman-4.1/sql-syntax.xml	2006-01-31 14:16:40 UTC (rev 1148)
@@ -9393,6 +9393,7 @@
 
       <remark role="help-keywords">
         START TRANSACTION BEGIN WORK COMMIT ROLLBACK SET AUTOCOMMIT
+        CONSISTENT SNAPSHOT
       </remark>
 
       <remark role="help-syntax"/>
@@ -9493,6 +9494,14 @@
       </para>
 
       <para>
+        The <literal>WITH CONSISTENT SNAPSHOT</literal> clause does not
+        change the current transaction isolation level, so it provides a
+        consistent snapshot only if the current isolation level is one
+        that allows consistent read (<literal>REPEATABLE READ</literal>
+        or <literal>SERIALIZABLE</literal>).
+      </para>
+
+      <para>
         Beginning a transaction causes an implicit <literal>UNLOCK
         TABLES</literal> to be performed.
       </para>

Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-01-31 14:15:01 UTC (rev 1147)
+++ trunk/refman-5.0/sql-syntax.xml	2006-01-31 14:16:40 UTC (rev 1148)
@@ -9747,7 +9747,7 @@
 
       <remark role="help-keywords">
         START TRANSACTION BEGIN WORK COMMIT ROLLBACK SET AUTOCOMMIT
-        CHAIN RELEASE
+        CHAIN RELEASE CONSISTENT SNAPSHOT
       </remark>
 
       <remark role="help-syntax"/>
@@ -9879,6 +9879,14 @@
       </para>
 
       <para>
+        The <literal>WITH CONSISTENT SNAPSHOT</literal> clause does not
+        change the current transaction isolation level, so it provides a
+        consistent snapshot only if the current isolation level is one
+        that allows consistent read (<literal>REPEATABLE READ</literal>
+        or <literal>SERIALIZABLE</literal>).
+      </para>
+
+      <para>
         Beginning a transaction causes an implicit <literal>UNLOCK
         TABLES</literal> to be performed.
       </para>

Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-01-31 14:15:01 UTC (rev 1147)
+++ trunk/refman-5.1/sql-syntax.xml	2006-01-31 14:16:40 UTC (rev 1148)
@@ -10313,7 +10313,7 @@
 
       <remark role="help-keywords">
         START TRANSACTION BEGIN WORK COMMIT ROLLBACK SET AUTOCOMMIT
-        CHAIN RELEASE
+        CHAIN RELEASE CONSISTENT SNAPSHOT
       </remark>
 
       <remark role="help-syntax"/>
@@ -10444,6 +10444,14 @@
       </para>
 
       <para>
+        The <literal>WITH CONSISTENT SNAPSHOT</literal> clause does not
+        change the current transaction isolation level, so it provides a
+        consistent snapshot only if the current isolation level is one
+        that allows consistent read (<literal>REPEATABLE READ</literal>
+        or <literal>SERIALIZABLE</literal>).
+      </para>
+
+      <para>
         Beginning a transaction causes an implicit <literal>UNLOCK
         TABLES</literal> to be performed.
       </para>

Thread
svn commit - mysqldoc@docsrva: r1148 - in trunk: . refman-4.1 refman-5.0 refman-5.1paul31 Jan