On Mon, Nov 20, 2017 at 4:26 PM, <tanes@siamscan.net> wrote:
> Not sure if this is a bug or feature but when I query with sub select while
> sub select has invalid column the query is still valid and running. For
> example:
>
> create temp table a ( id integer, descr text);
> create temp table b ( b_id integer, descr text);
>
> # select * from a where id=(select id from b where descr='A');
>
> id | descr
> ----+-------
> (0 rows)
>
> # select id from b where descr='A';
>
> ERROR: column "id" does not exist
> LINE 1: select id from b where descr='A';
> ^
There is no bug here. The subquery should look at the column b_id
which is defined for relation b, so the error is normal.
--
Michael