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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: aceonline(at)gmx(dot)de
Subject: BUG #16510: Count Distinct with non distinct column in combination with string constants throws error
Date: 2020-06-25 13:02:22
Message-ID: 16510-755ed3d371542beb@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Axel Zellner 2020-06-25 13:43:28 Bug: Postgresql with Postgis: Different result in coordinate conversion NAV4 <=> WGS84 in Linux and Windows
Previous Message Daniel Gustafsson 2020-06-25 12:16:23 Re: BUG #16509: Unable to change from 32 bit to 64 bit