My apologies to the list if this is a dup. I think this message was dropped the first time I sent it.
> >> Hello! >> > > >> sqlite> select count(*) from file_text where file_text match >> 'content:мтс-коннект'; >> 162 >> sqlite> select count(*) from file_text where file_text match >> '"мтс-коннект"'; >> 112 > > Thanks for the bug report! > > Depending on the way the fts3 table was declared, this might not > be a bug. If you are using the default tokenizer, then the "-" is > being interpreted as a token separator. So the first query is actually > requesting the count of documents where the "content" column contains > the 'MTC' token, and the 'KOHHEKT' token appears anywhere in any > column. > > Whereas the second query is asking for the number of documents in > which > the two tokens appear in sequence (any column). > >> sqlite> select count(*) from file_text where file_text match >> 'content:"мтс-коннект"'; >> Error: SQL logic error or missing database > > This is unsupported syntax. Always has been. That it should be > supported > is not an unreasonable position to take though. > > Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users