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

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

Greetings,

Andres Freund