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 по дате отправления: