Re: Wrong results with grouping sets - Mailing list pgsql-hackers

From David Rowley
Subject Re: Wrong results with grouping sets
Date
Msg-id CAApHDvp2_yht8uPLyWO-kVGWZhYvx5zjGfSrg4fBQ9fsC13V0g@mail.gmail.com
Whole thread Raw
In response to Re: Wrong results with grouping sets  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Wrong results with grouping sets
List pgsql-hackers
On Tue, 10 Sept 2024 at 16:04, Richard Guo <guofenglinux@gmail.com> wrote:
> I went ahead and pushed 0001 and 0002, and am now waiting for the
> upcoming bug reports.

Here's one:

create table a(a int);
explain select * from a where exists(Select 1 from a a2 where a.a =
a2.a  group by a);
CREATE TABLE
server closed the connection unexpectedly

TRAP: failed Assert("parse->hasGroupRTE"), File:
"../src/backend/optimizer/plan/planner.c", Line: 794, PID: 107765

David



pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: not null constraints, again
Next
From: Tatsuo Ishii
Date:
Subject: Re: Doc: typo in config.sgml