BUG 描述:
This problem is introduced in the 10.2.0.1 base release.
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.
The wrong results show as missing values from the aggregate.
Workaround:
Increase the memory used by hash group by
or
Disable the use of hash group by
eg: set optimizer_features_enable to "10.1.0"
or
set "_gby_hash_aggregation_enabled" to FALSE.
Versions confirmed as being affected 10.2.0.1
10.2.0.2
This issue is fixed in 10.2.0.3 (Server Patch Set)
11g (Future version)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24383181/viewspace-714549/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24383181/viewspace-714549/