Hi Pat,

This is actually the expected behaviour - though it definitely needs some documentation love. Boolean, integer and timestamp attributes can all be updated in the original index, so the delta is not needed in these situations.

That's super.  I hadn't realised this so thanks for spelling it out.


I'm guessing in your situation it means that the WHERE clause isn't coming into effect. I should add a setting to disable these 'smarter' updates - but in the meantime, I guess a work-around is:
has "reviewed", :type => :boolean

Using a string implies a SQL snippet, and TS can't/won't try to figure out what column(s) the string references, and so will perform a delta update in all situations.

Given what you said in the first paragraph, the delta index is a red herring here. I wonder why the WHERE clause is not coming into effect?

If I index via rake, the WHERE clause takes effect and reviewed items are excluded. Are we sure the main index is updated when a boolean attribute alone is updated? I can't think why else the WHERE clause wouldn't have the desired effect.

Thanks again,

Andrew
-------
http://airbladesoftware.com

--
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.

Reply via email to