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.
Subject
Views
Written By
Posted
3324
February 18, 2006 11:34AM
Re: Union of two full-text searches
2480
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.