BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: milos(dot)urbanek(at)email(dot)cz
Subject: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)
Date: 2022-05-08 22:11:03
Message-ID: 17476-cf579fc6b204baa2@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17476
Logged by: Milos Urbanek
Email address: milos(dot)urbanek(at)email(dot)cz
PostgreSQL version: 14.2
Operating system: Windows 2012 R2 Foundation
Description:

Trying to run simple SELECT COUNT(*) from some table gives me the following
error (either running by hand or trying to run EXPLAIN using pgadmin or by
hand):

2022-05-09 00:06:30.428 CEST [1196] ERROR: variable not found in subplan
target list
2022-05-09 00:06:30.428 CEST [1196] STATEMENT: SELECT COUNT(*) FROM
"domino_efekty_havarijniprojev"
2022-05-09 00:06:31.884 CEST [1196] ERROR: variable not found in subplan
target list
2022-05-09 00:06:31.884 CEST [1196] STATEMENT: EXPLAIN (FORMAT JSON,
ANALYZE false, VERBOSE false, COSTS false, TIMING false, BUFFERS false,
SUMMARY false, SETTINGS false) SELECT COUNT(*) FROM
"domino_efekty_havarijniprojev"
2022-05-09 00:06:39.820 CEST [1196] ERROR: variable not found in subplan
target list
2022-05-09 00:06:39.820 CEST [1196] STATEMENT: EXPLAIN SELECT COUNT(*) FROM
"domino_efekty_havarijniprojev"

Differences against standard config:
shared_buffers = 8192MB
effective_cache_size = 16GB
cursor_tuple_fraction = 1.0

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-05-09 00:22:01 Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)
Previous Message Jobin Augustine 2022-05-08 07:03:25 Re: Security Definer functions no longer works in PG14+