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,
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
Hello,
You are correct. I made the change to the wrong branch. The patch fixed
the problem at least in Jessie, and I suppose that is the case with
Ubuntu as well. Thank you very much!
Best regards,
Teijo
23.3.2017, 17:23, Alexander Barkov kirjoitti:
Hello,
On 03/22/2017 08:51 PM, Teijo w
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 sql-sql
