-----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-----