| From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
|---|---|
| To: | Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, leis(at)in(dot)tum(dot)de, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #19579: Wrong results regression |
| Date: | 2026-07-31 01:20:17 |
| Message-ID: | CAApHDvoFyJUVBi5wqL6FT0XLJW6cYnUs-1avQ56eR-Urqj5AFw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, 28 Jul 2026 at 17:48, Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com> wrote:
>
> On Tue, 28 Jul 2026 at 06:08, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
>> /*
>> * See if we can reduce down stacked Result nodes to a single node. This
>> * is only possible when the nested Result has no subplan and no gating
>> * qual. If we do remove the nested Result, we maintain the relids and
>> * result_type for EXPLAIN.
>> */
>
>
> Modified the comment as suggested above.
>
> v2 patch attached.
Thank you. Pushed.
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tender Wang | 2026-07-31 02:52:55 | Re: DO NOT pull up a sublink when it has no join condition with the upper relation |
| Previous Message | Tomas Vondra | 2026-07-31 01:19:08 | Re: Hash Semi Join 5,000-50,000x slower on PG18 vs PG17 with 10+ equality columns and NULL values (identical plan, no spill) |