Re: BUG #14112: sorting v and w is broken with et_EE locate

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Georg Kahest <georg(dot)kahest(at)internet(dot)ee>, PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14112: sorting v and w is broken with et_EE locate
Date: 2016-04-28 05:09:22
Message-ID: CAEepm=1-27wi-F99seXFexbj19XtnxxJNm-C3ouizATCAUQtow@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Apr 28, 2016 at 4:43 PM, Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> On Thu, Apr 28, 2016 at 4:24 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
>> On Wed, Apr 27, 2016 at 9:22 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
>>> On Wed, Apr 27, 2016 at 9:07 PM, Thomas Munro
>>> <thomas(dot)munro(at)enterprisedb(dot)com> wrote:
>>>> That does look odd.
>>>
>>> What happens if you replace the dot in each string with a single 'x'
>>> character, Georg? Does the sort order look correct to you then?
>>
>> I ask because I suspect that this might be the same strcoll() bug I
>> describe here: https://bugzilla.redhat.com/show_bug.cgi?id=1320356
>>
>> (In particular, see my remarks on Austria and Germany.)
>
> No change here. This system has locales-all ("GNU C Library:
> Precompiled locale data") package version 2.19-18+deb8u4 (and same
> libc6).
>
> munro(at)yoga:~/junk$ LC_COLLATE=et_EE.utf8 sort < input
> a1.ee
> vvbwjbln7.ee
> wwvl8.ee
> wxxezi6lkaq7eoi.ee
> vyz.ee
> munro(at)yoga:~/junk$ LC_COLLATE=et_EE.utf8 sort < input2
> a1xee
> vvbwjbln7xee
> wwvl8xee
> wxxezi6lkaq7eoixee
> vyzxee

Same result on a CentOS box. I think the OP should probably write to
bug-glibc-locales(at)gnu(dot)org(dot)

--
Thomas Munro
http://www.enterprisedb.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Кирковский Александр 2016-04-28 07:17:16 Bug report
Previous Message Peter Geoghegan 2016-04-28 04:43:59 Re: BUG #14112: sorting v and w is broken with et_EE locate