Re: [BUGS] BUG #14514: Bug in Subquery
| От | John McKown |
|---|---|
| Тема | Re: [BUGS] BUG #14514: Bug in Subquery |
| Дата | |
| Msg-id | CAAJSdjj4MCa+eVE1nmLsy+f2z526+9vTR8wJiTFAovVh=T2evw@mail.gmail.com обсуждение исходный текст |
| Ответ на | [BUGS] BUG #14514: Bug in Subquery (reva.d91@gmail.com) |
| Список | pgsql-bugs |
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
—Jeff Polk
Maranatha! <><
John McKown
John McKown
В списке pgsql-bugs по дате отправления: