svn commit - mysqldoc@docsrva: r24742 - trunk/dynamic-docs/changelog

[jon.stephens]

Author: jstephens
Date: 2011-01-08 02:11:01 +0100 (Sat, 08 Jan 2011)
New Revision: 24742

Log:

Changelog entry: Fix for replication BUG#50914



Modified:
   trunk/dynamic-docs/changelog/mysqld-2.xml


Modified: trunk/dynamic-docs/changelog/mysqld-2.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-2.xml	2011-01-07 23:46:22 UTC (rev 24741)
+++ trunk/dynamic-docs/changelog/mysqld-2.xml	2011-01-08 01:11:01 UTC (rev 24742)
Changed blocks: 1, Lines Added: 58, Lines Deleted: 0; 1993 bytes

@@ -6,6 +6,64 @@
 ]>
 <changelog>
 
+  <logentry entrytype="bug">
+
+    <tags>
+      <highlight type="replication"/>
+      <manual type="mysqlbinlog"/>
+      <manual type="DROP DATABASE"/>
+      <manual type="USE"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="50914"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.55"/>
+      <version ver="5.5.9"/>
+      <version ver="5.6.2"/>
+    </versions>
+
+    <message>
+
+      <para>
+        <command>mysqlbinlog</command> printed
+        <literal role="stmt">USE</literal> statements to its output only
+        when the default database changed between events. To illustrate
+        how this could cause problems, suppose that a user issued the
+        following sequence of statements:
+      </para>
+
+<programlisting>
+CREATE DATABASE mydb;
+USE mydb;
+CREATE TABLE mytable (<replaceable>column_definitions</replaceable>);
+DROP DATABASE mydb;
+CREATE DATABASE mydb;
+USE mydb;
+CREATE TABLE mytable (<replaceable>column_definitions</replaceable>);
+</programlisting>
+
+      <para>
+        When played back using <command>mysqlbinlog</command>, the
+        second <literal role="stmt">CREATE TABLE</literal> statement
+        failed with <errortext>Error: No Database Selected</errortext>
+        because the second <literal role="stmt">USE</literal> statement
+        was not played back, due to the fact that a database other than
+        <literal>mydb</literal> was never selected.
+      </para>
+
+      <para>
+        This fix insures that <command>mysqlbinlog</command> outputs a
+        <literal role="stmt">USE</literal> statement whenever it reads
+        one from the binary log.
+      </para>
+
+    </message>
+
+  </logentry>
+
   <logentry entrytype="feature">
 
     <tags>