Re: pull-up subquery if JOIN-ON contains refs to upper-query

Alena Rybakina <a.rybakina@postgrespro.ru>

From: Alena Rybakina <a.rybakina@postgrespro.ru>

To: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>, David Rowley <dgrowleyml@gmail.com>

Cc: Ranier Vilela <ranier.vf@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Peter Petrov <p.petrov@postgrespro.ru>

Date: 2025-09-05T11:31:04Z

Lists: pgsql-hackers

Attachments

v5-0001-Enables-pull-up-of-EXISTS-subqueries-tha.patch (text/x-patch) patch v5-0001

Hi, I rebased the patch and fixed earlier problem.

On 03.09.2025 00:20, Alena Rybakina wrote:
>
> I'll look at this. I need some time to consider it.
>
> I'm working on this approach right now. I introduced mutator and made 
> the transformation if it is possible there but I need to fix some bugs.
>