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
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 |