On 13 Oct 2011 at 16:59, Filip Navara <filip.nav...@gmail.com> wrote:
> Reproduced on Windows, SQLite 3.7.8. Seems OK here, OS X 10.7.2: Second-Mini% sqlite3 wiggy -- Loading resources from /Users/tim/.sqliterc SQLite version 3.7.5 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE VIRTUAL TABLE fts USING fts3( tags TEXT); sqlite> INSERT INTO fts (tags) VALUES ('tag1'); sqlite> SELECT * FROM fts WHERE tags MATCH 'tag1'; tags ---------- tag1 sqlite> ^D Second-Mini% sqlite3 wiggy -- Loading resources from /Users/tim/.sqliterc SQLite version 3.7.5 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> UPDATE fts SET tags = 'tag1' WHERE rowid = 1; sqlite> SELECT * FROM fts WHERE tags MATCH 'tag1'; tags ---------- tag1 sqlite> -- Cheers -- Tim
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users