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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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=#
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-12-14 01:35:02 | Re: BUG #2109: NULL=NULL is false |
Previous Message | Neil Parker | 2005-12-13 20:22:21 | BUG #2111: Error parsing 'infinity' under some versions of glibc |