Re: [BUGS] BUG #14514: Bug in Subquery - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14514: Bug in Subquery
Date
Msg-id 9453.1485358153@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14514: Bug in Subquery  (reva.d91@gmail.com)
Responses Re: [BUGS] BUG #14514: Bug in Subquery  (Pantelis Theodosiou <ypercube@gmail.com>)
List pgsql-bugs
reva.d91@gmail.com writes:
> It is ignoring the invalid columns in subquery,Instead of throwing the error
> 'Column does not exist'.

> (eg):
> select * from emp where (empname,empid,empno) in(selec emname,emid,emno from
> em_details)

> Note:There is no emno in em_details table.

Maybe not, but if there is one in emp, then this query is legal per
SQL spec --- emno is an outer reference.

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14512: Backslashes in LIKE
Next
From: "David G. Johnston"
Date:
Subject: Re: [BUGS] BUG #14514: Bug in Subquery