BUG #1996: DISTINCT fails with national character varying

Поиск
Список
Период
Сортировка
От Ludmil Tinkov
Тема BUG #1996: DISTINCT fails with national character varying
Дата
Msg-id 20051024212213.3802BF1141@svr2.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #1996: DISTINCT fails with national character varying
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      1996
Logged by:          Ludmil Tinkov
Email address:      ludmil@fyrex.com
PostgreSQL version: 7.3.2
Operating system:   RedHat 9.0
Description:        DISTINCT fails with national character varying
Details:

create table depression(ID int, name national character varying(50))

insert into depression values(1, 'Ана');
insert into depression values(2, 'Ива');
insert into depression values(3, 'Ина');
insert into depression values(4, 'Яна');

select distinct name from depression

--the last statement returns only a single row
--namely: Ана
--it should return 4 rows!

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #1985: cannot insert Chinese character into a table encoded
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1996: DISTINCT fails with national character varying