Thread: natural join kills postmaster

natural join kills postmaster

From
Nathan Johnson
Date:
-----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-----

Re: natural join kills postmaster

From
Tom Lane
Date:
Nathan Johnson <n@emeraldcomputers.com> writes:
>  PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.3

JOIN syntax isn't implemented (at least not fully or correctly...)
in 7.0.  Update to 7.1.

            regards, tom lane