Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: [BUGS] BUG #14514: Bug in Subquery
Date
Msg-id CAKFQuwZJ+Wi8E5wP4PZSgFP1mft16Q7kvjStT-MvzhE0M6Avpg@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14514: Bug in Subquery  (reva.d91@gmail.com)
List pgsql-bugs
Tree view
On Wed, Jan 25, 2017 at 12:23 AM, <reva.d91@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      14514
Logged by:          Revathi Dharmalingam
Email address:      reva.d91@gmail.com
PostgreSQL version: 9.3.10
Operating system:   Windows 7/Unix
Description:

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.
​

​Working as designed.  The reference to "emno" comes from the "emp" table - this is what is called a correlated subquery.

David J.​

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] BUG #14514: Bug in Subquery
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] could not fork autovacuum worker process: No error