Re: A SQL bug/feature? Non-existent column in select of in-list subquery returns rows instead of ORA-
Date: Tue, 29 Mar 2011 11:07:36 -0700
Message-ID: <AANLkTimzpGX55KXJiNuhcNJfCmNnJa8ySyyo3ZYT-N+f_at_mail.gmail.com>
Yeah, I understand that but it doesn't seem correct to me. The inner query queries dba_tables, not dba_users.
Note that the same behavior exists in SQL Server.
On Tue, Mar 29, 2011 at 10:41 AM, Harel Safra <harel.safra_at_gmail.com> wrote:
> Username in the inner query referenced dba_users since it can't find such a
> column in dba_tables.
>
> Harel Safra
> Sent from my phone.
> On Mar 29, 2011 6:50 PM, "Mark Strickland" <strickland.mark_at_gmail.com>
> wrote:
> > 11.2.0.1 and 11.2.0.2 on OEL.
> >
> > Try "select * from dba_users where username in (select username from
> > dba_tables)". It returns all the rows from dba_users instead of returning
> > an error. Perhaps this is consistent with SQL 92 but I don't see how. Did
> > Dr. Codd really intend this? If it is expected behavior, I'm willing to
> > except the shunning and ridicule (even from Mladen). One of our
> developers
> > discovered this yesterday with application tables and I confirmed it with
> an
> > equivalent query of data dictionary tables and opened an SR. Can someone
> > confirm this in 10g?
> >
> > Mark Strickland
> > Seattle, WA
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 29 2011 - 13:07:36 CDT