Re: Ok to write directly to member of merge table?
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?