Thank you for the quick fix, and thank you so much for SQLite! On Nov 25, 2015 5:57 AM, "Dan Kennedy" <danielk1977 at gmail.com> wrote:
> On 11/25/2015 05:11 AM, Charles Leifer wrote: > >> The FTS5 prefix index documentation[1] seems to not be working. I've tried >> with SQLite 3.9.0 and 3.10.0 (2015-11-06) and both show the same error >> messages. >> > > Thanks for reporting this. Now fixed here: > > http://sqlite.org/src/info/11eb8e877e2ba859 > > Dan. > > > >> Examples: >> >> sqlite> CREATE VIRTUAL TABLE ft USING fts5(a, b, prefix='2 3'); >> Error: malformed prefix=... directive >> sqlite> CREATE VIRTUAL TABLE ft USING fts5(a, b, prefix=2, prefix=3); >> Error: multiple prefix=... directives >> >> What does appear to work is using a comma: >> >> sqlite> CREATE VIRTUAL TABLE ft USING fts5(a, b, prefix='2,3'); >> sqlite> .schema ft >> CREATE VIRTUAL TABLE ft USING fts5(a, b, prefix='2,3'); >> >> 1: https://sqlite.org/fts5.html#section_4_2 >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
