PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16510
PG Version11.7
OSUnix (bitnami/postgresql:11.7.0 image)
Opened2020-06-25 13:02:22+00
Reported byAceonline
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16510
Logged by:          Aceonline
Email address:      (redacted)
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;

Messages

DateAuthorSubject
2020-06-25 13:02:22+00PG Bug reporting formBUG #16510: Count Distinct with non distinct column in combination with string constants throws error
2020-06-25 14:18:59+00Daniel GustafssonRe: BUG #16510: Count Distinct with non distinct column in combination with string constants throws error
2020-06-25 14:32:34+00Tom LaneRe: BUG #16510: Count Distinct with non distinct column in combination with string constants throws error
2020-06-25 14:42:18+00Daniel GustafssonRe: BUG #16510: Count Distinct with non distinct column in combination with string constants throws error