RE: BUG #16031: Group by returns duplicate groups - Mailing list pgsql-bugs

From David Raymond
Subject RE: BUG #16031: Group by returns duplicate groups
Date
Msg-id VI1PR07MB6029FB0F82E62287C300563C879D0@VI1PR07MB6029.eurprd07.prod.outlook.com
Whole thread Raw
In response to RE: BUG #16031: Group by returns duplicate groups  (David Raymond <David.Raymond@tomtom.com>)
Responses Re: BUG #16031: Group by returns duplicate groups
List 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
byname 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.

pgsql-bugs by date:

Previous
From: David Raymond
Date:
Subject: RE: BUG #16031: Group by returns duplicate groups
Next
From: Andrew Gierth
Date:
Subject: Re: BUG #16031: Group by returns duplicate groups