AW: Sigh, LIKE indexing is *still* broken in foreign lo cales

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 'Moucha Václav' <MouchaV(at)Radiomobil(dot)cz>
Cc: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: Sigh, LIKE indexing is *still* broken in foreign lo cales
Date: 2000-06-08 09:23:43
Message-ID: 219F68D65015D011A8E000006F8590C604AF7DCA@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> > 3. SQL steps
> > create table test (name text);
> > insert into test values ('á'); # the first char is E1
> from LATIN 2
> > coding
> > insert into test values ('áb');
> > create index test_index on test (name);
> > set cpu_tuple_cost=1; # force backend to use index
> > scanning
> > select * from test where name like 'á%';
>
> > BUG: Only 1 line is selected with 'á' only instead of both lines.
>
> The problem here is that given the search pattern '\341%', the planner
> generates index limit conditions
> name >= '\341' AND name < '\342';

I see that you are addressing a real problem (in german 'o' sorts same as
'ö',
upper case sorts same as lower case)
but ist that related in this case ?

Seems this example has exactly the same first character in both rows,
so the bug seems to be of another class, no ?

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2000-06-08 09:58:12 AW: Big projet, please help
Previous Message Zeugswetter Andreas SB 2000-06-08 09:02:21 AW: Big projet, please help