Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19653: "variable not found in subplan target list" during
 planning with parallel parameterized nested loop,
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: 10215501441@stu.ecnu.edu.cn
Reply-To: 10215501441@stu.ecnu.edu.cn, pgsql-bugs@lists.postgresql.org
Date: Fri, 04 Sep 2026 06:41:33 +0000
Message-ID: <19653-9352cc6ba17b662f@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/19653-9352cc6ba17b662f%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19653
Logged by:          Annie
Email address:      10215501441@stu.ecnu.edu.cn
PostgreSQL version: 18.6
Operating system:   Ubuntu 20.04.6 LTS (Focal Fossa)=EF=BC=8Cx86_64
Description:       =20

## Description

A query using a partitioned left/right join split, with
`enable_partitionwise_join`, parallel settings, and `GROUP BY ROLLUP` fails
at planning time with:

```
ERROR: variable not found in subplan target list
```

The same query against a single non=E2=80=91partitioned table works correct=
ly. The
error occurs during plan construction, not execution.

The problem arises when all of the following are true:

1. The right table of a join has **no statistics** (only left table is
analyzed), causing the planner to choose a **parameterized nested loop**.
2. **Parallel query** is enabled with very low cost parameters, leading to a
`Gather` node.
3. `GROUP BY ROLLUP` produces a **MixedAggregate** node that trims the child
targetlist to only required columns.
4. The inner index scan of the nested loop has a filter that references both
outer and inner columns (e.g., `m_l.tsvec @@ tsq`), but the inner subplan
targetlist no longer contains the outer column after trimming.

## How to reproduce

```sql
-- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Database setup =3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D
DROP DATABASE IF EXISTS repro_postgres810_db3_min;
CREATE DATABASE repro_postgres810_db3_min;
\c repro_postgres810_db3_min;

-- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Session parameters =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
SET enable_partitionwise_join =3D on;
SET enable_partition_pruning =3D on;
SET enable_partitionwise_aggregate =3D on;
SET enable_parallel_append =3D on;
SET enable_parallel_hash =3D on;
SET max_parallel_workers_per_gather =3D 2;
SET min_parallel_table_scan_size =3D 0;
SET parallel_setup_cost =3D 0;
SET parallel_tuple_cost =3D 0;

-- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Single source table =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
CREATE TABLE m_src(rowid bigint PRIMARY KEY, tsvec tsvector, tsq tsquery);
INSERT INTO m_src VALUES
 (1, to_tsvector('english','quick brown fox'), to_tsquery('english','alpha &
beta')),
 (2, to_tsvector('english','quick brown fox'), to_tsquery('english','alpha &
beta')),
 (3, to_tsvector('english','quick brown fox'), to_tsquery('english','alpha &
beta'));

-- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Left/right partitioned tables =3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
CREATE TABLE m_l(rowid bigint PRIMARY KEY, tsvec tsvector) PARTITION BY
RANGE (rowid);
CREATE TABLE m_l_p1 PARTITION OF m_l FOR VALUES FROM (1) TO (10);
INSERT INTO m_l SELECT rowid, tsvec FROM m_src;

CREATE TABLE m_r(rowid bigint PRIMARY KEY, tsq tsquery) PARTITION BY RANGE
(rowid);
CREATE TABLE m_r_p1 PARTITION OF m_r FOR VALUES FROM (1) TO (10);
INSERT INTO m_r SELECT rowid, tsq FROM m_src;

-- Only analyze left table; right table has no statistics
ANALYZE m_l;

-- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =E2=91=A0 Single=E2=80=91table quer=
y (works) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
SELECT ARRAY['', '']::TEXT[] FROM m_src
WHERE NOT (m_src.tsvec @@ m_src.tsq)
GROUP BY ROLLUP (ARRAY['', '']::TEXT[]);

-- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =E2=91=A1 Multi=E2=80=91table query=
 (fails) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
SELECT ALL ARRAY['', '']::TEXT[] FROM (
  SELECT COALESCE(m_l.rowid, m_r.rowid) AS rowid, m_l.tsvec AS tsvec,
m_r.tsq AS tsq
  FROM m_l JOIN m_r ON m_l.rowid =3D m_r.rowid
) s
WHERE NOT (s.tsvec @@ s.tsq)
GROUP BY ROLLUP (ARRAY['', '']::TEXT[]);
```

## Expected behavior

The multi=E2=80=91table query should return the same result as the single=
=E2=80=91table
query: two rows (`""` and `{"",""}`), without any error.

## Actual behavior

The query fails with:

```
ERROR: variable not found in subplan target list
```

This error is raised during planning (in the `setrefs.c` phase), not during
execution.

## Additional notes

The plan shape for the failing query is roughly:

```
MixedAggregate
  ->  Gather
        ->  Nested Loop
              ->  Parallel Seq Scan on m_l_p1
              ->  Index Scan on m_r_p1
                    Index Cond: (rowid =3D m_l.rowid)
                    Filter: (m_l.tsvec @@ tsq)
```

After `MixedAggregate` trims the targetlist, the inner index scan still
references `m_l.tsvec` (an outer variable passed as a parameter), but it is
no longer present in the subplan targetlist, leading to the error.