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)  (Sergei Kornilov <sk@zsrv.org>)
Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15780: Win10 PGS11 installer includes psAdmin3 LTS which does not support PGS11
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #15672: PostgreSQL 11.1/11.2 crashed after dropping apartition table