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

Re: BUG #2112: query kills db thread

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim Dew" <jdew(at)yggdrasil(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2112: query kills db thread
Date: 2005-12-14 04:15:10
Message-ID: 12532.1134533710@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Jim Dew" <jdew(at)yggdrasil(dot)ca> writes:
> Stumbled upon a (broken) query that causes the 8.1.0 thread handling the
> query to die:
> select foo from (select null) as foo

Confirmed here --- will look into it.  Thanks for the report!

> Now, this query just produces an error on 8.0.3

However, there's something rotten in the state of Denmark in 8.0 too:

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

7.4 gives what I'd consider a reasonable error message:

regression=# select foo from (select null) as foo;
ERROR:  relation reference "foo" cannot be used as a select-list entry
HINT:  Write "foo".* to denote all the columns of the relation.

Maybe we need a regression test to exercise this case, because it seems
we've been backsliding on this rather badly ...

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Wojciech SobczukDate: 2005-12-14 16:17:10
Subject: BUG #2113: PostgreSQL hangs after running for 2 days
Previous:From: Tom LaneDate: 2005-12-14 04:07:25
Subject: Re: BUG #2111: Error parsing 'infinity' under some versions of glibc

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