Specify description of the SpecialJoinInfo structure

Started by Andrei Lepikhovover 2 years ago1 messageshackers
Beta feature

Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.

appliessuccessCI history

You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:

docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t48948
psql -h localhost -U postgres

Built from patchset v1 (message #1), August 17, 2026 at 10:04 AM.

Every patchset is also pushed to a branch of our PostgreSQL fork, so you can check out the same tree CI built. Without a PostgreSQL checkout:

git clone --branch t48948_1 https://github.com/hackorum-dev/postgres.git

In a checkout you already have, add the fork once:

git remote add hackorum https://github.com/hackorum-dev/postgres.git

then, for this patchset and every later one:

git fetch hackorum t48948_1 && git checkout t48948_1

Patchset v1 (message #1) is on t48948_1

Jump to latest
#1Andrei Lepikhov
lepihov@gmail.com

Hi,

Working on Asymmetric Join, I found slight inconsistency in the
description of SpecialJoinInfo: join type JOIN_ANTI can be accompanied
by a zero value of the ojrelid if this join was created by the
transformation of the NOT EXISTS subquery.

--
regards,
Andrei Lepikhov
Postgres Professional

Attachments:

t48948_1
clarify_sjinfo_description.difftext/plain; charset=UTF-8; name=clarify_sjinfo_description.diffDownload+2-1