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

BUG #6490: Not checking column existence in sub query

From: anisimovt(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6490: Not checking column existence in sub query
Date: 2012-02-27 11:39:55
Message-ID: E1S1yvr-0002PZ-2P@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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;


Responses

pgsql-bugs by date

Next:From: hubert depesz lubaczewskiDate: 2012-02-27 14:26:02
Subject: Re: BUG #6490: Not checking column existence in sub query
Previous:From: Tom LaneDate: 2012-02-26 22:32:53
Subject: Re: BUG #6488: Installation instructions slightly wrong.

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