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