RE: 10gR2 Upgrade .. Watch out
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <gkatteri@xxxxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Dec 2006 17:23:27 -0500
I can't seem to find Juan's post can you give an example of a query and
results. I recently upgraded to 10gr2 and we use union all in several
places.
Thanks,
Ken
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of GovindanK
Sent: Wednesday, December 27, 2006 5:01 PM
To: oracle-l
Subject: 10gR2 Upgrade .. Watch out
In an earlier posting , Juan Carlos had mentioned about having problem with
"union all"; We encountered the following after upgrading to 10gR2. Thought
i will share this with the list.
1. Group by was not doing the sort in the default order where as 9.2.0.6 /
9i Rel2 was doing so
2. Same problem with SELECT DISTINCT / SELECT UNIQUE
3. And Recently
SELECT name, SUM(basic) total FROM TEST WHERE basic=20 GROUP BY name ORDER
BY 2 DESC did not work;
If you use SELECT name, SUM(basic) total FROM TEST WHERE basic BETWEEN 20
AND 20 GROUP BY name ORDER BY 2 DESC then it works!!!
Patch number is 5415881.
Please double confirm with your db release by writing simple SQL queries
prior to proceeding. Some of our reports / queries were producing
"different" results after move to 10gRel2. Also check your UNION/UNIONALL
queries.
HTH
GovindanK
Certified DBA
Learning Stops at ... Infinity
Other related posts:
