My favorites | Sign in
Project Home Downloads Wiki Issues Source
New issue   Search
for
  Advanced search   Search tips   Subscriptions
Issue 1577: pgsql database queries are (database) locale dependent
3 people starred this issue and may be notified of changes. Back to list
Status:  New
Owner:  ----


Sign in to add a comment
 
Reported by ond...@sury.org, Sep 24, 2012
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
Sign in to add a comment

Powered by Google Project Hosting