Affected Version: 2.4.2 and 2.5rc0
What steps will reproduce the problem?
1. Initialize pgsql database with f.e. cs_CZ.utf8 locale
2. Install gerrit and use pgsql database, create project, blah, blah, blah...
3. Fill new change using git
4. Click on All/Open Changes in the web interface
What is the expected output?
List of Open/Merged/Abandoned Changes
What do you see instead?
Empty list
Please provide any additional information below.
The problem is in the sql query which uses "T.sort_key<'z'" as a part of the query and the problem is that in some locales (f.e. in cs_CZ) the 0 is after 'z' and not before, hence the empty list.
I have proposed to fix that by:
a) mentioning this in the documentation (immediately)
b) checked for correct sorting (or compatible locale) during installation
c) changing the code to not depend on locale dependant sorting (best and final solution)
Full thread: https://groups.google.com/d/topic/repo-discuss/5Qk1N_GHSkE/discussion
Ondrej