Author: paul
Date: 2008-12-04 21:35:24 +0100 (Thu, 04 Dec 2008)
New Revision: 12786
Log:
r36460@frost: paul | 2008-12-04 14:23:29 -0500
Document bugfix:
Bug#40021: Renaming view fails, archived .frm for view is missing after downgrade
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:36455
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:35020
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:39854
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:36460
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:35020
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-12-04 20:35:09 UTC (rev 12785)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-12-04 20:35:24 UTC (rev 12786)
Changed blocks: 4, Lines Added: 117, Lines Deleted: 0; 3671 bytes
@@ -32436,10 +32436,90 @@
</bugs>
<versions>
+ <version ver="5.0.72"/>
<version ver="5.1.29"/>
<version ver="6.0.8"/>
</versions>
+ <message ver="5.0.72">
+
+ <para>
+ In connection with view creation, the server created
+ <filename>arc</filename> directories inside database directories
+ and maintained useless copies of <filename>.frm</filename> files
+ there. Creation and renaming procedures of those copies as well
+ as creation of <filename>arc</filename> directories has been
+ discontinued.
+ </para>
+
+ <para>
+ This change does cause a problem when downgrading to older
+ server versions which manifests itself under these
+ circumstances:
+ </para>
+
+ <orderedlist>
+
+ <listitem>
+ <para>
+ Create a view <literal>v_orig</literal> in MySQL 5.0.72 or
+ higher.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Rename the view to <literal>v_new</literal> and then back to
+ <literal>v_orig</literal>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Downgrade to an older 5.0.x server and run
+ <command>mysql_upgrade</command>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Try to rename <literal>v_orig</literal> to
+ <literal>v_new</literal> again. This operation fails.
+ </para>
+ </listitem>
+
+ </orderedlist>
+
+ <para>
+ As a workaround to avoid this problem, use either of these
+ approaches:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ Dump your data using <command>mysqldump</command> before
+ downgrading and reload the dump file after downgrading.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Instead of renaming a view after the downgrade, drop it and
+ recreate it.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The downgrade problem introduced by the fix for this bug has
+ been addressed as Bug#40021.
+ </para>
+
+ </message>
+
<message ver="5.1.29">
<para>
@@ -32512,6 +32592,11 @@
</itemizedlist>
+ <para>
+ The downgrade problem introduced by the fix for this bug has
+ been addressed as Bug#40021.
+ </para>
+
</message>
<message ver="6.0.8">
@@ -32586,6 +32671,11 @@
</itemizedlist>
+ <para>
+ The downgrade problem introduced by the fix for this bug has
+ been addressed as Bug#40021.
+ </para>
+
</message>
</logentry>
@@ -32594,6 +32684,33 @@
<tags>
<manual type="views"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="40021"/>
+ <seealsobug bugid="17823"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.74"/>
+ </versions>
+
+ <message>
+
+ <para>
+ Support for the <literal>revision</literal> field in
+ <filename>.frm</filename> files has been removed. This addresses
+ the downgrading problem introduced by the fix for Bug#17823.
+ </para>
+
+ </message>
+
+ </logentry>
+
+ <logentry entrytype="bug">
+
+ <tags>
+ <manual type="views"/>
<manual type="INFORMATION_SCHEMA"/>
<manual type="SHOW CREATE VIEW"/>
<manual type="privileges"/>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r12786 - in trunk: . dynamic-docs/changelog | paul.dubois | 4 Dec |
