A SQL bug/feature? Non-existent column in select of in-list subquery returns rows instead of ORA-
From: Mark Strickland <strickland.mark_at_gmail.com>
Date: Tue, 29 Mar 2011 09:47:42 -0700
Message-ID: <AANLkTinH1ijHR24cDtfMk57gozZisR4vvE8C46YDv8KS_at_mail.gmail.com>
11.2.0.1 and 11.2.0.2 on OEL.
Date: Tue, 29 Mar 2011 09:47:42 -0700
Message-ID: <AANLkTinH1ijHR24cDtfMk57gozZisR4vvE8C46YDv8KS_at_mail.gmail.com>
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 - 11:47:42 CDT