Re: Making the regression tests locale-proof - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Making the regression tests locale-proof
Date
Msg-id 1021060771.1991.14.camel@rh72.home.ee
Whole thread Raw
In response to Making the regression tests locale-proof  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Sat, 2002-05-11 at 02:25, Peter Eisentraut wrote:
> The remaining issue is the sort order.  I think this can be solved for
> practical purposes by creating two expected files for each affected test,
> say char.out and char-locale.out.  The regression test driver would try
> the first one, if that fails try the second one.
> 
> The assumption here is that all locales will choose the same sort order as
> long as they're dealing only with the core 26 letters.  This does not have
> to be true in theory, but I think it works for the vast majority of
> practical cases.

et_EE locale has the following order for "core 26 letters" _ are other
letters

ABCDEFGHIJKLMNOPQRS_Z_TUVW____XY  (notice position of Z)

and I'm not sure if V and W are distinguished when sorting words that
have anything after them.

I've heard that in some other locales there are other veir behaviours
(like sorting on or two of the same letters as equivalent)

------------
Hannu




pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Native Win32, How about this?
Next
From: Hannu Krosing
Date:
Subject: Re: Unbounded (Possibly) Database Size Increase - Test