List:Commits« Previous MessageNext Message »
From:stefan Date:January 4 2006 5:17pm
Subject:svn commit - mysqldoc@docsrva: r672 - trunk/refman-5.1
View as plain text  
Author: shinz
Date: 2006-01-04 18:17:03 +0100 (Wed, 04 Jan 2006)
New Revision: 672

Log:
Final tweaks to RBR sections

Modified:
   trunk/refman-5.1/replication.xml

Modified: trunk/refman-5.1/replication.xml
===================================================================
--- trunk/refman-5.1/replication.xml	2006-01-04 15:24:09 UTC (rev 671)
+++ trunk/refman-5.1/replication.xml	2006-01-04 17:17:03 UTC (rev 672)
@@ -4260,11 +4260,16 @@
 
         <listitem>
           <para>
-            Not all update statements can be replicated:
+            Not all <literal>UPDATE</literal> statements 
+            can be replicated:
             Any non-deterministic behavior, for example when
             using random functions in an SQL statement, is 
             hard to replicate when using statement-based
             replication.
+            When using a non-deterministic user-defined function (UDF), 
+            it is not possible to replicate the result using 
+            statement-based replication, while row-based replication 
+            will just replicate the value returned by the UDF. 
           </para>
         </listitem>
 
@@ -4392,6 +4397,11 @@
             as well as <literal>GRANT</literal> and 
             <literal>REVOKE</literal> statements, are replicated
             using row-based-replication.
+            For statements like 
+            <literal>CREATE &hellip; SELECT</literal>, a 
+            <literal>CREATE</literal> statement is generated from the 
+            table definition and replicated statement-based, while 
+            the row insertions are replicated row-based.
           </para>
         </listitem>
 

Thread
svn commit - mysqldoc@docsrva: r672 - trunk/refman-5.1stefan4 Jan