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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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