MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:paul Date:April 25 2006 5:00pm
Subject:svn commit - mysqldoc@docsrva: r1936 - in trunk: . refman-4.1 refman-5.0 refman-5.1
View as plain text  
Author: paul
Date: 2006-04-25 19:00:29 +0200 (Tue, 25 Apr 2006)
New Revision: 1936

Log:
 r9736@frost:  paul | 2006-04-25 11:59:01 -0500
 Document a locking restriction for CONVERT_TZ(). (Bug#9953)


Modified:
   trunk/
   trunk/refman-4.1/functions.xml
   trunk/refman-5.0/functions.xml
   trunk/refman-5.1/functions.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:6914
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:9732
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4590
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:6914
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:9736
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:4590

Modified: trunk/refman-4.1/functions.xml
===================================================================
--- trunk/refman-4.1/functions.xml	2006-04-25 15:47:32 UTC (rev 1935)
+++ trunk/refman-4.1/functions.xml	2006-04-25 17:00:29 UTC (rev 1936)
@@ -6019,6 +6019,13 @@
         <para>
           <literal>CONVERT_TZ()</literal> was added in MySQL 4.1.3.
         </para>
+
+        <para>
+          If you intend to use <literal>CONVERT_TZ()</literal> while
+          other tables are locked with <literal>LOCK TABLES</literal>,
+          you must also lock the <literal>mysql.time_zone_name</literal>
+          table.
+        </para>
       </listitem>
 
       <listitem>

Modified: trunk/refman-5.0/functions.xml
===================================================================
--- trunk/refman-5.0/functions.xml	2006-04-25 15:47:32 UTC (rev 1935)
+++ trunk/refman-5.0/functions.xml	2006-04-25 17:00:29 UTC (rev 1936)
@@ -6147,6 +6147,13 @@
           be properly set up. See <xref linkend="time-zone-support"/>,
           for instructions.
         </para>
+
+        <para>
+          If you intend to use <literal>CONVERT_TZ()</literal> while
+          other tables are locked with <literal>LOCK TABLES</literal>,
+          you must also lock the <literal>mysql.time_zone_name</literal>
+          table.
+        </para>
       </listitem>
 
       <listitem>

Modified: trunk/refman-5.1/functions.xml
===================================================================
--- trunk/refman-5.1/functions.xml	2006-04-25 15:47:32 UTC (rev 1935)
+++ trunk/refman-5.1/functions.xml	2006-04-25 17:00:29 UTC (rev 1936)
@@ -6107,6 +6107,13 @@
           be properly set up. See <xref linkend="time-zone-support"/>,
           for instructions.
         </para>
+
+        <para>
+          If you intend to use <literal>CONVERT_TZ()</literal> while
+          other tables are locked with <literal>LOCK TABLES</literal>,
+          you must also lock the <literal>mysql.time_zone_name</literal>
+          table.
+        </para>
       </listitem>
 
       <listitem>

Thread
svn commit - mysqldoc@docsrva: r1936 - in trunk: . refman-4.1 refman-5.0 refman-5.1paul25 Apr