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

Re: execute incorect query and get data

From: Marek Wróbel <mwrobel(at)icentrum(dot)pl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: execute incorect query and get data
Date: 2006-12-15 09:01:11
Message-ID: 45826457.1000804@icentrum.pl (view raw or flat)
Thread:
Lists: pgsql-bugs
Him,

Tom Lane napisał(a):
> =?ISO-8859-2?Q?Marek_Wr=F3bel?= <mwrobel(at)icentrum(dot)pl> writes:
>> 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);
> 
> This is not a bug, it's an outer reference.  Read any SQL book ...

of course... so sorry... I was such startled off result off this query,
that I can't see that...

In response to

pgsql-bugs by date

Next:From: SeanDate: 2006-12-15 16:07:17
Subject: BUG #2829: Runaway logs - "SSL SYSCALL error"
Previous:From: CN LiouDate: 2006-12-15 04:36:24
Subject: BUG #2827: AV occurs to libpq with newer versions of wine

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