Dan, updating to sqlite3.dll version 3.6.17 did fix the problem. Also, I should clarify what I meant by having the query syntax doc on the sqlite web site. It is indeed on the web site, but I spent a lot of time yesterday trying to find a document just like it and couldn't. It just needs to be in a more accessible spot, perhaps under the documents area?
Thanks again for the help, Craig > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users