Skip site navigation (1) Skip section navigation (2)

BUG #6411: Backend process' crash when a foreign table is used in adependent 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 adependent subquery on select clause
Date: 2012-01-26 12:46:37
Message-ID: E1RqOir-0002Js-Dd@wrigleys.postgresql.org (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group