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
7317
May 04, 2006 06:32PM
4979
May 05, 2006 01:10AM
4884
May 05, 2006 01:17AM
5134
May 05, 2006 02:08AM
5033
May 05, 2006 02:27AM
5391
May 05, 2006 03:16AM
Re: Ok to write directly to member of merge table?
5178
May 05, 2006 03:17AM
4613
May 05, 2006 03:35AM
5375
May 08, 2006 02:13AM
4981
May 08, 2006 08:49PM
5113
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.