Total_found counter sometimes shows random number

[bugsoff]

Bug Description:

Request: select id from items where match('@* "one two three four"/0.66') limit 50 offset 340;
I sent the search request twice and got diffrent results.
The correct value of total_found is 343.
This request should return 3 results (with offset 340 option).
And it's works correctly 90% of the time.
But sometimes this request return total_count with random number greater than 343, and an empty resultset.

'version' => '6.3.6 593045790@24080214 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)',

mysql> select id from items where match('@* "one two three four"/0.66') limit 50 offset 340; show meta;
+-----------+
| id        |
+-----------+
|  30899144 |
|  81843203 |
| 101762551 |
+-----------+
+----------------+--------+
| Variable_name  | Value  |
+----------------+--------+
| total          | 3      |
| total_found    | 343    |
| total_relation | eq     |
| time           | 0.001  |
| keyword[0]     | =four  |
| docs[0]        | 2      |
| hits[0]        | 2      |
| keyword[1]     | =one   |
| docs[1]        | 14     |
| hits[1]        | 15     |
| keyword[2]     | =three |
| docs[2]        | 7      |
| hits[2]        | 7      |
| keyword[3]     | =two   |
| docs[3]        | 7      |
| hits[3]        | 7      |
| keyword[4]     | four   |
| docs[4]        | 2      |
| hits[4]        | 2      |
| keyword[5]     | one    |
| docs[5]        | 16     |
| hits[5]        | 17     |
| keyword[6]     | three  |
| docs[6]        | 7      |
| hits[6]        | 7      |
| keyword[7]     | two    |
| docs[7]        | 7      |
| hits[7]        | 7      |
+----------------+--------+
mysql> select id from items where match('@* "one two three four"/0.66') limit 50 offset 340; show meta;
+----------------+--------+
| Variable_name  | Value  |
+----------------+--------+
| total          | 0      |
| total_found    | 492    |
| total_relation | eq     |
| time           | 0.001  |
| keyword[0]     | =four  |
| docs[0]        | 2      |
| hits[0]        | 2      |
| keyword[1]     | =one   |
| docs[1]        | 14     |
| hits[1]        | 15     |
| keyword[2]     | =three |
| docs[2]        | 7      |
| hits[2]        | 7      |
| keyword[3]     | =two   |
| docs[3]        | 7      |
| hits[3]        | 7      |
| keyword[4]     | four   |
| docs[4]        | 2      |
| hits[4]        | 2      |
| keyword[5]     | one    |
| docs[5]        | 16     |
| hits[5]        | 17     |
| keyword[6]     | three  |
| docs[6]        | 7      |
| hits[6]        | 7      |
| keyword[7]     | two    |
| docs[7]        | 7      |
| hits[7]        | 7      |
+----------------+--------+

Manticore Search Version:

Manticore 6.3.6 593045790@24080214 (columnar 2.3.0 88a01c3@24052206) (secondary 2.3.0 88a01c3@24052206) (knn 2.3.0 88a01c3@24052206)

Operating System Version:

Debian 11 (running in Docker with image: manticoresearch/manticore)

Have you tried the latest development version?

No

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed
• Changelog updated

[sanikolaev]

@bugsoff Thanks for the bug report. Could you please share your items table files? Here's how you can do it: Uploading your data.