Wrong Results Possible on 10.2 When New "HASH GROUP BY" Feature is Used

(Doc ID 387958.1)

Last updated on DECEMBER 01, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.2 to 10.2
Information in this document applies to any platform.
All queries with GROUP BYs clauses


Wrong results possible from the result of a non-distinct aggregation with a group by (such as sum(col)) when HASH GROUP BY is used.
Incorrect results from aggregation functions with a group by that uses the new "HASH GROUP BY" functionality.
The wrong results show as missing values from the aggregate.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms