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.1 | paul | 31 Jan |
