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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | curd.reinert | 2012-02-27 18:01:13 | BUG #6494: Listening to * fails for IP V6 |
Previous Message | anisimovt | 2012-02-27 11:39:55 | BUG #6490: Not checking column existence in sub query |