Re: [Bug]Assertion failure in LATERAL GRAPH_TABLE with multi-label pattern

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
Cc: SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: [Bug]Assertion failure in LATERAL GRAPH_TABLE with multi-label pattern
Date: 2026-06-05 07:35:52
Message-ID: 29e94b99-7190-4d72-b465-c1b7842fab34@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 02.06.26 13:02, Ashutosh Bapat wrote:
> Yes, fix is at the right place. We can not set the varlevelsup to the
> correct value in replace_properties_references itself because when
> that function is called, we do not know whether UNION is required or
> not. The next place to adjust varlevelsup is when creating a UNION
> statement.
>
> Depending upon the varno of outer reference we will see different
> symptoms. a crash or an error "plan should not reference subplan's
> variable" or even data type mismatch. Also the levelsup is maintained
> in nodes other than Var. I have modified the commit message to focus
> on the problem instead of the symptom. Also some small edits to the
> comments.
>
> Attached patch has the number 0010 (vs 0001) since I am creating
> patches for all the SQL/PGQ fixes from the same branch. It can be
> applied independent of other patches.

committed

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message webbohan 2026-06-05 07:42:58 回复:Fix missing semicolon in pl_gram.y for option_value rule
Previous Message Hans Buschmann 2026-06-05 07:15:29 AW: PG19beta1: GCC 16.1.1 warning: ‘actual_arg_types’ may be used uninitialized in clauses.c