Re: [sqlite] SQLITE3 FTS5 prefix query get mismatch result

2018-03-20 Thread Dan Kennedy
On 03/20/2018 02:31 PM, zheng xiaojin wrote: (I am not sure whether you have seen my message, so resend again) Hi, When I use FTS5, I have met that, there are some cases which will get mis-match results with prefix search. Like "select * from tbl_fts where tbl_fts match 'lucy*';"，which I want

[sqlite] SQLITE3 FTS5 prefix query get mismatch result

2018-03-20 Thread zheng xiaojin
(I am not sure whether you have seen my message, so resend again) Hi, When I use FTS5, I have met that, there are some cases which will get mis-match results with prefix search. Like "select * from tbl_fts where tbl_fts match 'lucy*';"，which I want to get records like "lucya","lucyabc" etc, and