/ 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. foundin changed to: "3.29.0"
  2. 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>
    
  3. login: "mrigger"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Critical"
  6. status changed to: "Open"
  7. title changed to:
    Incorrect result for TEXT comparison on rtree table
    
  8. type changed to: "Code_Defect"