BUG #16510: Count Distinct with non distinct column in combination with string constants throws error

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16510: Count Distinct with non distinct column in combination with string constants throws error
Дата
Msg-id 16510-755ed3d371542beb@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #16510: Count Distinct with non distinct column incombination with string constants throws error  (Daniel Gustafsson <daniel@yesql.se>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16510
Logged by:          Aceonline
Email address:      aceonline@gmx.de
PostgreSQL version: 11.7
Operating system:   Unix (bitnami/postgresql:11.7.0 image)
Description:

Minimal Reproduction:
CREATE TABLE public.testtable (
column1 int4 NOT NULL,
column2 varchar NULL
);

insert into public.testtable values(1, 'test1');
insert into public.testtable values(2, 'test1');

SELECT
COUNT( DISTINCT (testtable.column2, 'blub') )
FROM
public.testtable;


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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: BUG #16509: Unable to change from 32 bit to 64 bit
Следующее
От: Axel Zellner
Дата:
Сообщение: Bug: Postgresql with Postgis: Different result in coordinateconversion NAV4 <=> WGS84 in Linux and Windows