Re: Postgress 13.x: wrong result for delete with subquery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: s(dot)p(dot)e(at)gmx-topmail(dot)de
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Jeff Davis <jdavis(at)postgresql(dot)org>
Subject: Re: Postgress 13.x: wrong result for delete with subquery
Date: 2021-02-05 04:02:45
Message-ID: 75588.1612497765@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I wrote:
> We might be able to salvage this by having find_hash_columns examine
> the Agg node's grpColIdx list and assume that columns listed there need
> to be preserved.

Hearing nothing from Jeff, I went ahead and pushed a fix along that line.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-02-05 04:55:39 BUG #16854: initdb fails on ReFS and FAT32 file systems
Previous Message Neil Chen 2021-02-05 03:07:12 Re: BUG #16846: "retrieved too many tuples in a bounded sort"