Re: Making Vars outer-join aware - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: Making Vars outer-join aware
Date
Msg-id 20230212235823.GW1653@telsasoft.com
Whole thread Raw
In response to Re: Making Vars outer-join aware  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Making Vars outer-join aware
List pgsql-hackers
On Mon, Jan 23, 2023 at 03:38:06PM -0500, Tom Lane wrote:
> Richard, are you planning to review this any more?  I'm getting
> a little antsy to get it committed.  For such a large patch,
> it's surprising it's had so few conflicts to date.

The patch broke this query:

select from pg_inherits inner join information_schema.element_types
right join (select from pg_constraint as sample_2) on true
on false, lateral (select scope_catalog, inhdetachpending from pg_publication_namespace limit 3);
ERROR:  could not devise a query plan for the given query




pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: ExecRTCheckPerms() and many prunable partitions (sqlsmith)
Next
From: Michael Paquier
Date:
Subject: Re: Generating code for query jumbling through gen_node_support.pl