SQLite

Consider the test case below:

CREATE TABLE t0(c0 REAL, c1 TEXT);
CREATE INDEX i0 ON t0(+c0, c0);
INSERT INTO t0(c0) VALUES(0);
SELECT CAST(+ t0.c0 AS BLOB) LIKE 0 FROM t0; -- expected: 0, actual: 1

When not creating the index, the expression evaluates to FALSE, as expected. When the expression is used in the WHERE condition, the result is also as expected (i.e., the row is not fetched):

SELECT * FROM t0 WHERE CAST(+ t0.c0 AS BLOB) LIKE 0; -- no row is fetched

This bug is somewhat different from all the other bugs that I found, since typically, an expression used in the WHERE clause can lead to an incorrect result.

Problem apparently introduced by check-in [a47efb7c8520a011]