Re: (SQL/PGQ) cache lookup failed for label

On Tue, Jun 9, 2026 at 1:45 AM Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> Hi,
>
> On 2026-06-04 19:21:48 +0800, Ewan Young wrote:
> > The patch is against master and passes make check. On top of your
> > v20260601 series only the test-file hunks conflict (both append to
> > graph_table.sql); the code hunk applies cleanly.
>
> Unfortunately this fails in CI:
> https://github.com/postgresql-cfbot/postgresql/actions/runs/27163049887
>
> #4 0x598104c3 in ExceptionalCondition (conditionName=0x59adcb6c "var->varlevelsup > 0 && var->varlevelsup < root->query_level", fileName=0x59adcb40 "../src/backend/optimizer/util/paramassign.c", lineNumber=126) at ../src/backend/utils/error/assert.c:65
> No locals.
> #5 0x592911f8 in replace_outer_var (root=0x5c92f418, var=0x5c92f708) at ../src/backend/optimizer/util/paramassign.c:126
> retval = <optimized out>
> i = <optimized out>
> #6 0x59258569 in replace_correlation_vars_mutator (node=0x5c92f708, root=0x5c92f418) at ../src/backend/optimizer/plan/subselect.c:2168
> No locals.
> #7 0x59191152 in expression_tree_mutator_impl (node=<optimized out>, mutator=0x592584b0 <replace_correlation_vars_mutator>, context=0x5c92f418) at ../src/backend/nodes/nodeFuncs.c:3556
> targetentry = 0x5c92f6dc
> newnode = 0x5c92fa60
> __func__ = "expression_tree_mutator_impl"
> #8 0x59258541 in replace_correlation_vars_mutator (node=0x5c92f6dc, root=0x5c92f418) at ../src/backend/optimizer/plan/subselect.c:2198
> No locals.
>
> For a full backtrace, see "Core backtraces" e.g. on
> https://github.com/postgresql-cfbot/postgresql/actions/runs/27163049887/job/80183542083

That failure is the result of posting the wrong patch to the wrong
thread. Here's the correct set of patches.

--
Best Wishes,
Ashutosh Bapat