public inbox for [email protected]help / color / mirror / Atom feed
pgsql: postgres_fdw: Avoid pulling up restrict infos from subqueries 2+ messages / 1 participants [nested] [flat]
* pgsql: postgres_fdw: Avoid pulling up restrict infos from subqueries @ 2025-03-25 03:51 Alexander Korotkov <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Alexander Korotkov @ 2025-03-25 03:51 UTC (permalink / raw) To: [email protected] postgres_fdw: Avoid pulling up restrict infos from subqueries Semi-join joins below left/right join are deparsed as subqueries. Thus, we can't refer to subqueries vars from upper relations. This commit avoids pulling conditions from them. Reported-by: Robins Tharakan <[email protected]> Bug: #18852 Discussion: https://postgr.es/m/CAEP4nAzryLd3gwcUpFBAG9MWyDfMRX8ZjuyY2XXjyC_C6k%2B_Zw%40mail.gmail.com Author: Alexander Pyhalov <[email protected]> Reviewed-by: Alexander Korotkov <[email protected]> Backpatch-through: 17 Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/729fe699e61231a01d834078c0566830638440ee Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 38 ++++++++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 32 ++++++++++++++++------ contrib/postgres_fdw/sql/postgres_fdw.sql | 17 ++++++++++++ 3 files changed, 79 insertions(+), 8 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: postgres_fdw: Avoid pulling up restrict infos from subqueries @ 2025-03-25 03:51 Alexander Korotkov <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Alexander Korotkov @ 2025-03-25 03:51 UTC (permalink / raw) To: [email protected] postgres_fdw: Avoid pulling up restrict infos from subqueries Semi-join joins below left/right join are deparsed as subqueries. Thus, we can't refer to subqueries vars from upper relations. This commit avoids pulling conditions from them. Reported-by: Robins Tharakan <[email protected]> Bug: #18852 Discussion: https://postgr.es/m/CAEP4nAzryLd3gwcUpFBAG9MWyDfMRX8ZjuyY2XXjyC_C6k%2B_Zw%40mail.gmail.com Author: Alexander Pyhalov <[email protected]> Reviewed-by: Alexander Korotkov <[email protected]> Backpatch-through: 17 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/023fb512755ffb64949eb6de8464c259ca70f1bd Modified Files -------------- contrib/postgres_fdw/expected/postgres_fdw.out | 38 ++++++++++++++++++++++++++ contrib/postgres_fdw/postgres_fdw.c | 32 ++++++++++++++++------ contrib/postgres_fdw/sql/postgres_fdw.sql | 17 ++++++++++++ 3 files changed, 79 insertions(+), 8 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-03-25 03:51 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-03-25 03:51 pgsql: postgres_fdw: Avoid pulling up restrict infos from subqueries Alexander Korotkov <[email protected]> 2025-03-25 03:51 pgsql: postgres_fdw: Avoid pulling up restrict infos from subqueries Alexander Korotkov <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox