MySQL Forums
Forum List  »  Full-Text Search

Re: Union of two full-text searches
Posted by: Harry Hege
Date: February 24, 2006 09:28AM

For reasons that I do not understand, you may experience troublesome inconsistencies in search results when the search environment meets the following three conditions:
1. FULLTEXT
2. IN BOOLEAN MODE
3. wildcard truncation characters within a parenthesized subexpression

You may reproduce this behavior by running three separate searches and comparing the results, which should be identical:
1. a basic search (S)
2. a combination search for the intersection of S with itself (S and S)
3. a combination search for the union of S with itself (S or S)

In my current development project, I am considering two different workarounds for the above situation:
1. breaking out each parenthesized subexpression to a separate MATCH...AGAINST clause; or
2. replacing truncated search words with matching words from a user-created table (UWord) of unique words in the fulltext index.

I suspect that the MySQL development team will address this at some point. Meanwhile, I hope this helps.

Options: ReplyQuote


Subject
Views
Written By
Posted
3245
February 18, 2006 11:34AM
Re: Union of two full-text searches
2441
February 24, 2006 09:28AM


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.