Yup, Menno's patch is merged, and also, there's a group_concat_max_len setting in Thinking Sphinx if you want to set it higher in MySQL while indexing.
The latter isn't ideal, but Menno's solution is pretty fantastic. -- Pat On 09/03/2009, at 5:41 PM, James Healy wrote: > > Christian Niles wrote: >> As part of my research into my previous question about MVAs and >> cached IDs, >> I noticed that TS uses GROUP_CONCAT to assemble the list of integer >> IDs in a >> case like this: >> >> has users(:id) >> >> I know from a previous bug in another project that GROUP_CONCAT >> silently >> truncates the result string if it exceeds the >> 'group_concat_max_len' system >> variable, which defaults to 1024 characters. This is probably fine >> for most >> cases, but if you exceed that limit, you'll get invalid data. >> >> This is just an FYI, rather than a bug report or feature request. > > Thanks for highlighting this issue, imho it's useful to have such data > archived on google groups. > > Menno van der Sman proposed a patch that (I think) resolves this issue > last month, although I'm not sure what stage Pat is at with merging it > into his mainline repository. Hopefully it will be merged soon if it > hasn't been already. > > See the discussion here: > http://groups.google.com/group/thinking-sphinx/browse_thread/thread/94bec92a0c401136/ > > -- James Healy <jimmy-at-deefa-dot-com> Mon, 09 Mar 2009 17:30:54 > +1100 > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
