From: Date: October 17 2008 6:08pm
Subject: svn commit - mysqldoc@docsrva: r12087 - in trunk: refman-5.1 refman-6.0
List-Archive: http://lists.mysql.com/commits/56487
Message-Id: <200810171608.m9HG8cXr017971@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2008-10-17 18:08:37 +0200 (Fri, 17 Oct 2008)
New Revision: 12087

Log:

Update to replication-features-invoked to help address Bug #34597

(Thanks, Sveta and Mats!)



Modified:
   trunk/refman-5.1/replication-notes.xml
   trunk/refman-6.0/replication-notes.xml


Modified: trunk/refman-5.1/replication-notes.xml
===================================================================
--- trunk/refman-5.1/replication-notes.xml	2008-10-17 12:36:39 UTC (rev 12086)
+++ trunk/refman-5.1/replication-notes.xml	2008-10-17 16:08:37 UTC (rev 12087)
Changed blocks: 1, Lines Added: 23, Lines Deleted: 0; 1559 bytes

@@ -603,6 +603,29 @@
               created, modified, or dropped using these statements are
               replicated using row-based replication.
             </para>
+
+            <note>
+              <para>
+                Attempting to replicate invoked features using
+                statement-based replication produces the warning
+                <errortext>Statement is not safe to log in statement
+                format</errortext>. For example, trying to replicate a
+                UDF with statement-based replication generates this
+                warning because it currently cannot be determined by the
+                MySQL server whether the UDF is deterministic. If you
+                are absolutely certain that the invoked feature&apos;s
+                effects are deterministic, you can safely disregard such
+                warnings.
+              </para>
+
+              <para>
+                In a future MySQL release, we may implement ways for
+                users to indicate that such features are deterministic,
+                so that they can be recognized by the server as
+                <quote>safe</quote> for statement-based replication.
+                (Bug #34597)
+              </para>
+            </note>
           </listitem>
 
           <listitem>


Modified: trunk/refman-6.0/replication-notes.xml
===================================================================
--- trunk/refman-6.0/replication-notes.xml	2008-10-17 12:36:39 UTC (rev 12086)
+++ trunk/refman-6.0/replication-notes.xml	2008-10-17 16:08:37 UTC (rev 12087)
Changed blocks: 1, Lines Added: 23, Lines Deleted: 0; 1559 bytes

@@ -583,6 +583,29 @@
               created, modified, or dropped using these statements are
               replicated using row-based replication.
             </para>
+
+            <note>
+              <para>
+                Attempting to replicate invoked features using
+                statement-based replication produces the warning
+                <errortext>Statement is not safe to log in statement
+                format</errortext>. For example, trying to replicate a
+                UDF with statement-based replication generates this
+                warning because it currently cannot be determined by the
+                MySQL server whether the UDF is deterministic. If you
+                are absolutely certain that the invoked feature&apos;s
+                effects are deterministic, you can safely disregard such
+                warnings.
+              </para>
+
+              <para>
+                In a future MySQL release, we may implement ways for
+                users to indicate that such features are deterministic,
+                so that they can be recognized by the server as
+                <quote>safe</quote> for statement-based replication.
+                (Bug #34597)
+              </para>
+            </note>
           </listitem>
 
           <listitem>