Re: [sqlite] unrecognized parameter: content=""

2012-07-21 Thread AJ ONeal
Very interesting indeed! ls ~/Library/Caches/Homebrew/sqlite-* sqlite-3.7.10.tar.gz sqlite-3.7.13.tar.gz # # in original (failing) terminal # sqlite3 --version 3.7.7 2011-06-25 16:35:41 8f8b373eed7052e6e93c1805fc1effcf1db09366 which sqlite3 /usr/bin/sqlite3 # # in new (succeeding) terminal #

Re: [sqlite] unrecognized parameter: content=""

2012-07-21 Thread Dan Kennedy
On 07/21/2012 02:03 PM, AJ ONeal wrote: 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

Re: [sqlite] unrecognized parameter: content=""

2012-07-21 Thread AJ ONeal
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

Re: [sqlite] unrecognized parameter: content=""

2012-07-21 Thread AJ ONeal
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

[sqlite] unrecognized parameter: content=""

2012-07-20 Thread AJ ONeal
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