[sqlite] How to avoid the fts rebuilding when add a column on fts table?

we are using FTS5 to support my business. But find it so intolerable that Every time when I wanr to add one business column which will also be added on fts table, I need to drop all the fts.table and rebulid again. Can.you help me or if you have any develop plan about this problem? Thank you!

Re: [sqlite] here is my test case//Re: SQLITE3 FTS5 prefix query get mismatch result

se//Re: SQLITE3 FTS5 prefix query get mismatch result On 03/22/2018 06:05 PM, Dan Kennedy wrote: > On 03/22/2018 05:38 PM, zheng xiaojin wrote: >> Sorry, but testcase maybe have some format problem, changed belowed, >> I run this on SQLITE 3.15.2, both on Windows and linux. and o

Re: [sqlite] here is my test case//Re: SQLITE3 FTS5 prefix query get mismatch result

qlite] here is my test case//Re: SQLITE3 FTS5 prefix query get mismatch result On 03/21/2018 03:16 PM, zheng xiaojin wrote: > (Please add.the head file and sqlite lib yourself, Thank you very much) Hi, Thanks for doing this. I'm running this version of the test program modified for posix

[sqlite] here is my test case//Re: SQLITE3 FTS5 prefix query get mismatch result

(HANDLE)_beginthreadex(NULL, 0, readFunc, NULL, 0, NULL); Sleep(5); } if (writeFunc) { WaitForMultipleObjects(THREAD_NUM, &handle[0], TRUE, INFINITE); } else { WaitForMultipleObjects(THREAD_NUM - 1, &handle[1], TRUE, INFINITE); } printf("multithread are all over now.\n"); } else { WaitForMu

[sqlite] SQLITE3 FTS5 prefix query get mismatch result

(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

[sqlite] Problem: FTS5 prefix search getting the mis-match result

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 "lux" or "lulu" is not what I want but returned. Such problems are

[sqlite] pcache1FetchStage2 CRASH

I am using the 3.15.2, and currently a problem comes to me that, pcache1FetchStage2 CRASH when access the pgroup->lru.pLRUPrev->isAnchor, the crash info is sigsegv access 0x16 on IOS. And a little frequently about0.1percent. 获取 Outlook for Android