In the example below, an INDEX causes a query to malfunction:

<pre>
CREATE TABLE t0 (c0);
CREATE INDEX i0 ON t0(1) WHERE c0 NOT NULL;
INSERT INTO t0(c0) VALUES (NULL);
SELECT * FROM t0 WHERE '' BETWEEN t0.c0 AND 1 IN (FALSE); -- unexpected: row is not fetched
</pre>

The expression should evaluate to TRUE:

<pre>
SELECT '' BETWEEN t0.c0 AND 1 IN (FALSE) FROM t0; -- TRUE
</pre>