Weird: now that I've reproduced the error (using the script), I can no longer reproduce the successful execution:
sqlite3 ':memory:' 'CREATE VIRTUAL TABLE t1 USING fts4(content="", a, b, c);' Hmm... yet when I open another terminal window it begins to work again. And when I go back to the previous terminal window it fails again. What about my terminal session / environment might be contributing to this behavior? AJ ONeal On Sat, Jul 21, 2012 at 12:48 AM, AJ ONeal <coola...@gmail.com> wrote: > 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