Hi, but there is no token '^beta'! Even if in FTS3 '^' is not regarded as a special character. Is the '^' removed by the tokenizer? Because it is regarded as a diacritical character?
PS: I have to admit that I have overlooked the comment that '^' works only for FTS4 tables. Regards, Hardy > Am 2019-08-30 um 12:24 schrieb Dan Kennedy <danielk1...@gmail.com>: > > > > The fts3/4 documentation says: > > "If the FTS table is an FTS4 table (not FTS3), a token may also be prefixed > with a "^" character. In this case, in order to match the token must appear > as the very first token in any column of the matching row." > > So change "FTS3" to "FTS4" and it will likely work. > > Dan. > > > On 30/8/62 16:31, mailing lists wrote: >> Hi, >> >> I could not find an example showing a result in the documentation, therefore >> I created one by myself: >> >> CREATE VIRTUAL TABLE myData USING FTS3(content); >> INSERT INTO myData 'alpha beta'; >> >> 1) >> SELECT * FROM myData WHERE myData MATCH 'beta'; >> >> Result: >> >> content >> alpha beta >> >> This is what I expected. >> >> 2) >> SELECT * FROM myData WHERE myData MATCH '^beta'; >> >> Result: >> >> content >> alpha beta >> >> This is what I did not expect. According to the documentation I expected to >> get no rows because the column begins with alpha and not with beta. >> >> What's the issue here? I tested these examples using version 3.24.0. >> >> Regards, >> Hardy >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users