"Jim Dew" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
