[sqlite] FTS5 prefix index documentation may be incorrect
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. 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] FTS5 prefix index documentation may be incorrect
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] FTS5 prefix index documentation may be incorrect
Thank you for the quick fix, and thank you so much for SQLite! On Nov 25, 2015 5:57 AM, "Dan Kennedy" 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 >