svn commit - mysqldoc@docsrva: r7454 - in trunk: refman-5.1 refman-5.2

[jon]

Author: jstephens
Date: 2007-08-15 10:53:39 +0200 (Wed, 15 Aug 2007)
New Revision: 7454

Log:

Event statement execution doesn't affect session statement counts, only
the global counts.

Fixes Docs Bug #16422 (Thanks, PeterG & Kostja!)



Modified:
   trunk/refman-5.1/events.xml
   trunk/refman-5.2/events.xml


Modified: trunk/refman-5.1/events.xml
===================================================================
--- trunk/refman-5.1/events.xml	2007-08-15 08:37:50 UTC (rev 7453)
+++ trunk/refman-5.1/events.xml	2007-08-15 08:53:39 UTC (rev 7454)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 2; 938 bytes

@@ -2015,10 +2015,14 @@
       <title>Effects on statement counts</title>
 
       <para>
-        Execution of event statements has no effect on the server's
+        Each execution of the statements contained in the body of an
+        event takes place in a new connection; thus, these statements
+        has no effect in a given user session on the server&ap;s
         statement counts such as <literal>Com_select</literal> and
         <literal>Com_insert</literal> that are displayed by
-        <literal>SHOW STATUS</literal>.
+        <literal>SHOW STATUS</literal>. However, such counts
+        <emphasis>are</emphasis> updated in the global scope. (Bug
+        #16422)
       </para>
 
     </formalpara>


Modified: trunk/refman-5.2/events.xml
===================================================================
--- trunk/refman-5.2/events.xml	2007-08-15 08:37:50 UTC (rev 7453)
+++ trunk/refman-5.2/events.xml	2007-08-15 08:53:39 UTC (rev 7454)
Changed blocks: 1, Lines Added: 6, Lines Deleted: 2; 938 bytes

@@ -1991,10 +1991,14 @@
       <title>Effects on statement counts</title>
 
       <para>
-        Execution of event statements has no effect on the server's
+        Each execution of the statements contained in the body of an
+        event takes place in a new connection; thus, these statements
+        has no effect in a given user session on the server&ap;s
         statement counts such as <literal>Com_select</literal> and
         <literal>Com_insert</literal> that are displayed by
-        <literal>SHOW STATUS</literal>.
+        <literal>SHOW STATUS</literal>. However, such counts
+        <emphasis>are</emphasis> updated in the global scope. (Bug
+        #16422)
       </para>
 
     </formalpara>