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
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14512: Backslashes in LIKE
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] BUG #14512: Backslashes in LIKE