Re: BUG #16031: Group by returns duplicate groups

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: david(dot)raymond(at)tomtom(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16031: Group by returns duplicate groups
Date: 2019-09-30 18:17:14
Message-ID: 18850.1569867434@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> I have a large table which I'm running a query on, grouping on a single
> field, and returning only that 1 field, filtered with a HAVING clause. The
> results that I'm getting back however contain a duplicate entry for one of
> the returned values, which I believe should never be able to happen.

That seems quite weird. What LC_COLLATE/LC_CTYPE settings are you using?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Raymond 2019-09-30 18:21:33 RE: BUG #16031: Group by returns duplicate groups
Previous Message PG Bug reporting form 2019-09-30 18:12:27 BUG #16031: Group by returns duplicate groups