Can you show us the index definitions for both models, and the queries you're running?
On 09/10/2013, at 4:28 AM, stasch <[email protected]> wrote: > I've got two tables in the same database that are identical in structure - > columns, indexes, permissions (one is an archive of the other). The model > files are not identical but the associations and index declarations are. The > archive model contains a subset of the functionality of the original, but I > have already gone so far as to reduce the model file for the archive to just > the associations and index declarations. When I rebuild the indexes after > deleting all files in the index directory both models are processed without > complaint. The index files are created with identical permissions. But when > I do a simple search (for the word 'worried') on each the original file > returns many results, the archive file returns no results. When I use the > error method to check for errors on the result set it returns nil. When I > look in the query log it shows that the query was successfully executed and > returned 0 results. But when I do a sql query on the indexed field in the > archive file it returns over 3000 results (select count(*) from > contact_archive where message like '% worried %'). > > My environment is Ruby 1.8.7, Rails 2.3.15 and Thinking Sphinx 1.4.10. Any > help would be greatly appreciated. > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
