How to select all empty values ​​of sql_attr_multi attribute in Sphinx if it is set as uint?

Question

Sphinx

The Sphinx index has an attribute sql_attr_multi uint , which for some records contains a set of numbers, as expected, and for other records it is empty. How to correctly compose a query to get records/rows for which sql_attr_multi uint is empty?

The following is a query that throws an unsupported filter type null on MVA column error :

SELECT * FROM myIndexSphinx WHERE myAttrMultiUint IS NULL;

Answer 1

Check for length .