No error reported when field in subselect is not part of the table but exists in the main table.

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: pgsql-bugs(at)postgresql(dot)org
Subject: No error reported when field in subselect is not part of the table but exists in the main table.
Date: 2003-01-27 19:42:36
Message-ID: 3E358BAC.E3BA3DE3@nsd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

There is no error reported when a field in the subselect is not part of
the subselect table
but exists in the main table.

Try This:

nsd=# create table a ( f1 int, f2 text);
CREATE
nsd=# create table b ( f3 int, f4 text);
CREATE
nsd=# select * from a where f1 in ( select f1 from b);
f1 | f2
----+----
(0 rows)

nsd=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2003-01-27 19:47:19 Re: No error reported when field in subselect is not part of
Previous Message Żak 2003-01-27 15:58:46 Bug in LIKE operator processing