BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
От | PG Bug reporting form |
---|---|
Тема | BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
Дата | |
Msg-id | 15781-2601b1002bad087c@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault) |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15781 Logged by: Sean Johnston Email address: sean.johnston@edgeintelligence.com PostgreSQL version: 11.2 Operating system: docker image postgres:11.2 Description: Example Query: select exists(select c1 from ft4), avg(c1) from ft4 where c1 = (select max(c1) from ft4); Full Steps (modified from the postgres_fdw regression tests): CREATE EXTENSION postgres_fdw; CREATE SERVER testserver1 FOREIGN DATA WRAPPER postgres_fdw; DO $d$ BEGIN EXECUTE $$CREATE SERVER loopback FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname '$$||current_database()||$$', port '$$||current_setting('port')||$$' )$$; END; $d$; CREATE USER MAPPING FOR CURRENT_USER SERVER loopback; CREATE SCHEMA "S 1"; CREATE TABLE "S 1"."T 3" ( c1 int NOT NULL, c2 int NOT NULL, c3 text, CONSTRAINT t3_pkey PRIMARY KEY (c1) ); CREATE FOREIGN TABLE ft4 ( c1 int NOT NULL, c2 int NOT NULL, c3 text ) SERVER loopback OPTIONS (schema_name 'S 1', table_name 'T 3'); select exists(select c1 from ft4), avg(c1) from ft4 where c1 = (select max(c1) from ft4);
В списке pgsql-bugs по дате отправления: