Dan, thank you for the additional information, it's most helpful. I'll let you know what I find out.
BTW, any reason that doc is not on the SQLite Web site? It would help a lot of people understand the old and new query syntax better. Craig > > > > Did an FTS3 update change how many negation operators (dash/-) can > > be used in > > a > > match statement? > > > > For example, in sqlite3.dll version 3.5.7: > > > > colname match 'tetons -bend -jackson -oxbow* -parks' works as > > expected; bend, > > jackson, oxbow* and parks are all removed from the results. > > > > but > > > > With, sqlite3.dll version 3.6.16: > > > > colname match 'tetons -bend -jackson -oxbow* -parks' no longer works > > correctly. It acts like only the last negated token is being used > > and results > > have bend, jackson and oxbow* tokens in them. > > Please try 3.6.17. I think this problem was fixed here: > > http://www.sqlite.org/src/vdiff/27971 > > > Also, can somone point me to updated docs on how to use the new > > options if > > SQLITE_ENABLE_FTS3_PARENTHESIS is set at compile time? > > http://www.sqlite.org/src/annotate?mid=25265&fnid=373 > > Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users