Skip navigation links

MySQL Forums :: Merge Storage Engine :: Ok to write directly to member of merge table?


Advanced Search

Re: Ok to write directly to member of merge table?
Posted by: Ingo Strüwing ()
Date: May 05, 2006 03:17AM

Yes, it does.

A MERGE table must be defined exactly as all of its underlying MyISAM tables (with a few exceptions for indexes). It seems that the TEMPORARY attribute is not tested.

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.

Please report it as a bug at bugs.mysql.com.

Regards

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

Options: ReplyQuote


Subject Views Written By Posted
Ok to write directly to member of merge table? 5513 Nathan Cheng 05/04/2006 06:32PM
Re: Ok to write directly to member of merge table? 4047 KimSeong Loh 05/05/2006 01:10AM
Re: Ok to write directly to member of merge table? 3933 Nathan Cheng 05/05/2006 01:17AM
Re: Ok to write directly to member of merge table? 4059 KimSeong Loh 05/05/2006 02:08AM
Re: Ok to write directly to member of merge table? 4025 Nathan Cheng 05/05/2006 02:27AM
Re: Ok to write directly to member of merge table? 4063 KimSeong Loh 05/05/2006 03:16AM
Re: Ok to write directly to member of merge table? 3960 Ingo Strüwing 05/05/2006 03:17AM
Re: Ok to write directly to member of merge table? 3583 Nathan Cheng 05/05/2006 03:35AM
Re: Ok to write directly to member of merge table? 3770 Ingo Strüwing 05/08/2006 02:13AM
Re: Ok to write directly to member of merge table? 3969 KimSeong Loh 05/08/2006 08:49PM
Re: Ok to write directly to member of merge table? 3974 Nathan Cheng 05/16/2006 10:23PM


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.