Re: Fix bogus Asserts in calc_non_nestloop_required_outer - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Fix bogus Asserts in calc_non_nestloop_required_outer
Date
Msg-id CA+TgmoZGSmSkRA5ua-xF8_nJeKds6x2vHc0k8Q9C8-dSbdyBZQ@mail.gmail.com
Whole thread Raw
In response to Re: Fix bogus Asserts in calc_non_nestloop_required_outer  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Fix bogus Asserts in calc_non_nestloop_required_outer
List pgsql-hackers
On Fri, Jan 5, 2024 at 4:36 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I don't think I believe this code change, let alone any of the
> explanations for it.  The point of these Asserts is to be sure that
> we don't form an alleged parameterization set that includes any rels
> that are included in the new join, because that would be obviously
> wrong.  They do check that as they stand.  I'm not sure what invariant
> the proposed revision would be enforcing.

Well, this explanation made sense to me:

https://www.postgresql.org/message-id/CAMbWs4-%2BGs0HJ9ouBUb%3DqwHsGCXxG%2B92eJzLOpCkedvgtOWQ%3DQ%40mail.gmail.com

--
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Alexander Cheshev
Date:
Subject: Re: Multidimensional Histograms
Next
From: Paul Jungwirth
Date:
Subject: Re: SQL:2011 application time