From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: milos.urbanek@email.cz
Subject: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)
Date: Sun, 08 May 2022 22:11:03 +0000
Message-ID: <17476-cf579fc6b204baa2@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17476
Logged by: Milos Urbanek
Email address: milos.urbanek@email.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, milos.urbanek@email.cz
Subject: Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)
In-Reply-To: <17476-cf579fc6b204baa2@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox