MySQL Forums
Forum List  »  Merge Storage Engine

Re: Ok to write directly to member of merge table?
Posted by: Nathan Cheng
Date: May 05, 2006 03:35AM

Ingo Strüwing wrote:

> In other words: MySQL must check that if a MERGE
> table is TEMPORARY, all of its MyISAM tables must
> be TEMPORARY too. Conforming with the general
> MERGE behaviour, this shall be checked at access
> time, not at creation time.

Whoever wrote the documentation had a different idea (section 14.3.1):

"If the MERGE table is non-temporary, all underlying MyISAM tables must be non-temporary, too. If the MERGE table is temporary, the MyISAM tables can be any mix of temporary and non-temporary."

This is what I read before attempting this method, and therefore was expecting this behavior. It seems the MERGE engine tries its very best to deliver on it, but somehow ends up corrupting the unerlying tables.

So is the bug that it corrupts the underlying tables, or that it even tries to support this functionality in the first place?

Options: ReplyQuote

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.