/ Ticket Change Details
Login
Overview

Artifact ID: c51da1032cd4b9d2e65de2eea986a1570311f8f6c9260fc48671300282e92fbb
Ticket: a55ab6d97d01ecbcf058a36ac3ccc7c7d887a1d7
Incorrect result for TEXT comparison on rtree table
User & Date: mrigger 2019-12-04 22:53:14
Changes

  1. Change foundin to "3.29.0"
  2. 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
    
  3. Change login to "mrigger"
  4. Change mimetype to "text/x-fossil-wiki"
  5. Change severity to "Critical"
  6. Change status to "Open"
  7. Change title to:

    Incorrect result for TEXT comparison on rtree table

  8. Change type to "Code_Defect"