Re: [PORTS] Port Bug Report: Incorrect search using 'select .... like ...' statement.
От | Bruce Momjian |
---|---|
Тема | Re: [PORTS] Port Bug Report: Incorrect search using 'select .... like ...' statement. |
Дата | |
Msg-id | 199905131556.LAA13253@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Port Bug Report: Incorrect search using 'select .... like ...' statement. (Unprivileged user <nobody>) |
Список | pgsql-ports |
> Sometimes expresion like 'select a from b where a like 'abc%';' gives > null result, while 'select a from b where a like 'abcd%';' gives > right result (several records). In some case first expression > gives some result but it doesn't contains result of the second > one... But expresion '... like 'ab%';' gives result containing > results of the first an the second. > > -------------------------------------------------------------------------- > > Test Case: > ---------- > All fields I tried contain russian characters (there was some > fields with english characters but I don't find such error with them) > > > example: > > vkuzmina=> select tit from cvcat where lower(tit) like '���������%'; > tit > ----------------- > ��������� � ����� > (1 row) > > vkuzmina=> select tit from cvcat where lower(tit) like '��������%'; > tit > --- > (0 rows) > > vkuzmina=> select tit from cvcat where lower(tit) like '�������%'; > tit > ----------------- > ��������� � ����� > (1 row) > > vkuzmina=> select tit from cvcat where tit like '�������%'; > tit > ----------------- > ��������� � ����� > (1 row) > > vkuzmina=> select tit from cvcat where tit like '��������%'; > tit > --- > (0 rows) > > vkuzmina=> select tit from cvcat where tit like '���������%'; > tit > ----------------- > ��������� � ����� > (1 row) > We have some problems with international characters sets and index usage. Someone else will probably give a better answer. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-ports по дате отправления: