Re: Errors "failed to construct the join relation" and "failed to build any 2-way joins"

I wrote: > Will Leinweber writes: >> On 12.1, fresh initdb the following query gives me the error >> "ERROR: failed to construct the join relation" > Eyeing the plan produced by v11, I'm suspecting some oversight in > the RTE_RESULT changes (4be058fe9); but I haven't actually bisected. Yup: it'

Re: Errors "failed to construct the join relation" and "failed to build any 2-way joins"

Will Leinweber writes: > On 12.1, fresh initdb the following query gives me the error > "ERROR: failed to construct the join relation" I'm getting an assertion failure in an assert-enabled build, here: (gdb) f 3 #3 0x006f382a in create_lateral_join_info (root=0x2d380c8) at initspla

Errors "failed to construct the join relation" and "failed to build any 2-way joins"

On 12.1, fresh initdb the following query gives me the error "ERROR: failed to construct the join relation" SELECT FROM ( SELECT FROM pg_catalog.pg_stat_bgwriter AS ref_0 LEFT JOIN pg_catalog.pg_stat_bgwriter AS ref_1 ON (true), LATERAL ( SELECT FROM pg_catalog.pg_publication AS r