BUG #6411: Backend process' crash when a foreign table is used in a dependent subquery on select clause

From: emre(dot)hasegeli(at)tart(dot)com(dot)tr
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6411: Backend process' crash when a foreign table is used in a dependent subquery on select clause
Date: 2012-01-26 12:46:37
Message-ID: E1RqOir-0002Js-Dd@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6411
Logged by: Using a Foreign Table in a Dependent Subquery
Email address: emre(dot)hasegeli(at)tart(dot)com(dot)tr
PostgreSQL version: 9.1.2
Operating system: Linux 3.0.0-14-generic #23-Ubuntu SMP Mon Nov 21 2
Description:

I installed Dave Page's MySQL Foreign Data Wrapper on GitHub [1]. It works
fine until foreign table is used in a dependent subquery on select clause.

How to reproduce:

Create extension mysql_fdw;

Create server AMySQLServer
foreign data wrapper mysql_fdw
options (address '***', port '3306');

Create user mapping for public
server AMySQLServer
options (username '***', password '***');

Create foreign table AForeignTable (id integer) server AMySQLServer options
(query 'Select id from ASchema.ATable');

Select id, (select true from AForeignTable where AForeignTable.id =
ATable.id) from ATable;

WARNING: 57P02: terminating connection because of crash of another server
process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and
repeat your command.

[1] https://github.com/dpage/mysql_fdw

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2012-01-26 14:51:16 Re: One question about VACUUMDB command - please
Previous Message Vik Reykja 2012-01-26 10:43:40 Re: Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"