According to the file indexer_dbm.py, the Indexer.find
method  finds text that contains all the words searched
for:

    def find(self, wordlist):
        '''Locate files that match ALL the words in
wordlist
        '''

But in the indexer_rdbms.py module, the Indexer.find
method clearly finds text that contain ANY of the
words.  Adding more words to the text search broadens
the search instead of narrowing it.

I've modified the Indexer.find method in
indexer_rdbms.py so that text is only matched if ALL
word are found.  I've attached a patch file of the
change I made, and I would like the change to be
included in a future release.

Thank you!

Michael

Logged In: YES 
user_id=6405

I've implemented a simpler version using INTERSECT (sqlite doesn't cope 
with the JOIN syntax you used anyway). Having said that, MySQL uses 
your code because it doesn't implement INTERSECT. Sigh.