svn commit - mysqldoc@docsrva: r11288 - in trunk: . dynamic-docs/changelog refman-6.0

[paul]

Author: paul
Date: 2008-07-18 18:37:09 +0200 (Fri, 18 Jul 2008)
New Revision: 11288

Log:
 r32757@frost:  paul | 2008-07-18 11:38:05 -0500
 Documented bugfixes:
 Bug#25420: Tilde = 'Y' in Chinese
 Bug#27848: rollup in union part causes error with order of union
 Bug#32394: Character sets: crash if comparison with 0xfffd
 Bug#34529: Crash on complex Falcon I_S select after ALTER .. PARTITION BY


Modified:
   trunk/dynamic-docs/changelog/mysqld-1.xml
   trunk/refman-6.0/installing-core.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:32754
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:32322
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:32757
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:32322


Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml	2008-07-18 15:41:35 UTC (rev 11287)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml	2008-07-18 16:37:09 UTC (rev 11288)
Changed blocks: 1, Lines Added: 124, Lines Deleted: 0; 2991 bytes

@@ -21865,4 +21865,128 @@
 
   </logentry>
 
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="INFORMATION_SCHEMA"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="34529"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.60"/>
+      <version ver="5.1.24"/>
+      <version ver="6.0.5"/>
+    </versions>
+
+    <message>
+
+      <para>
+        A server crash could occur if
+        <literal>INFORMATION_SCHEMA</literal> tables built in memory
+        were swapped out to disk during query execution.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="UNION"/>
+      <manual type="ORDER BY"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="XXX"/>
+    </bugs>
+
+    <versions>
+      <version ver="5.0.56"/>
+      <version ver="5.1.23"/>
+      <version ver="6.0.5"/>
+    </versions>
+
+    <message>
+
+      <para>
+        An <literal>ORDER BY</literal> at the end of a
+        <literal>UNION</literal> affected individual
+        <literal>SELECT</literal> statements rather than the overall
+        query result.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <highlight type="incompatiblechange"/>
+      <manual type="utf8_general_ci"/>
+      <manual type="Unicode"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="25420"/>
+    </bugs>
+
+    <versions>
+      <version ver="6.0.6"/>
+    </versions>
+
+    <message ver="6.0.6">
+
+      <para>
+        Certain characters were sorted incorrectly for the following
+        collations: TILDE and GRAVE ACCENT in
+        <literal>big5_chinese_ci</literal>; LATIN SMALL LETTER J in
+        <literal>cp866_general_ci</literal>; TILDE in
+        <literal>gb2312_chinese_ci</literal>; and TILDE in
+        <literal>gbk_chinese_ci</literal>.
+      </para>
+
+      <para>
+        As a result of this fix, any indexes on columns that use these
+        collations and contain the affected characters must be rebuilt
+        when upgrading to 6.0.6 or higher. To do this, use
+        <literal>ALTER TABLE</literal> to drop and re-add the indexes,
+        or <command>mysqldump</command> to dump the affected tables and
+        <command>mysql</command> to reload the dump file.
+      </para>
+
+    </message>
+
+  </logentry>
+
+  <logentry entrytype="bug">
+
+    <tags>
+      <manual type="character sets"/>
+    </tags>
+
+    <bugs>
+      <fixes bugid="32394"/>
+    </bugs>
+
+    <versions>
+      <version ver="6.0.6"/>
+    </versions>
+
+    <message>
+
+      <para>
+        Conversion of binary values to multi-byte character sets could
+        fail to left-pad values to the correct length. This could result
+        in a server crash.
+      </para>
+
+    </message>
+
+  </logentry>
+
 </changelog>


Modified: trunk/refman-6.0/installing-core.xml
===================================================================
--- trunk/refman-6.0/installing-core.xml	2008-07-18 15:41:35 UTC (rev 11287)
+++ trunk/refman-6.0/installing-core.xml	2008-07-18 16:37:09 UTC (rev 11288)
Changed blocks: 1, Lines Added: 18, Lines Deleted: 0; 1535 bytes

@@ -12530,6 +12530,24 @@
         <listitem>
           <para>
             <emphasis role="bold">Incompatible change</emphasis>: In
+            MySQL 6.0.6, certain collations were fixed to correctly sort
+            the following characters: TILDE and GRAVE ACCENT in
+            <literal>big5_chinese_ci</literal>; LATIN SMALL LETTER J in
+            <literal>cp866_general_ci</literal>; TILDE in
+            <literal>gb2312_chinese_ci</literal>; and TILDE in
+            <literal>gbk_chinese_ci</literal>. As a result of this fix,
+            any indexes on columns that use these collations and contain
+            the affected characters must be rebuilt when upgrading to
+            6.0.6 or higher. To do this, use <literal>ALTER
+            TABLE</literal> to drop and re-add the indexes, or
+            <command>mysqldump</command> to dump the affected tables and
+            <command>mysql</command> to reload the dump file.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
+            <emphasis role="bold">Incompatible change</emphasis>: In
             MySQL 6.0.5, the <literal>utf8_general_ci</literal> and
             <literal>ucs2_general_ci</literal> collations were fixed to
             sort the letter "U+00DF SHARP S" equal to