[General] Extra hit with SQL query and word position in the original file

Hello, If I search given word with search.cgi, I get correct number of occurences. But if I do it with SQL (no matter in mysql or sqlite3), they show extra occurence. For example, if a given word is in a given original file twice, they tell that there are three occurences. SQL query is almost

Re: [General] Extra hit with SQL query and word position in the original file

Hello Teijo, On 03/24/2017 01:24 AM, Teijo wrote: > Hello, > > If I search given word with search.cgi, I get correct number of occurences. > > But if I do it with SQL (no matter in mysql or sqlite3), they show extra > occurence. For example, if a given word is in a given original file > twice,

Re: [General] Indexing problem with sqlite3

Hello, On 03/22/2017 08:51 PM, Teijo wrote: > Hello, > > Unfortunately patch did not solve the problem. > > As to SQLite3 versions, Ubuntu 16.04 it is > SQLite version 3.11.0 2016-02-15 17:29:24 > and in Jessie > SQLite version 3.8.7.1 2014-10-29 13:59:56 There are two similar places in