Re: subquery pullup misses lateral refs in join alias Vars

From: Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com>
To: Richard Guo <guofenglinux(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-01 11:43:00
Message-ID: CAHza6qcLzJqDtn6mBd-j4b8DzODUXQ4uNxw+GOVR73fx-+pdRQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!

> Thanks for looking at this. This query seems to be the same as the
> first query in my initial report (with a different targetlist) and has
> already been covered in the test cases of v1 patch.

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.

Regards,
Tatsuya Kawata

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-10-01 11:50:47 Re: pg_dump: ALTER INDEX SET STATISTICS missing for index-backed constraints
Previous Message Narayanan Venkateswaran 2026-10-01 11:21:00 Re: Proposal: Conflict log history table for Logical Replication