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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)
Дата
Msg-id 17476-cf579fc6b204baa2@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jobin Augustine
Дата:
Сообщение: Re: Security Definer functions no longer works in PG14+
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17476: ERROR: "variable not found in subplan target list" when running SELECT COUNT(*)