Re: subquery pullup misses lateral refs in join alias Vars

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: subquery pullup misses lateral refs in join alias Vars
Date: 2026-10-06 05:56:21
Message-ID: CAMbWs4_uOn+ZQcxfmUZAxn+68aLQ9veDNRY-Po936NZ=TTCDyw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 1, 2026 at 8:43 PM Tatsuya Kawata
<kawatatatsuya0913(at)gmail(dot)com> wrote:
> Sorry for the confusion. Yes, it's the same query as yours. I just
> wanted to note that without asserts it silently returns wrong results
> (1 row instead of 4) rather than raising an error, in case that's
> useful for the back-patch decision.

Thanks! Yeah, this warrants a back-patch. I've pushed the fix and
back-patched it to all supported branches.

- Richard

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Masahiko Sawada 2026-10-06 05:46:04 Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation