PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15781
PG Version11.2
OSdocker image postgres:11.2
Opened2019-04-25 13:32:31+00
Reported bySean Johnston
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15781
Logged by:          Sean Johnston
Email address:      (redacted)
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);

Messages

DateAuthorSubject
2019-04-25 13:32:31+00PG Bug reporting formBUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-25 14:20:17+00Sergei KornilovRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-25 18:24:41+00Tom LaneRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-25 20:20:59+00Dmitry DolgovRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-25 20:27:35+00Tom LaneRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-25 20:36:14+00Tom LaneRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-26 12:39:46+00Etsuro FujitaRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-26 17:10:00+00Tom LaneRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-27 13:30:37+00Etsuro FujitaRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)
2019-04-27 14:47:13+00Tom LaneRe: BUG #15781: subselect on foreign table (postgres_fdw) can crash (segfault)