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

natural join kills postmaster

From: Nathan Johnson <n(at)emeraldcomputers(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: natural join kills postmaster
Date: 2001-10-05 01:22:45
Message-ID: 01100418224500.14152@magma (view raw or flat)
Thread:
Lists: pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

If there is information which I have not provided, but which would be 
usefull, or if the bug can not be reproduced, please let me know.

 PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3
- --installed as a SuSE 7.2 package

The following code is run:

CREATE TABLE k(d CHAR(1),e CHAR(1));
CREATE TABLE l(d CHAR(1),f CHAR(1));
CREATE TABLE m(d CHAR(1),g CHAR(1));
INSERT INTO k VALUES ('d','e');
INSERT INTO l VALUES ('d','f');
INSERT INTO m VALUES ('d','g');
SELECT * FROM k NATURAL JOIN l NATURAL JOIN m;

Here is what happens:

first=# \i /tmp/joinbug.sql
011004.18:17:58.206 [14194] ERROR:  Relation 'k' already exists
psql:/home/n/notes/CorpTrack/joinbug.sql:1: ERROR:  Relation 'k' already 
exists
011004.18:17:58.206 [14194] ERROR:  Relation 'l' already exists
psql:/home/n/notes/CorpTrack/joinbug.sql:2: ERROR:  Relation 'l' already 
exists
011004.18:17:58.207 [14194] ERROR:  Relation 'm' already exists
psql:/home/n/notes/CorpTrack/joinbug.sql:3: ERROR:  Relation 'm' already 
exists
INSERT 19712 1
INSERT 19713 1
INSERT 19714 1
NATURAL JOIN columns are ({ IDENT d})
USING input tables are:
 { ATTR :relname k :attrs ( "d"   "e" )}
 { ATTR :relname l :attrs ( "d"   "f" )}
USING expanded tables are:
 ({ ATTR :relname k :attrs ( "d" )} { ATTR :relname k :attrs ( "e" )})
 ({ ATTR :relname l :attrs ( "d" )} { ATTR :relname l :attrs ( "f" )})
JOIN/USING join columns are ({ ATTR :relname k :attrs ( "d" )})
JOIN/USING left columns are ({ ATTR :relname k :attrs ( "e" )})
JOIN/USING right columns are ({ ATTR :relname l :attrs ( "f" )})
JOIN/USING input quals are ({ IDENT d})
JOIN/USING transformed quals are ({ AEXPR = { ATTR :relname k :attrs ( "d" )} 
{ ATTR :relname l :attrs ( "d" )}})
JOIN/USING shaped table is ({ ATTR :relname k :attrs ( "d" )} { ATTR :relname 
k :attrs ( "e" )} { ATTR :relname l :attrs ( "f" )})
JOIN/USING alias list is ({ ATTR :relname <> :attrs ( "d" )} { ATTR :relname 
k :attrs ( "e" )} { ATTR :relname l :attrs ( "f" )})
Server process (pid 14194) exited with status 11 at Thu Oct  4 18:17:58 2001
Terminating any active server processes...
Server processes were terminated at Thu Oct  4 18:17:58 2001
Reinitializing shared memory and semaphores
psql:/home/n/notes/CorpTrack/joinbug.sql:7: pqReadData() -- backend closed 
the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
psql:/home/n/notes/CorpTrack/joinbug.sql:7: connection to server was lost
011004.18:17:58.226 [14196] DEBUG:  Data Base System is starting up at Thu 
Oct  4 18:17:58 2001
011004.18:17:58.226 [14196] DEBUG:  Data Base System was interrupted being in 
production at Thu Oct  4 18:15:10 2001
011004.18:17:58.231 [14196] DEBUG:  Data Base System is in 
production state at Thu Oct  4 18:17:58 2001
-----BEGIN PGP SIGNATURE-----

iN4EARQDAAYFAju9C3IACgkQiibC6Y3p0vL0bAL/WVasNWO//B0WKawhKDeJR6me
Fp0/20Ag5SOlxE555GQE+vxETiy2Pjaw3K4t6IA3WtI9nch/KOgNttcvHnR9SSO/
8+Un+JULo4jNNHCQPZ+xhgQStnnHCIcyxjxC1WCPAvwJpMl/Fc61K1zBMiwN8vLE
NyF1lTpRems8TGWpL5Xc+xG+mqzYeCgPt1mfTAsHhLOcarwnpBG1lGghKObON0TY
7J+i6bRcFZaOGoo+Utu64nnvRWf5+IrDi7IqA0ueFGc=
=l8/I
-----END PGP SIGNATURE-----

Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-10-05 07:21:01
Subject: Bug #474: Index using problem
Previous:From: Arcady GenkinDate: 2001-10-05 00:13:20
Subject: Re: Long options for psql in 7.1.3

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