SQLite

Consider the following test case:

CREATE TABLE t0(c0);
INSERT INTO t0 VALUES('0');
CREATE VIEW v0(c0) AS SELECT CAST(0 AS INT) FROM t0;
SELECT * FROM t0, v0 WHERE 0 >= t0.c0 AND t0.c0 = v0.c0; -- unexpected: fetches row

Unexpectedly, the query fetches a row. When removing the AND and its right expression, no row is fetched:

SELECT * FROM t0, v0 WHERE 0 >= t0.c0; -- fetches no row

Also the following expression evaluates to FALSE:

SELECT 0 >= t0.c0 AND t0.c0 = v0.c0 FROM t0, v0; -- 0