[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread Dan Kennedy
On 07/06/2015 07:23 PM, shuricksoft at ukr.net wrote: > > --- ? --- > ?? : "Dan Kennedy" > : 2 2015, 14:26:05 > > >> On 07/02/2015 09:24 PM, Kevin Benson wrote: >>> FTFY, you're welcome ;-) >> Now *MAYBE* someone can read it and possibly reply. >>> -- >>>

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread shuricks...@ukr.net
Sorry, tried to make the reply from another message and the original text, but it failed to be placed in the thread I wanted. Sorry about that, already e-mailed to the admin. --- ? --- ?? : shuricksoft at ukr.net : 6 2015, 15:23:05 > > > ---

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread shuricks...@ukr.net
--- ? --- ?? : "Dan Kennedy" : 2 2015, 14:26:05 > On 07/02/2015 09:24 PM, Kevin Benson wrote: >> FTFY, you're welcome ;-) > Now *MAYBE* someone can read it and possibly reply. >> >> -- >> -- >>-- >> --???-- >> K e V i N >> > > >

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread Kevin Benson
On Mon, Jul 6, 2015 at 8:23 AM, wrote: > > > --- ? --- > ?? : "Dan Kennedy" > : 2 2015, 14:26:05 > > > > On 07/02/2015 09:24 PM, Kevin Benson wrote: > >> FTFY, you're welcome ;-) > > Now *MAYBE* someone can read it and possibly reply. > >> > > *SNIP* > > >

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-03 Thread Dan Kennedy
On 07/02/2015 09:24 PM, Kevin Benson wrote: > FTFY, you're welcome ;-) > Now *MAYBE* someone can read it and possibly reply. > > -- > -- >-- > --???-- > K e V i N > > On Thu, Jul 2, 2015 at 9:11 AM, wrote: > >> We use SQLite for indexing and searching the text

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-02 Thread shuricks...@ukr.net
We use SQLite for indexing and searching the text contents of our app using FTS4 (about 27k unique words, about 1 million words for the whole contents). In particular, we use the offsets function. Currently, after some testing, we?re experiencing a plenty of problems with finding the results

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-02 Thread Kevin Benson
FTFY, you're welcome ;-) Now *MAYBE* someone can read it and possibly reply. -- -- -- --???-- K e V i N On Thu, Jul 2, 2015 at 9:11 AM, wrote: > We use SQLite for indexing and searching the text contents of our app > using FTS4 > (about 27k unique words, about 1