Suggest an explicit ANY()/ALL() around a filter on MVA column


#1

On Manticore 2.3.3 and I see this warning suggest an explicit ANY()/ALL() around a filter on MVA column every time I use a multi attribute filter, like categories in (453,181). The queries seems to work fine compared to Sphinx 2.2.11 and I see no difference in results, but why this warning? Thanks


#2

Actually that’s something available in Sphinx 2.3.2, where MVAs got some new constructors that can be used. It’s an undocumented feature (which reminds me I need to update Manticore docs about as well!).
The old behaviour is equivalent to newer ANY(mvaattr)>x, means true fi any value from mvaattr is greater than x
ALL(mvaattr)>x means true if all values from mvaattr are greater than x.
One of the tests has more examples: https://github.com/manticoresoftware/manticore/blob/master/test/test_244/test.xml
The warning is there to suggest starting using these constructors.


#3

Thanks, the examples make sense!