MySQL Forums :: Merge Storage Engine :: Ok to write directly to member of merge table?
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
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
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Ok to write directly to member of merge table? | 5327 | Nathan Cheng | 05/04/2006 06:32PM |
| Re: Ok to write directly to member of merge table? | 3960 | KimSeong Loh | 05/05/2006 01:10AM |
| Re: Ok to write directly to member of merge table? | 3812 | Nathan Cheng | 05/05/2006 01:17AM |
| Re: Ok to write directly to member of merge table? | 3920 | KimSeong Loh | 05/05/2006 02:08AM |
| Re: Ok to write directly to member of merge table? | 3923 | Nathan Cheng | 05/05/2006 02:27AM |
| Re: Ok to write directly to member of merge table? | 3977 | KimSeong Loh | 05/05/2006 03:16AM |
| Re: Ok to write directly to member of merge table? | 3841 | Ingo Strüwing | 05/05/2006 03:17AM |
| Re: Ok to write directly to member of merge table? | 3437 | Nathan Cheng | 05/05/2006 03:35AM |
| Re: Ok to write directly to member of merge table? | 3636 | Ingo Strüwing | 05/08/2006 02:13AM |
| Re: Ok to write directly to member of merge table? | 3862 | KimSeong Loh | 05/08/2006 08:49PM |
| Re: Ok to write directly to member of merge table? | 3853 | 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.
© 2013, Oracle Corporation and/or its affiliates