SQLite

View Ticket
Login
Ticket Hash: a55ab6d97d01ecbcf058a36ac3ccc7c7d887a1d7
Title: Incorrect result for TEXT comparison on rtree table
Status: Fixed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Extensions Resolution: Fixed
Last Modified: 2019-12-05 00:45:14
Version Found In: 3.29.0
User Comments:
mrigger added on 2019-12-04 22:53:14:

Consider the following test case:

CREATE VIRTUAL TABLE rt0 USING rtree(c0, c1, c2);
INSERT INTO rt0(c2) VALUES(NULL);
SELECT * FROM rt0 WHERE rt0.c2 >= 'a'; -- unexpected: fetches row

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

SELECT rt0.c2 >= 'a' FROM rt0; -- 0