Friday, July 16, 2004, 9:55:42 AM, Stephane Faroult (sfaroult@(protected)) wrote:
SF > On this point alone I wouldn 't say that optimization changes the result. We
SF > have here a 3-valued logic again :
SF > - expected results
SF > - wrong results
SF > - failure
Yes, this is one way of looking at the issue. And until I
put together some sort of clean, conceptual, mental model
for thinking about subqueries that also accounts for the
behavior Stephen encountered, I won 't be able to rest. This
is very important to me. Ultimately, I need to go away and
reflect for awhile, do some research, etc.
Oh, and while I *understand* the behavior, I may not, in the
end, *agree* with it, and in that sense I could end up in
the same boat as Date, who has been vainly complaining about
nulls for as long as I can remember. Perhaps 20 years from
now I will be that lone voice in the wilderness who is
ranting about subqueries <grin >.
I 'm keeping an open mind at the moment though.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@(protected)
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request@(protected) and
include the word "subscribe " in either the subject or body.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
