Number of strings changes when changing ordering

[tomkolp]

Describe the bug

Incorrect number of empty strings after using the "Number of words" sort.

To Reproduce the bug

Description should look similar to this:

Steps to reproduce the behavior:

1. Go to 'Hosted Weblate -> Documentation->Polish
2. Click "Not translated strings" (4,406 strings)
3. Sort by "Number of words" (the total number of strings increases from 4,406 to 4,564)

Screenshots

[nijel]

I can't reproduce it - it still shows same number. What might have happened: The search result is cached in session for a user to give consistent results while he is changing the strings (otherwise translated strings would disappear from the search). Changing the sort order stops using the cache and fetches the data from the database. Not sure if we can do something effective to address this.

[tomkolp]

I can't reproduce it - it still shows same number. What might have happened: The search result is cached in session for a user to give consistent results while he is changing the strings (otherwise translated strings would disappear from the search). Changing the sort order stops using the cache and fetches the data from the database. Not sure if we can do something effective to address this.

Mobile version, android 9, I haven't tried for pc.

[tomkolp]

The problem occurs after translating several segments. You have to translate a few segments, stop the translation and come back to it. After sort change, the initial (greater than current) number of segments is loaded. It looks like it's reading from the cache. After a few hours, the number of segments is up-to-date.
The problem occurs on both the desktop computer and the phone.

[nijel]

That's the issue I've described in #5105 (comment). The list of matching strings is fetched first time the query (including ordering) is used. You then browse the cached result to be able to go to previous strings which might no longer match the conditions. The solution might be to reuse the existing cached string list when changing ordering.