Author: paul
Date: 2006-04-06 21:42:32 +0200 (Thu, 06 Apr 2006)
New Revision: 1747
Log:
r4334@kite-hub: paul | 2006-04-06 14:39:08 -0500
LOAD DATA INFILE causes implicit commit as of MySQL 5.0. (Bug#11151)
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:9272
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4333
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:9272
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4334
Modified: trunk/refman-4.1/sql-syntax.xml
===================================================================
--- trunk/refman-4.1/sql-syntax.xml 2006-04-06 19:42:10 UTC (rev 1746)
+++ trunk/refman-4.1/sql-syntax.xml 2006-04-06 19:42:32 UTC (rev 1747)
@@ -9659,6 +9659,11 @@
<literal>COMMIT</literal> before executing the statement:
</para>
+ <remark role="note">
+ LOAD DATA INFILE does not appear in this list because it does
+ not cause a commit until MySQL 5.0.
+ </remark>
+
<itemizedlist>
<listitem>
Modified: trunk/refman-5.0/sql-syntax.xml
===================================================================
--- trunk/refman-5.0/sql-syntax.xml 2006-04-06 19:42:10 UTC (rev 1746)
+++ trunk/refman-5.0/sql-syntax.xml 2006-04-06 19:42:32 UTC (rev 1747)
@@ -10324,10 +10324,11 @@
FUNCTION</literal>, <literal>DROP INDEX</literal>,
<literal>DROP PROCEDURE</literal>, <literal>DROP
TABLE</literal>, <literal>LOAD MASTER DATA</literal>,
- <literal>LOCK TABLES</literal>, <literal>RENAME
- TABLE</literal>, <literal>SET AUTOCOMMIT=1</literal>,
- <literal>START TRANSACTION</literal>, <literal>TRUNCATE
- TABLE</literal>, <literal>UNLOCK TABLES</literal>.
+ <literal>LOCK TABLES</literal>, <literal>LOAD DATA
+ INFILE</literal>, <literal>RENAME TABLE</literal>,
+ <literal>SET AUTOCOMMIT=1</literal>, <literal>START
+ TRANSACTION</literal>, <literal>TRUNCATE TABLE</literal>,
+ <literal>UNLOCK TABLES</literal>.
</para>
</listitem>
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-04-06 19:42:10 UTC (rev 1746)
+++ trunk/refman-5.1/sql-syntax.xml 2006-04-06 19:42:32 UTC (rev 1747)
@@ -11527,10 +11527,11 @@
FUNCTION</literal>, <literal>DROP INDEX</literal>,
<literal>DROP PROCEDURE</literal>, <literal>DROP
TABLE</literal>, <literal>LOAD MASTER DATA</literal>,
- <literal>LOCK TABLES</literal>, <literal>RENAME
- TABLE</literal>, <literal>SET AUTOCOMMIT=1</literal>,
- <literal>START TRANSACTION</literal>, <literal>TRUNCATE
- TABLE</literal>, <literal>UNLOCK TABLES</literal>.
+ <literal>LOCK TABLES</literal>, <literal>LOAD DATA
+ INFILE</literal>, <literal>RENAME TABLE</literal>,
+ <literal>SET AUTOCOMMIT=1</literal>, <literal>START
+ TRANSACTION</literal>, <literal>TRUNCATE TABLE</literal>,
+ <literal>UNLOCK TABLES</literal>.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1747 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 6 Apr |
