Re: Making the regression tests locale-proof

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Making the regression tests locale-proof
Date: 2002-05-10 19:59:31
Message-ID: 1021060771.1991.14.camel@rh72.home.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 2002-05-10 20:12:18 Re: pgaccess
Previous Message Hannu Krosing 2002-05-10 19:48:12 Re: Native Win32, How about this?