On Mar 24, 2010, at 7:24 PM, Andrew Sutherland wrote: > > > 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.
It's a bug alright. Now fixed here: http://www.sqlite.org/src/ci/d37034f7fc Thanks for working on this. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users