natural join kills postmaster - Mailing list pgsql-bugs
From | Nathan Johnson |
---|---|
Subject | natural join kills postmaster |
Date | |
Msg-id | 01100418224500.14152@magma Whole thread Raw |
Responses |
Re: natural join kills postmaster
|
List | 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-----
pgsql-bugs by date: