[HACKERS] [sqlsmith] ERROR: badly formatted node string "RESTRICTINFO...
От | Andreas Seltenreich |
---|---|
Тема | [HACKERS] [sqlsmith] ERROR: badly formatted node string "RESTRICTINFO... |
Дата | |
Msg-id | 87tw5x4vcu.fsf@credativ.de обсуждение исходный текст |
Ответы |
Re: [HACKERS] [sqlsmith] ERROR: badly formatted node string "RESTRICTINFO...
Re: [HACKERS] [sqlsmith] ERROR: badly formatted node string "RESTRICTINFO... |
Список | pgsql-hackers |
Hi, I see the above ERROR logged a lot when testing master at eef8c0069e with a postgres_fdw around. Below is a recipe to reproduce it on top of the regression DB. regards, Andreas create extension postgres_fdw; create server myself foreign data wrapper postgres_fdw; create schema fdw_postgres; create user fdw login; grant all on schema public to fdw; grant all on all tables in schema public to fdw; create user mapping for public server myself options (user 'fdw'); import foreign schema public from server myself into fdw_postgres; set max_parallel_workers_per_gather = 8; set parallel_setup_cost = 0; set parallel_tuple_cost = 0; regression=> select (select max(result) from fdw_postgres.num_result) from tt0; ERROR: badly formatted node string "RESTRICTINFO :clause {NULLTEST :"... CONTEXT: parallel worker regression=> explain select (select max(result) from fdw_postgres.num_result) from tt0; QUERY PLAN -------------------------------------------------------------------------------------------Gather (cost=100.06..122.51 rows=1947width=32) Workers Planned: 1 InitPlan 2 (returns $1) -> Result (cost=100.05..100.06 rows=1 width=32) InitPlan 1 (returns $0) -> Limit (cost=100.00..100.05 rows=1 width=74) -> Foreign Scanon num_result (cost=100.00..138.64 rows=831 width=74) -> Append (cost=0.00..22.45 rows=1145 width=0) -> ParallelSeq Scan on tt0 (cost=0.00..2.04 rows=104 width=0) -> Parallel Seq Scan on tt6 (cost=0.00..20.41 rows=1041width=0)
В списке pgsql-hackers по дате отправления: