SQLite
View Ticket
Not logged in
Ticket UUID: 38b1ae018f9033326bce4698c1453e52b4db7fc4
Title: Assertion fault on valid FTS4 query
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2013-03-27 21:12:25
Version Found In: 3.7.16
User Comments:
drh added on 2013-03-24 20:45:11:

The following code generates an assertion fault on the SELECT:

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';

This problem was introduced when the FTS4 prefix option was added with check-in b1f9c1e0ac51c on 2011-04-14 for version 3.7.7.