Re: Wrong results from a mergejoin

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Wrong results from a mergejoin
Date: 2026-10-21 09:20:09
Message-ID: CAMbWs49kPq7V1HdYCAf-w7j=AsrRoDjr8ftOfA=cMRs23o=mPA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 13, 2026 at 10:32 AM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> The fix seems straightforward: run replace_nestloop_params() on the
> expression before adding it to the targetlist. The annoying part is
> that prepare_sort_from_pathkeys() doesn't have 'root', so we have to
> pass it in from all its callers.

Pushed and back-patched to v14.

- Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Richard Guo 2026-10-21 09:16:45 Re: "variable not found in subplan target lists" with partitionwise join