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

From John McKown
Subject Re: [BUGS] BUG #14514: Bug in Subquery
Date
Msg-id CAAJSdjj4MCa+eVE1nmLsy+f2z526+9vTR8wJiTFAovVh=T2evw@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14514: Bug in Subquery  (reva.d91@gmail.com)
List pgsql-bugs
On Wed, Jan 25, 2017 at 1: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.


Note: just user, not developer.

​I tried to duplicate your error​ in PostgreSQL 9.5.5 on Fedora Linux 25, 64 bit. I got the expected "column does not exist". Can you try version 9.5 or even 9.6 to see if the bug is squashed in a later Windows version?


--
There’s no obfuscated Perl contest because it’s pointless.

—Jeff Polk

Maranatha! <><
John McKown

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 #14512: Backslashes in LIKE