About id in search scroll

[Azq2]

The only requirement is that id must be included in the ORDER BY clause to ensure consistent pagination.

Is this a purely formal requirement? Or do the results need to be sorted by ID for this to work effectively?

Queries like this are not effective?

SELECT `reputation`, `id` FROM `users_rt` ORDER BY `reputation` DESC, `id` DESC LIMIT 2; SHOW SCROLL;

[sanikolaev]

The results don’t have to be sorted by ID, but they should include sorting by ID. Of course, you can sort by other criteria as well. The key point is that by default, Manticore doesn’t sort results at all unless there’s a MATCH() or KNN() statement in the query. Even then, fluctuations can still occur because multiple results may have the same weight or KNN distance. Sorting by ID helps prevent this issue.

ORDER BY reputationDESC,id DESC looks good to me.