The following bug has been logged online: Bug reference: 5898 Logged by: Scott Dunbar Email address: sc...@xigole.com PostgreSQL version: 9.0.3 Operating system: Ubuntu 10.10 Description: Nested "in" clauses hide bad column names Details:
I have a nested in clause like: select respondent_id from respondent where respondent_id in (select respondent_id from chat_session where project_id in (select project_id from project where company_id = 4)); However, in this example, there is no column named respondent_id in the chat_session table. But the query runs and, indeed, returns all of the rows in respondent. Since this was then part of another nested in it deleted far more that it was supposed to. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
