List:Commits« Previous MessageNext Message »
From:paul Date:December 19 2006 7:15pm
Subject:svn commit - mysqldoc@docsrva: r4307 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2006-12-19 20:15:06 +0100 (Tue, 19 Dec 2006)
New Revision: 4307

Log:
 r17360@polar:  paul | 2006-12-19 13:11:41 -0600
 CREATE TEMPORARY TABLE doesn't cause implicit commit. (Bug#24501)


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

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


Modified: trunk/refman-4.1/se-innodb.xml
===================================================================
--- trunk/refman-4.1/se-innodb.xml	2006-12-19 19:14:51 UTC (rev 4306)
+++ trunk/refman-4.1/se-innodb.xml	2006-12-19 19:15:06 UTC (rev 4307)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 751 bytes

@@ -4542,6 +4542,16 @@
           </para>
         </listitem>
 
+        <listitem>
+          <para>
+            <literal>CREATE TABLE</literal> and <literal>DROP
+            TABLE</literal> do not commit a transaction if the
+            <literal>TEMPOARY</literal> keyword is used. (This does not
+            apply to other operations on temporary tables such as
+            <literal>CREATE INDEX</literal>, which do cause a commit.)
+          </para>
+        </listitem>
+
       </itemizedlist>
 
       <para>


Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml	2006-12-19 19:14:51 UTC (rev 4306)
+++ trunk/refman-4.1/sql-syntax.xml	2006-12-19 19:15:06 UTC (rev 4307)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 0; 1242 bytes

@@ -1473,6 +1473,12 @@
       </para>
 
       <para>
+        <emphasis role="bold">Note</emphasis>: <literal>CREATE
+        TABLE</literal> does not automatically commit the current active
+        transaction if you use the <literal>TEMPORARY</literal> keyword.
+      </para>
+
+      <para>
         In MySQL 3.23 or later, the keywords <literal>IF NOT
         EXISTS</literal> prevent an error from occurring if the table
         exists. However, there is no verification that the existing

@@ -10304,6 +10310,16 @@
           </para>
         </listitem>
 
+        <listitem>
+          <para>
+            <literal>CREATE TABLE</literal> and <literal>DROP
+            TABLE</literal> do not commit a transaction if the
+            <literal>TEMPOARY</literal> keyword is used. (This does not
+            apply to other operations on temporary tables such as
+            <literal>CREATE INDEX</literal>, which do cause a commit.)
+          </para>
+        </listitem>
+
       </itemizedlist>
 
       <para>


Modified: trunk/refman-5.0/se-innodb.xml
===================================================================
--- trunk/refman-5.0/se-innodb.xml	2006-12-19 19:14:51 UTC (rev 4306)
+++ trunk/refman-5.0/se-innodb.xml	2006-12-19 19:15:06 UTC (rev 4307)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 0; 915 bytes

@@ -4508,6 +4508,16 @@
 
         <listitem>
           <para>
+            <literal>CREATE TABLE</literal> and <literal>DROP
+            TABLE</literal> do not commit a transaction if the
+            <literal>TEMPOARY</literal> keyword is used. (This does not
+            apply to other operations on temporary tables such as
+            <literal>CREATE INDEX</literal>, which do cause a commit.)
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             Prior to MySQL 5.0.26, <literal>LOAD DATA INFILE</literal>
             also caused an implicit commit for <literal>InnoDB</literal>
             tables (as was true for all storage engines).


Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml	2006-12-19 19:14:51 UTC (rev 4306)
+++ trunk/refman-5.0/sql-syntax.xml	2006-12-19 19:15:06 UTC (rev 4307)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 0; 1415 bytes

@@ -1509,6 +1509,12 @@
       </para>
 
       <para>
+        <emphasis role="bold">Note</emphasis>: <literal>CREATE
+        TABLE</literal> does not automatically commit the current active
+        transaction if you use the <literal>TEMPORARY</literal> keyword.
+      </para>
+
+      <para>
         The keywords <literal>IF NOT EXISTS</literal> prevent an error
         from occurring if the table exists. However, there is no
         verification that the existing table has a structure identical

@@ -11011,6 +11017,16 @@
 
         <listitem>
           <para>
+            <literal>CREATE TABLE</literal> and <literal>DROP
+            TABLE</literal> do not commit a transaction if the
+            <literal>TEMPOARY</literal> keyword is used. (This does not
+            apply to other operations on temporary tables such as
+            <literal>CREATE INDEX</literal>, which do cause a commit.)
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             In MySQL 5.0.25 and earlier, <literal>LOAD DATA
             INFILE</literal> caused an implicit commit for all storage
             engines. Beginning with MySQL 5.0.26, it causes an implicit


Modified: trunk/refman-5.1/se-innodb.xml
===================================================================
--- trunk/refman-5.1/se-innodb.xml	2006-12-19 19:14:51 UTC (rev 4306)
+++ trunk/refman-5.1/se-innodb.xml	2006-12-19 19:15:06 UTC (rev 4307)
Changed blocks: 1, Lines Added: 15, Lines Deleted: 3; 1328 bytes

@@ -4471,12 +4471,24 @@
 
         <listitem>
           <para>
-            Prior to MySQL 5.1.12, <literal>LOAD DATA INFILE</literal>
-            also caused an implicit commit for <literal>InnoDB</literal>
-            tables (as was true for all storage engines).
+            <literal>CREATE TABLE</literal> and <literal>DROP
+            TABLE</literal> do not commit a transaction if the
+            <literal>TEMPOARY</literal> keyword is used. (This does not
+            apply to other operations on temporary tables such as
+            <literal>CREATE INDEX</literal>, which do cause a commit.)
           </para>
         </listitem>
 
+        <listitem>
+          <para>
+            In MySQL 5.1.11 and earlier, <literal>LOAD DATA
+            INFILE</literal> caused an implicit commit for all storage
+            engines. Beginning with MySQL 5.1.12, it causes an implicit
+            commit only for tables using the <literal>NDB</literal>
+            storage engine. For more information, see Bug #11151.
+          </para>
+        </listitem>
+
       </itemizedlist>
 
       <para>


Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml	2006-12-19 19:14:51 UTC (rev 4306)
+++ trunk/refman-5.1/sql-syntax.xml	2006-12-19 19:15:06 UTC (rev 4307)
Changed blocks: 2, Lines Added: 16, Lines Deleted: 0; 1415 bytes

@@ -2121,6 +2121,12 @@
       </para>
 
       <para>
+        <emphasis role="bold">Note</emphasis>: <literal>CREATE
+        TABLE</literal> does not automatically commit the current active
+        transaction if you use the <literal>TEMPORARY</literal> keyword.
+      </para>
+
+      <para>
         The keywords <literal>IF NOT EXISTS</literal> prevent an error
         from occurring if the table exists. However, there is no
         verification that the existing table has a structure identical

@@ -12350,6 +12356,16 @@
 
         <listitem>
           <para>
+            <literal>CREATE TABLE</literal> and <literal>DROP
+            TABLE</literal> do not commit a transaction if the
+            <literal>TEMPOARY</literal> keyword is used. (This does not
+            apply to other operations on temporary tables such as
+            <literal>CREATE INDEX</literal>, which do cause a commit.)
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             In MySQL 5.1.11 and earlier, <literal>LOAD DATA
             INFILE</literal> caused an implicit commit for all storage
             engines. Beginning with MySQL 5.1.12, it causes an implicit


Thread
svn commit - mysqldoc@docsrva: r4307 - in trunk: . refman-4.1 refman-5.0 refman-5.1paul19 Dec