MySQL Forums
Forum List  »  Merge Storage Engine

Re: upgrade from 4.1 to 5.0.1.8 - Merge Tables are not identically defined.
Posted by: Ingo Strüwing
Date: February 24, 2006 08:26AM

I will soon start working on a bug in this area:
Bug#17001 - Table and server crash on ALTER TABLE

We changed the internal representation of varchar from 4.1 to 5.0. It seems like this is transparently done in the SQL layer, but not in MyISAM. Though the table definition looks the same with SHOW CREATE TABLE, the header in the MyISAM index file shows differences. Since the table definitions are compared on MyISAM level, they differ from the translated form of the merge table (it does not have a MyISAM representation. Its varchars are new varchars while the MyISAM tables from 4.1 are old varchars).

At least this is what I suspect at the moment.

Since I am not sure if my fix for Bug#17001 will fix your problem too, I suggest that you file a bug report on bugs.mysql.com.

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: upgrade from 4.1 to 5.0.1.8 - Merge Tables are not identically defined.
4420
February 24, 2006 08:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.