Horton

Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bertrand Mamasam <golgote@gmail.com>
Cc: pgsql-general@postgresql.org
Date: 2024-11-28T16:15:50Z
Lists: pgsql-general 
Bertrand Mamasam <golgote@gmail.com> writes:
> I get this error in PG16.5, 16.6 and 17 :
> wrong varnullingrels (b 3) (expected (b)) for Var 1/19

Please provide a self-contained test case.  A fragmentary query
with no underlying tables is useless for investigation.

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

			regards, tom lane

Commits

  1. Avoid mislabeling of lateral references when pulling up a subquery.

  2. Avoid inserting PlaceHolderVars in cases where pre-v16 PG did not.