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
#
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
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
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
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
5 matches
Mail list logo