/ 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: (text/x-fossil-wiki)
Consider the following test case:

<pre>
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
</pre>

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

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