List:Commits« Previous MessageNext Message »
From:jon Date:September 15 2008 5:37pm
Subject:svn commit - mysqldoc@docsrva: r11821 - in trunk: refman-5.1 refman-6.0
View as plain text  
Author: jstephens
Date: 2008-09-15 19:37:50 +0200 (Mon, 15 Sep 2008)
New Revision: 11821

Log:

Fix Docs Bug #39163 (event timing metadata)



Modified:
   trunk/refman-5.1/events.xml
   trunk/refman-5.1/information-schema.xml
   trunk/refman-5.1/sql-syntax-server-administration.xml
   trunk/refman-6.0/events.xml
   trunk/refman-6.0/information-schema.xml
   trunk/refman-6.0/sql-syntax-server-administration.xml


Modified: trunk/refman-5.1/events.xml
===================================================================
--- trunk/refman-5.1/events.xml	2008-09-15 17:15:17 UTC (rev 11820)
+++ trunk/refman-5.1/events.xml	2008-09-15 17:37:50 UTC (rev 11821)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 486 bytes

@@ -840,7 +840,7 @@
       EVENT_TYPE: RECURRING
       EXECUTE_AT: NULL
   INTERVAL_VALUE: 5
-  INTERVAL_FIELD: INTERVAL_SECOND
+  INTERVAL_FIELD: SECOND
         SQL_MODE: NULL
           STARTS: 0000-00-00 00:00:00
             ENDS: 0000-00-00 00:00:00


Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml	2008-09-15 17:15:17 UTC (rev 11820)
+++ trunk/refman-5.1/information-schema.xml	2008-09-15 17:37:50 UTC (rev 11821)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 5; 1460 bytes

@@ -4363,13 +4363,21 @@
           <literal>INTERVAL_FIELD</literal>: For recurring events, this
           column contains the units portion of the
           <literal>EVERY</literal> clause governing the timing of the
-          event, prefixed with '<literal>INTERVAL_</literal>'. Thus,
-          this column contains a value such as
-          '<literal>INTERVAL_YEAR</literal>',
-          '<literal>INTERVAL_QUARTER</literal>',
-          '<literal>INTERVAL_DAY</literal>', and so on.
+          event. Thus, this column contains a value such as
+          '<literal>YEAR</literal>', '<literal>QUARTER</literal>',
+          '<literal>DAY</literal>', and so on.
         </para>
 
+        <note>
+          <para>
+            In early MySQL 5.1 releases, this value was prefixed with
+            '<literal>INTERVAL_</literal>', and was displayed as
+            '<literal>INTERVAL_YEAR</literal>',
+            '<literal>INTERVAL_QUARTER</literal>',
+            '<literal>INTERVAL_DAY</literal>', and so on.
+          </para>
+        </note>
+
         <para>
           For a one-time event (that is, an event whose timing is
           determined by an <literal>AT</literal> clause), this column's


Modified: trunk/refman-5.1/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-5.1/sql-syntax-server-administration.xml	2008-09-15 17:15:17 UTC (rev 11820)
+++ trunk/refman-5.1/sql-syntax-server-administration.xml	2008-09-15 17:37:50 UTC (rev 11821)
Changed blocks: 8, Lines Added: 15, Lines Deleted: 9; 3293 bytes

@@ -42,7 +42,8 @@
         In a production environment it is always prudent to examine any
         changes to users' accounts. The MySQL Enterprise Monitor
         provides notification whenever users' privileges are altered.
-        For more information, see <ulink url="&base-url-enterprise;advisors.html"/>.
+        For more information, see
+        <ulink url="&base-url-enterprise;advisors.html"/>.
       </para>
 
     </formalpara>

@@ -320,7 +321,8 @@
         <para>
           For automated notification of users with inappropriate
           privileges, subscribe to the MySQL Enterprise Monitor. For
-          more information, see <ulink url="&base-url-enterprise;advisors.html"/>.
+          more information, see
+          <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
 
       </formalpara>

@@ -1024,7 +1026,8 @@
           MySQL server. Subscribers to the MySQL Enterprise Monitor are
           alerted when servers are started without the
           <option>--skip-show-database</option> option. For more
-          information, see <ulink url="&base-url-enterprise;advisors.html"/>.
+          information, see
+          <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
 
       </formalpara>

@@ -1688,7 +1691,8 @@
         <para>
           For automated notification of users without passwords,
           subscribe to the MySQL Enterprise Monitor. For more
