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
6754
May 04, 2006 06:32PM
4692
May 05, 2006 01:10AM
4630
May 05, 2006 01:17AM
4796
May 05, 2006 02:08AM
4702
May 05, 2006 02:27AM
4800
May 05, 2006 03:16AM
Re: Ok to write directly to member of merge table?
4700
May 05, 2006 03:17AM
4289
May 05, 2006 03:35AM
4623
May 08, 2006 02:13AM
4670
May 08, 2006 08:49PM
4835
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.