execute incorect query and get data

From: Marek Wróbel <mwrobel(at)icentrum(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: execute incorect query and get data
Date: 2006-12-14 10:43:03
Message-ID: 45812AB7.8090300@icentrum.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PostgreSQL : 8.2
Operating system: fedora RC4

--------

create table a (a1 integer);
create table b (b1 integer);

insert into a (a1) values (1);
insert into a (a1) values (2);
select a1 from b;

ERROR: column "a1" does not exist at character 8

but :
select a1 from a where a1 not in (select a1 from b);

a1
----
1
2
(2 rows)

when b is not empty :

insert into b (b1) values (1);

select a1 from b;
ERROR: column "a1" does not exist at character 8

but :
select a1 from a where a1 not in (select a1 from b);
a1
----
(0 rows)

select a1 from a where a1 in (select a1 from b);
a1
----
1
2
(2 rows)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew MacLeod 2006-12-14 12:16:18 Re: BUG #2645: pg_restore crashes
Previous Message Danish Siddiqui 2006-12-14 06:47:06 Re: postgresql installation on centOS not working