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