2.8.2 Returns no results when we add "name IS NOT NULL"


Hi, when I do a simple:

SELECT name FROM myindex;

I get back results, but if I do:

SELECT name FROM myindex WHERE name IS NOT NULL;

I get back no results. I have this problem at multiple points in my codebase, and it blew when I tried to migrate my existing sphinx index to manticore.

Do you know if this is a known bug?



NULL is only supported for JSON properties.
Manticore and Sphinx2 (no idea about Sphinx3) never had proper NULL support for regular attributes as empty strings and NULL (coming from a DB source) are stored as ‘’ (same goes for float/attributes -> NULLs from DB are stored as 0/0.0) and I think IS [NOT] NULL worked incorrectly in the past as it was matching NULL=’’.

Use name!='' or name=''.