SQLite

Ticket Change Details
Login
Overview

Artifact ID: cb5486703fbf96c112f95d85088afdd85e12be1d
Ticket: 38b1ae018f9033326bce4698c1453e52b4db7fc4
Assertion fault on valid FTS4 query
User & Date: drh 2013-03-24 20:45:11
Changes

  1. foundin changed to: "3.7.16"
  2. icomment:
    The following code generates an assertion fault on the SELECT:
    
    <blockquote><verbatim>
    CREATE VIRTUAL TABLE x USING fts4(y,z);
    INSERT INTO x VALUES('aaa bbb ccc ddd', 'bbb ddd aaa ccc');
    SELECT * FROM x where y MATCH 'bbb NEAR/6 aaa';
    </verbatim></blockquote>
    
    This problem was introduced when the FTS4 prefix option was added with
    check-in [b1f9c1e0ac51c] on 2011-04-14 for version 3.7.7.
    
  3. login: "drh"
  4. mimetype: "text/x-fossil-wiki"
  5. severity changed to: "Severe"
  6. status changed to: "Open"
  7. title changed to: "Assertion fault on valid FTS4 query"
  8. type changed to: "Code_Defect"