Re: A SQL bug/feature? Non-existent column in select of in-list subquery returns rows instead of ORA-

  • From: Harel Safra <harel.safra@xxxxxxxxx>
  • To: strickland.mark@xxxxxxxxx
  • Date: Tue, 29 Mar 2011 19:41:18 +0200

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

Other related posts: