SQLite

View Ticket
Login
Ticket Hash: aa573a787b8f1fdf40f749be7ef2a1a3741bed17
Title: Comparison on INT column in rtree table malfunctions
Status: Fixed Type: Feature_Request
Severity: Minor Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-06 01:38:39
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-05 23:06:58:

Consider the following test case:

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

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

SELECT '0' = rt0.c2 FROM rt0; -- 1