Hi Adam TS v3 uses SphinxQL (as you've found in your logs), but earlier versions of TS didn't, which is one of the main reasons for the rewrite.
I'd be open to patches for handling empty filter values gracefully - but is there a particular reason for sending them through? -- Pat On 27/09/2013, at 5:14 AM, Adam Roth <[email protected]> wrote: > Upgraded thinking_sphinx 2 to 3, Rails 3.1 > > Item.search( :with => { :item_set_id => [] } ) > > Sphinx Query (0.9ms) SELECT * FROM `item_core`, `item_delta` WHERE > `item_set_id` IN () AND `sphinx_deleted` = 0 LIMIT 0, 20 OPTION > > ThinkingSphinx::SyntaxError: sphinxql: syntax error, unexpected ')', > expecting CONST_INT or '-' near ') AND `sphinx_deleted` = 0 LIMIT 0, 20 > OPTION max_matches=200000; SHOW META' > > > That same line of Ruby worked properly with thinking_sphinx 2. Is the > problem obvious? Logically, the generated query is what I'm looking for... > but Sphinx does not like the empty list -- `item_set_id` IN (). > Thinking_sphinx2 must've handled this differently. > > Thank you > > Adam > > > > > > -- > 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/groups/opt_out. -- 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/groups/opt_out.
