On 10/13/2011 10:45 PM, Wendland, Michael wrote:
I've encountered an error running 3.7.8 and 3.7.7.1 that seems rather strange.CREATE VIRTUAL TABLE fts USING fts3( tags TEXT); INSERT INTO fts (tags) VALUES ('tag1'); SELECT * FROM fts WHERE tags MATCH 'tag1'; Now close the database and reopen it, then try the following statements. UPDATE fts SET tags = 'tag1' WHERE rowid = 1; SELECT * FROM fts WHERE tags MATCH 'tag1'; Is anyone able to help? (I haven't accidentally posted this to the wrong list have I?)
Thanks for reporting this. Now fixed here: http://www.sqlite.org/src/info/7e24645be2 Bug report: http://www.sqlite.org/src/info/9fd058691b You are correct in that the bug only occurs when the FTS table contains exactly one row. Bug was introduced in version 3.7.7. Dan. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
