I'm on OS X brew install sqlite3 sqlite3 --version 3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc
Interestingly when I do it like this it works: sqlite3 ':memory:' 'CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c);' But when I do it like this sqlite3 -init meta-fts.table.sql meta-fts-new.sqlite3 where `meta-fts.table.sql` is https://gist.github.com/3154874 wget https://raw.github.com/gist/3154874/8f582883d62c82aeafed5eabf639e603ec1ac379/meta-fts.table.sql Then it throws the error. AJ ONeal On Fri, Jul 20, 2012 at 11:34 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Fri, 20 Jul 2012 23:12:43 -0600, AJ ONeal <coola...@gmail.com> wrote: > > >I've tested with sqlite3 and the nodejs sqlite3 module and I get this > error > >when using the example from the documentation (as well as variants more > >suitable to my application) for full-text search. > > > >Docs: > >http://www.sqlite.org/fts3.html#section_6_2_1 > > > >Test: > >CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c); > >CREATE VIRTUAL TABLE fts USING fts4(content="data", name TEXT, path TEXT); > > > >Result: > >unrecognized parameter: content="" > > > >Was this never implemented? Is it deprecated? Does it require special > build > >options? Any thoughts? > > Cannot reproduce that error message in the test above with: > SQLite version 3.7.12.1 2012-05-22 02:45:53 or > SQLite version 3.7.14 2012-06-21 17:21:52. > > Is your test sample complete? > > > -- > Regards, > > Kees Nuyt > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
