Re: OK, that's one LOCALE bug report too many...

Tom Lane wrote:
> that contains only (or mostly) words like that. But I've got strong
> doubts that the average user of a default RedHat installation expects
> *all* data to get sorted that way, or that he wants us to honor a
> default that he didn't ask for to the extent of disabling LIKE
> optimization to make it work.

The change in collation for RedHat >6.0 is deliberate -- and conforms to
ISO standards. There was noise in an unmentionable list at an
unmentionable time about why it was this way -- and the result was a
seesaw -- it was almost turned back to 'conventional' collation, but was
then put back into ISO-conforming shape.

Ask Trond (teg(at)redhat(dot)com) about it.

> I suppose we could do it that way and add a FAQ entry:
>
> Q. Why are my LIKE queries so slow?
>
> A. Change your locale to C, then dump, initdb, reload.
>
> But somehow I don't think that'll go over well...

Methinks you are very right. Very right.

I am not at all happy about the 'broken' RedHat locale -- the quick and
dirty solution is to remove or rename '/etc/sysconfig/i18n' -- but that
doesn't cure the root issue.

Oh, and to make matters that much worse, on a RedHat system it doesn't
matter if you build with or without --enable-locale -- locale support is
in the libc used, and locale support gets used regardless of what you
select on the configure line :-(. Been there; distributed that in the
6.5.x 'nl' RPM series.

But it sounds to me like you're on the right track, Tom.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11