Hey guys,
I have sphinx running smoothly but I'm seeing weird results with
ordering. For example, I have users indexed like
define_index do
indexes :email, :created_at
indexes "LOWER(`profiles`.`full_name`)", :as
=> :full_name, :sortable => true
indexes profile.location, :as => :location
end
When I do this
User.search :conditions => { :location => "Brooklyn" }, :match_mode
=> :any, :order => "full_name ASC"
It only sorta returns the results in alpha order. On the first page
there's one or two results where the full_name starts with a "J"
surrounded by entries starting in "A". The second page is still all
A.
When I run "search" from the command line, these spurious results are
not in the "user_core" index, but they ARE in the "user_delta" index.
There are only 4 users in the "user_delta" index.
So.. delta index weirdness? Jobs not set up properly? Indexing
incorrect?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
