MySQL Forums
Forum List  »  Merge Storage Engine

Re: Difference between using Merge vs. symbolic-links approach?
Posted by: M P
Date: June 10, 2007 11:39PM

Merge-master Kim, I thank you for your help. I just found out some bad news: table X must have a FULLTEXT key index defined on it. This evening I did some reading about the FULLTEXT feature and my understanding is that it prohibits both the MERGE and the VIEW options you mentioned.

More precisely, it appears...
(i) you cannot create a MERGE table on a table with a FULLTEXT index, and
(ii) you can define a VIEW on a table with a FULLTEXT index, but the resulting VIEW will not make use of that index and hence will not be full-text searchable.

So, it seems as if I am out of luck. Is is likely that solution (i) or (ii) might be feasible in an impending MySQL update?



Edited 1 time(s). Last edit at 06/10/2007 11:40PM by M P.

Options: ReplyQuote




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.