We ran into some bumps deploying RT indexing, so we're stepping back to upgrade TS separately, and still lean on delayed deltas in the short-term and switching over to RT separately.
In retro-fitting our updated code, it seems that the config file is being generated differently: The beginning of our index looks like... ThinkingSphinx::Index.define(:issue, :with => :active_record, :delta => ThinkingSphinx::Deltas::DelayedDelta) do indexes subject, sortable: true indexes :comment_bodies indexes :attachment_file_names And, the resulting SQL_QUERY in the sphinx.conf looks like... sql_query = SELECT SQL_NO_CACHE `issues`.`id` * 3 + 0 AS `id`, `issues`.`subject` AS `subject`, AS `comment_bodies`, AS `attachment_file_names`, So, it seems like the SQL being generated for our custom "comment_bodies" and "attachment_file_names" is setting it up like an "AS" clause without the original name. This is curious on two fronts: 1. Those are model attributes that gather the data into a single string for indexing purposes. So I wouldn't expect them to be in the SQL like that. (Although, I'm guessing this may be related to the SphinxQL.) 2. It's interesting that it's using an AS rather than just the "field" names directly. When we were using RT indexing, the indexes for comment_bodies and attachment_file_names worked with that syntax in our index. Is it possible that using delayed deltas is generating a different config file? (I wouldn't think so, but that's the only significant change from our previous setup with RT.) Thanks, Garrett -- 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/d/optout.
