Re: BUG #6490: Not checking column existence in sub query

On Mon, Feb 27, 2012 at 11:39:55AM +0000, anisimovt@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6490
> Logged by:          Timofey Anisimov
> Email address:      anisimovt@gmail.com
> PostgreSQL version: 9.1.2
> Operating system:   Linux
> Description:
>
> SELECT * FROM table1 where col1 in (select col2 from table2)
>
> if col2 exist in table1 and not exist in table2 there will be no error and
> query output all rows from table1;

sure. it is so called "correlated subquery" and it's definitely not
a bug.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/