SQLite

View Ticket
Login
Ticket Hash: df46a6f38eb1d7c8d1f9a78704aacebde33fb883
Title: Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed
Status: Closed Type: Code_Defect
Severity: Critical Priority: Low
Subsystem: Unknown Resolution: Fixed
Last Modified: 2019-12-24 16:20:18
Version Found In: 3.30.0
User Comments:
mrigger added on 2019-12-24 14:42:22:

Consider the following test case:

CREATE VIRTUAL TABLE vt0 USING fts5(c0, prefix = 71, tokenize = "porter ascii", prefix = 9);
BEGIN;
INSERT INTO vt0(c0) VALUES (x'e9');
INSERT INTO vt0(vt0) VALUES('integrity-check'); -- sqlite3.c:213028: sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed

When compiling with -DSQLITE_DEBUG, the integrity check triggers an assertion error.