Hi Wil This is probably related to a limit in MySQL (assuming that's your database - if it's Postgres, I'd have no idea) - group_concat_max_len is a setting MySQL has, and I think the default is either 512 or 1024 characters. There is a setting in Thinking Sphinx though for this, that you can use to extend the limit during indexing, via config/ sphinx.yml:
development: group_concat_max_len: 16384 test: group_concat_max_len: 16384 production: group_concat_max_len: 16384 Hopefully that'll fix the problem. Cheers -- Pat On 12/03/2009, at 8:10 AM, wb wrote: > > I'm having a really baffling issue with the latest stable thinking > sphinx + sphinx. > > Given the stripped down models below, a call to Parent.search(query) > seems to always return the expected results if query exists anywhere > in parent.fragment.value. Similarly for Child.search(query) / > child.fragment.value and Fragment.search / value. > > The problem I'm having is that Parent.search(query) seems to only > return results on children.fragment.value if there is an occurrence of > query in the first few hundred bytes. Any later occurrences of query > seem be ignored. > > Fragment.value is a text field, and I'm using mysql 5 (FYI). > > Any help would be very much appreciated! > > - Will > > class Parent < ActiveRecord::Base > > has_one :fragment, :as => :owner > has_many :children > > define_index do > indexes fragment.value, :as => :value > indexes children.fragment.value, :as => :child_values > end > > end > > class Child < ActiveRecord::Base > > has_one :fragment, :as => :owner > belongs_to :parent > > define_index do > indexes fragment.value, :as => :value > end > > end > > class Fragment < ActiveRecord::Base > > belongs_to :owner, :polymorphic => true > > define_index do > indexes value > end > end > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
