Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5487~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5487
Choose a head ref
  • 2 commits
  • 4 files changed
  • 2 contributors

Commits on Oct 30, 2025

  1. Enables pull-up of EXISTS subqueries that contain INNER joins, unlock… 

    …ing join reordering and earlier filtering. OUTER joins with outer references are safely excluded to preserve null-preserving semantics.

To achieve this, introduce a mutator that performs a single conservative
pass over the subquery jointree and stops transformation if subquery
contains volatile quals, or OUTER joins with outer references, since
hoisting would break null-preserving behavior.

On the other hand, OUTER joins without such references remain intact.
Add IS NOT NULL guards on hoisted outer Vars to avoid redundant null elements
that obviously won't result after join operation.
Replace affected subquery quals with true.

Author: Alena Rybakina
Reviewers: Ranier Vilela <[email protected]>,
	   Peter Petrov <[email protected]>,
	   Ilia Evdokimov <[email protected]>
    Alena Rybakina authored and Commitfest Bot committed Oct 30, 2025
    Configuration menu
    Copy the full SHA
    8aa8bdf View commit details
    Browse the repository at this point in the history

  2. [CF 5487] v6 - Pull-up subquery if INNER JOIN-ON contains refs to upp… 

    …er-query

This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5487

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/[email protected]
Author(s): Alena Rybakina
    Commitfest Bot committed Oct 30, 2025
    Configuration menu
    Copy the full SHA
    c523939 View commit details
    Browse the repository at this point in the history
Loading