-          information see <ulink url="&base-url-enterprise;advisors.html"/>.
+          information see
+          <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
 
       </formalpara>

@@ -3477,7 +3481,8 @@
       <para>
         The MySQL Enterprise Monitor makes extensive use of system
         variables to determine the state of your server. For more
-        information see <ulink url="&base-url-enterprise;advisors.html"/>.
+        information see
+        <ulink url="&base-url-enterprise;advisors.html"/>.
       </para>
 
     </formalpara>

@@ -5520,7 +5525,8 @@
           statement provides valuable information about the state of
           your server. For expert interpretation of this information,
           subscribe to the MySQL Enterprise Monitor. For more
-          information see <ulink url="&base-url-enterprise;advisors.html"/>.
+          information see
+          <ulink url="&base-url-enterprise;advisors.html"/>.
         </para>
 
       </formalpara>

@@ -5803,7 +5809,7 @@
                 Type: RECURRING
           Execute at: NULL
       Interval value: 10
-      Interval field: INTERVAL_SECOND
+      Interval field: SECOND
               Starts: 2006-02-09 10:41:23
                 Ends: 0000-00-00 00:00:00
               Status: ENABLED

@@ -8397,8 +8403,8 @@
 
       <para>
         For the trigger <literal>ins_sum</literal> as defined in
-        <xref linkend="triggers"/>, the output of this statement
-        is as shown here:
+        <xref linkend="triggers"/>, the output of this statement is as
+        shown here:
       </para>
 
 <programlisting>


Modified: trunk/refman-6.0/events.xml
===================================================================
--- trunk/refman-6.0/events.xml	2008-09-15 17:15:17 UTC (rev 11820)
+++ trunk/refman-6.0/events.xml	2008-09-15 17:37:50 UTC (rev 11821)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 486 bytes

@@ -762,7 +762,7 @@
       EVENT_TYPE: RECURRING
       EXECUTE_AT: NULL
   INTERVAL_VALUE: 5
-  INTERVAL_FIELD: INTERVAL_SECOND
+  INTERVAL_FIELD: SECOND
         SQL_MODE: NULL
           STARTS: 0000-00-00 00:00:00
             ENDS: 0000-00-00 00:00:00


Modified: trunk/refman-6.0/information-schema.xml
===================================================================
--- trunk/refman-6.0/information-schema.xml	2008-09-15 17:15:17 UTC (rev 11820)
+++ trunk/refman-6.0/information-schema.xml	2008-09-15 17:37:50 UTC (rev 11821)
Changed blocks: 1, Lines Added: 3, Lines Deleted: 5; 962 bytes

@@ -4410,11 +4410,9 @@
           <literal>INTERVAL_FIELD</literal>: For recurring events, this
           column contains the units portion of the
           <literal>EVERY</literal> clause governing the timing of the
-          event, prefixed with '<literal>INTERVAL_</literal>'. Thus,
-          this column contains a value such as
-          '<literal>INTERVAL_YEAR</literal>',
-          '<literal>INTERVAL_QUARTER</literal>',
-          '<literal>INTERVAL_DAY</literal>', and so on.
+          event. Thus, this column contains a value such as
+          '<literal>YEAR</literal>', '<literal>QUARTER</literal>',
+          '<literal>DAY</literal>', and so on.
         </para>
 
         <para>


Modified: trunk/refman-6.0/sql-syntax-server-administration.xml
===================================================================
--- trunk/refman-6.0/sql-syntax-server-administration.xml	2008-09-15 17:15:17 UTC (rev 11820)
+++ trunk/refman-6.0/sql-syntax-server-administration.xml	2008-09-15 17:37:50 UTC (rev 11821)
Changed blocks: 2, Lines Added: 3, Lines Deleted: 3; 916 bytes

@@ -5848,7 +5848,7 @@
                 Type: RECURRING
           Execute at: NULL
       Interval value: 10
-      Interval field: INTERVAL_SECOND
+      Interval field: SECOND
               Starts: 2006-02-09 10:41:23
                 Ends: 0000-00-00 00:00:00
               Status: ENABLED

@@ -8608,8 +8608,8 @@
 
       <para>
         For the trigger <literal>ins_sum</literal> as defined in
-        <xref linkend="triggers"/>, the output of this statement
-        is as shown here:
+        <xref linkend="triggers"/>, the output of this statement is as
+        shown here:
       </para>
 
 <programlisting>


Thread
svn commit - mysqldoc@docsrva: r11821 - in trunk: refman-5.1 refman-6.0jon15 Sep