RE: BUG #16031: Group by returns duplicate groups

From: David Raymond <David(dot)Raymond(at)tomtom(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #16031: Group by returns duplicate groups
Date: 2019-10-01 18:34:38
Message-ID: VI1PR07MB6029FB0F82E62287C300563C879D0@VI1PR07MB6029.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I checked for other places where there was weirdness going on and there are more.

testing=> create temp table weird as with foo as (select name from big_table group by name) select name from foo group by name having count(*) > 1;
SELECT 23
Time: 700304.130 ms (11:40.304)

Hilariously enough 'DK' isn't in these 23.

Did initdb let me pick a locale that doesn't actually exist?

I'm beginning to feel like I need an exorcist.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2019-10-01 19:26:56 Re: BUG #16031: Group by returns duplicate groups
Previous Message David Raymond 2019-10-01 16:25:32 RE: BUG #16031: Group by returns duplicate groups