SQLite

Consider the following test case:

CREATE VIRTUAL TABLE rt0 USING rtree(c0, c1, c2);
INSERT INTO rt0(c1) VALUES(0);
SELECT * FROM rt0 WHERE rt0.c1 > '-1'; -- unexpected: row is fetched

The row is fetched, even though the predicate should evaluate to FALSE:

SELECT rt0.c1 > '-1' FROM rt0; -- 0

I think that this worked previously.

In addition to code changes to be more pedantic about type affinity in rtree, the documentation has been updated. https://www.sqlite.org/docsrc/info/8199b59a39c017c7