As reported on https://bugzilla.mozilla.org/show_bug.cgi?id=551260#c17
The binaries used below were all downloaded from sqlite.org.
$ cat fts3-offsets-asplode.sql
CREATE VIRTUAL TABLE ft USING fts3(tokenize=porter, fulltextOne, fulltextTwo);
INSERT INTO ft VALUES("", "foo");
INSERT INTO ft VALUES("foo", "foo");
SELECT offsets(ft) FROM ft WHERE ft MATCH "foo";
$ sqlite3-3.6.22< fts3-offsets-asplode.sql
1 0 0 3
0 0 0 3 1 0 0 3
$ sqlite3-3.6.23< fts3-offsets-asplode.sql
Error: near line 4: database disk image is malformed
My investigation thus far has identified the sqlite3Fts3Offsets implementation
as the
source of the error. It seems upset that the first column contains an empty
string and the tokenizer returns SQLITE_DONE.
Andrew
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
