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(*)
|
Список | 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 по дате отправления: