Re: Wrong results with grouping sets

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Wrong results with grouping sets
Date: 2024-10-10 06:39:17
Message-ID: CAApHDvp2_yht8uPLyWO-kVGWZhYvx5zjGfSrg4fBQ9fsC13V0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 10 Sept 2024 at 16:04, Richard Guo <guofenglinux(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2024-10-10 07:00:41 Re: Doc: typo in config.sgml
Previous Message jian he 2024-10-10 06:30:32 Re: not null constraints, again