Overview
Artifact ID: | c51da1032cd4b9d2e65de2eea986a1570311f8f6c9260fc48671300282e92fbb |
---|---|
Ticket: | a55ab6d97d01ecbcf058a36ac3ccc7c7d887a1d7
Incorrect result for TEXT comparison on rtree table |
User & Date: | mrigger 2019-12-04 22:53:14 |
Changes
- Change foundin to "3.29.0"
- Change icomment to:
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
- Change login to "mrigger"
- Change mimetype to "text/x-fossil-wiki"
- Change severity to "Critical"
- Change status to "Open"
- Change title to:
Incorrect result for TEXT comparison on rtree table
- Change type to "Code_Defect"