So I am working with a data model, which for reasons outside of my
control are ugly. Here is an example of what is happening.
$> Thing.search(:all, :conditions => {:idx_top_category => 'Note
Cards})
Sphinx Querying: 'all @idx_top_category Note Cards'
Sphinx (0.003722s) Found 0 results
=> []
This yields 0 (read zero) results.
On the other hand if I search for...
$> Thing.search('Note Cards').count
Sphinx Querying: 'Seasonal Invitations'
Sphinx (0.005707s) Found 313 results
Paper Load (1.4ms) SELECT * FROM "things" WHERE ("things"."id" IN
(52,65,66,69,116,169,170,203,211,214,217,218,225,228,231,237,239,240,241,248))
=> 20
For demos sake, here's what my index looks like.
define_index do
indexes design_categories.flow_categories.design_section.title, :as
=> :idx_top_category
end
I've killed the searchd process, deleted all index files and rebuilt
and indexed over and over.
If I run the sql query in the sphinx.conf I get results like this...
id | idx_top_category |
sphinx_internal_id | class_crc | sphinx_deleted
------+-----------------------------------------------------------
+--------------------+------------+----------------
1 | Invitations 0
| 1 | 2413514514 | 0
2 | Invitations 0
| 2 | 2413514514 | 0
3 | Invitations Note Cards 0
| 3 | 2413514514 | 0
4 | 0 Invitations
| 4 | 2413514514 | 0
Any clues?
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
