Thread

1. Locale support broken in latest snapshots

   Oleg Broytmann <phd@phd.russ.ru> — 2000-02-28T10:03:10Z

   Hello!
   
      A month ago I tested a snapshot (21 or 24 Jan), and locale/multibyte
   support worked.
      In the snapshot of 21 Feb locale support have been broken. "SELECT *
   FROM table ORDER BY name" returns rows in wrong order; "SELECT * FROM table
   WHERE name ~* re" performs case-sensitive match.
   
      I remember Tatsuo once fixed case-sensitiveness by replacing char with
   "unsigned char". Should I teach my gcc to always use unsigned chars?
   
   Oleg.
   ---- 
       Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
              Programmers don't die, they just GOSUB without RETURN.
   
   
   

2. Re: [HACKERS] Locale support broken in latest snapshots

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-02-28T14:48:28Z

   Oleg Broytmann <phd@phd.russ.ru> writes:
   >    In the snapshot of 21 Feb locale support have been broken. "SELECT *
   > FROM table ORDER BY name" returns rows in wrong order; "SELECT * FROM table
   > WHERE name ~* re" performs case-sensitive match.
   
   Ugh.
   
   >    I remember Tatsuo once fixed case-sensitiveness by replacing char with
   > "unsigned char". Should I teach my gcc to always use unsigned chars?
   
   No, that's not a solution (since it's not available to non-gcc users).
   We need to find the coding error and fix it.
   
   However, if you can try that as a test to see if it fixes the behavior,
   please do; knowing whether it does will help narrow down what the bug
   could be.
   
   			regards, tom lane
   
   

3. Re: [HACKERS] Locale support broken in latest snapshots

   Oleg Broytmann <phd@phd.russ.ru> — 2000-02-28T15:40:09Z

   Oleg Bartunov gave me the advice to rerun initdb -E KOI8...
   
      And - oops - this helped. Locale test for koi8 locale passed.
   
      It is strange - I did fresh and clean install into empty directory, and
   of course I did initdb -E. Locale tests failed. But stopping postmaster,
   removing data directory, running initdb -E and restarting postmaster
   helped...
   
   On Mon, 28 Feb 2000, Tom Lane wrote:
   > Oleg Broytmann <phd@phd.russ.ru> writes:
   > >    In the snapshot of 21 Feb locale support have been broken. "SELECT *
   > > FROM table ORDER BY name" returns rows in wrong order; "SELECT * FROM table
   > > WHERE name ~* re" performs case-sensitive match.
   > 
   > Ugh.
   > 
   > >    I remember Tatsuo once fixed case-sensitiveness by replacing char with
   > > "unsigned char". Should I teach my gcc to always use unsigned chars?
   > 
   > No, that's not a solution (since it's not available to non-gcc users).
   > We need to find the coding error and fix it.
   > 
   > However, if you can try that as a test to see if it fixes the behavior,
   > please do; knowing whether it does will help narrow down what the bug
   > could be.
   
   Oleg.
   ---- 
       Oleg Broytmann     http://members.xoom.com/phd2/     phd2@earthling.net
              Programmers don't die, they just GOSUB without RETURN.