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

BUG #2112: query kills db thread

From: "Jim Dew" <jdew(at)yggdrasil(dot)ca>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2112: query kills db thread
Date: 2005-12-13 23:46:53
Message-ID: 20051213234653.290DDF0B2F@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2112
Logged by:          Jim Dew
Email address:      jdew(at)yggdrasil(dot)ca
PostgreSQL version: 8.1.0
Operating system:   OpenBSD
Description:        query kills db thread
Details: 

Stumbled upon a (broken) query that causes the 8.1.0 thread handling the
query to die:

select foo from (select null) as foo

Now, this query just produces an error on 8.0.3

8.1.0:

Welcome to psql 8.1.0, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

suth=# select foo from (select null) as foo;
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>


8.0.3:
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

suth=# select foo from (select null) as foo;
ERROR:  subquery foo does not have attribute 0
suth=#

Responses

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-12-14 01:35:02
Subject: Re: BUG #2109: NULL=NULL is false
Previous:From: Neil ParkerDate: 2005-12-13 20:22:21
Subject: BUG #2111: Error parsing 'infinity' under some versions of glibc

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