Skip site navigation (1) Skip section navigation (2)

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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: anisimovt(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6490: Not checking column existence in sub query
Date: 2012-02-27 14:26:02
Message-ID: 20120227142602.GA12584@depesz.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, Feb 27, 2012 at 11:39:55AM +0000, anisimovt(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      6490
> Logged by:          Timofey Anisimov
> Email address:      anisimovt(at)gmail(dot)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/

In response to

pgsql-bugs by date

Next:From: curd.reinertDate: 2012-02-27 18:01:13
Subject: BUG #6494: Listening to * fails for IP V6
Previous:From: anisimovtDate: 2012-02-27 11:39:55
Subject: BUG #6490: Not checking column existence in sub query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group