Re: Ok to write directly to member of merge table?
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
Subject
Views
Written By
Posted
6750
May 04, 2006 06:32PM
4691
May 05, 2006 01:10AM
4627
May 05, 2006 01:17AM
4793
May 05, 2006 02:08AM
4698
May 05, 2006 02:27AM
4797
May 05, 2006 03:16AM
Re: Ok to write directly to member of merge table?
4698
May 05, 2006 03:17AM
4288
May 05, 2006 03:35AM
4621
May 08, 2006 02:13AM
4665
May 08, 2006 08:49PM
4825
May 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.