SQLite

Consider the following test case:

CREATE TABLE t0(c0 TEXT UNIQUE, c1);
INSERT INTO t0(c0) VALUES (-1);
SELECT * FROM t0 WHERE - x'ce' >= t0.c0; -- unexpected: row is not fetched

I would expect the row to be fetched, since the following returns TRUE:

SELECT - x'ce' >= t0.c0 FROM t0;

False positive in the sqlite3ExprNeedsNoAffinityChange() optimization.

The error first appeared in version 3.8.1 (2013-10-17).