Re: subquery abnormal behavior

On 12/11/06, Shoaib Mir <shoaibmir@gmail.com> wrote:
> I just noticed an abnormal behavior for the subquery:
>
>  create table myt1 (a numeric);
>  create table myt2 (b numeric);
>
>  select a from myt1 where a in (select a from myt2);
>
>  This should be giving an error that column 'a' does not exist in myt2 but
> it runs with any error...
>
>  I had been trying it on 8.2!
Even in 8.1.5 it does not complain. (its not 8.2 specific at least)

Regds
mallah.
>
> Can someone please comment?
>
> Thank you,
> -------------
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
>