From: jon.stephens
Date: July 29 2009 10:51am
Subject: svn commit - mysqldoc@docsrva: r15851 - trunk/dynamic-docs/changelog
List-Archive: http://lists.mysql.com/commits/79515
Message-Id: <200907291051.n6TApf1W004715@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: jstephens
Date: 2009-07-29 12:51:41 +0200 (Wed, 29 Jul 2009)
New Revision: 15851

Log:

Documented fix for Partitioning Bug #45807



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


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2009-07-29 09:13:30 UTC (rev 15850)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2009-07-29 10:51:41 UTC (rev 15851)
Changed blocks: 1, Lines Added: 40, Lines Deleted: 0; 1274 bytes

@@ -9,6 +9,46 @@
   <logentry entrytype="bug">
 
     <tags>
+      <highlight type="securityfix"/>
+      <highlight type="partitioning"/>
+      <manual type="ONLY_FULL_GROUP_BY"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="45807"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.1.37"/>
+      <version ver="5.4.4"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Accessing a table having user-defined partitioning when the
+        server SQL mode included
+        <literal role="sqlmode">ONLY_FULL_GROUP_BY</literal> caused the
+        MySQL server to crash. For example, the following sequence of
+        statements crashed the server:
+      </para>
+
+<programlisting>
+DROP TABLE IF EXISTS t1;
+
+SET SESSION SQL_MODE='ONLY_FULL_GROUP_BY';
+
+CREATE TABLE t1 (id INT, KEY(id))
+    PARTITION BY HASH(id) PARTITIONS 2;
+</programlisting>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
       <highlight type="replication"/>
       <manual type="STOP SLAVE"/>
     </tags>