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.
Subject
Views
Written By
Posted
11805
June 05, 2007 02:00AM
7398
June 05, 2007 05:16AM
7266
June 06, 2007 03:46AM
6778
June 06, 2007 07:01AM
Re: Difference between using Merge vs. symbolic-links approach?
6918
June 10, 2007 11:39PM
7085
June 11, 2007 04:02PM
7443
June 12, 2007 12:32AM
7945
June 12, 2007 02:38AM
6916
June 12, 2007 09:57PM
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.