Re: [HACKERS] another locale problem

>>>Tatsuo Ishii said:
> > SELECT key FROM t WHERE key ~* '^somestring'
> >
> > returns no tuples and explain says it will use the index on key. Why is th
is?
>
> That's strange. It should be seq scan in this case?

I forgot to mention, that if 'somestring' is all uppercase, everything works
(the key field in the table is all uppercase). It still says index scan will
be used.

To summarize the problem. If key contains (equivalent cyrillic letters) 'ABC',
'ABCD', 'DAB' and 'ABX' and the query is:

SELECT key FROM t WHERE key ~* '^AB';

index scan will be used and the correct tuples ('ABC', 'ABCD' and 'ABX') will
be returned. If the query is

SELECT key FROM t WHERE key ~* '^ab';

index scan will be used and no tuples will be returned. With the query

SELECT key FROM t WHERE key ~* 'ab';

sequential scan will be used and the correct tuples will be returned (all of
the above).

> Can you test following case:
>
> SELECT key FROM t WHERE key ~* '^Xsomestring'
>
> where X is one of an ASCII character.

Explain says it will use sequential scan and if I insert proper key in the
table it will be returned.

Daniel