Paul,
Thanks for the heads up. The application in question uses a lot of in-line
views, sometimes nested quite a few levels deep. On 7.3, they encountered
various aliasing problems -- needing to alias the column names in the
in-line views even if the name remained the same as the column name when
moving the SQL into PL/SQL blocks. I can't recall if I have seen cases where
they used the same alias for different in-line views at different levels
within an SQL statement (though I wouldn't have expected that to work at
all). It's something to keep an eye out for, thanks.
Also saw a bug in 7.3.4.3 where in-line views using UNION in SELECT
statement in PL/SQL could return incorrect results. That bit them since the
bug was fixed in 7.3.4.4, their development and QA boxes are 7.3.4.5, and
production is 7.3.4.3 (a bug of significant impact kept them from upgrading
prod to 7.3.4.5 -- don't know why they didn't back down test and QA to match
prod). Code that worked fine "broke" when moved to prod. Had a fun weekend
working through that one the first time it was encountered.
One of my concerns is how the CBO is going to behave. Will well behaving SQL
statements go South due to changes in the CBO and how it "calculates" the
most efficient access path.
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, March 06, 2001 11:05 PM
To: Multiple recipients of list ORACLE-L
Larry,
Watch out for non-unique table aliases used in a multi-tiered statement.
(particularly if you're rolling statements dynamically)
Query re-write needs to have the table (or inline view) aliases unique.
That was the only hitch that I saw when upgrading from 7.3.4 to 8.1.6.
Paul
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
