Re: BUG #17067: FailedAssertion at castNodeImpl

David Rowley <dgrowleyml@gmail.com>

From: David Rowley <dgrowleyml@gmail.com>
To: Richard Guo <guofenglinux@gmail.com>
Cc: cyg0810@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Date: 2021-06-21T11:13:43Z
Lists: pgsql-bugs
On Mon, 21 Jun 2021 at 22:10, Richard Guo <guofenglinux@gmail.com> wrote:
> On Mon, Jun 21, 2021 at 5:48 PM David Rowley <dgrowleyml@gmail.com> wrote:
>> I'm quite surprised that we don't have a test that picks this up.
>
>
>  A distinct group by clause would help to reveal this issue as:
>
>     explain select * from t GROUP BY distinct a, rollup(b);
>
> Maybe we can add a test case to cover it.

Since beta2 deadline is looming, I pushed the simple fix for now. I'll
start a thread on hackers to ask the authors of the patch about
additional testing.

Yaoguang, the fix went in as of [1]. Thanks again for the report.

David

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=8d29d45d9b3cab95a866efbcdd9138b3d76741b3



Commits

  1. Fix assert failure in expand_grouping_sets