Request a Demo
Home   >   mailing lists

Re: subquery pullup misses lateral refs in join alias Vars - Mailing list pgsql-hackers

From Richard Guo
Subject Re: subquery pullup misses lateral refs in join alias Vars
Date
Msg-id CAMbWs4_uOn+ZQcxfmUZAxn+68aLQ9veDNRY-Po936NZ=TTCDyw@mail.gmail.com
Whole thread
In response to Re: subquery pullup misses lateral refs in join alias Vars  (Tatsuya Kawata <kawatatatsuya0913@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, Oct 1, 2026 at 8:43 PM Tatsuya Kawata
<kawatatatsuya0913@gmail.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

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation
Next
From: "David G. Johnston"
Date:
Subject: Re: should pg_dumpall --clean apply to database in --exclude-database