MySQL Forums
Forum List  »  Merge Storage Engine

Adding index on a merged table "breaks" merge functionality
Posted by: Orna Weisman
Date: December 17, 2009 02:04PM

Hi

I created two base myIsam tables with two columns and no indexes and a merge table for these two as :

create table test_merge...
...
ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 INSERT_METHOD=FIRST
UNION=(`test1`,`test2`)

All works fine until I added an index on test1.
Once I did that all inserts into the merge table were not added to test1, but were added to the test_merge table only - like it is a regular table and not a merge table.

However - if I dropped the merge table and recreated it, then all subsequent inserts were inserted correctly to the base table ( even though the index was still there on test1 ).

Is this an expected behavior ?
mysql version is 5.0.27

Options: ReplyQuote


Subject
Views
Written By
Posted
Adding index on a merged table "breaks" merge functionality
9404
December 17, 2009 02:04PM


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.