Re: BUG #2755: strange select behavior

From: tomas(at)tuxteam(dot)de
To: Basil Evseenko <evseenko(at)sysoft(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2755: strange select behavior
Date: 2006-11-13 05:42:08
Message-ID: 20061113054208.GA6703@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, Nov 12, 2006 at 04:49:33PM +0000, Basil Evseenko wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2755
[...]
> # \d tables.cart
[no cart_id field]

> # \d tables.download
[cart_id field]

> # SELECT count(1) from tables.download where cart_id in (select cart_id from
[...]
> # select cart_id from tables.cart where user_id=1;
> ERROR: column "cart_id" does not exist

> Why in the first case select doestn't raise syntax error, but use cart_id
> from tables.download?
> Is this bug or a feature?

AFAIK this is SQL spec. The unqualified column name in the first query
is resolved to the FROM in the outer query (because the inner query has
no table with such a column). So no, I don't think it's a bug.

In the second query there is no table with a "cart_id" column.

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFWAWwBcgs9XrR2kYRAthwAJ9ksfDABoH+A8KGJh3/kwwsQsdItwCdHsBT
Yl2kyzm7pblE4fyeLPlKarI=
=7r9p
-----END PGP SIGNATURE-----

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2006-11-13 09:00:59 Re: 8.2beta1 (w32): server process crash (tsvector)
Previous Message Toru SHIMOGAKI 2006-11-13 04:58:02 Re: [HACKERS] [PATCHES] BUG #2704: pg_class.relchecks overflow