ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 2012-01-06 10gR2 HASH GROUP BY BUG

2012-01-06 10gR2 HASH GROUP BY BUG

原创 Linux操作系统 作者:demonat 时间:2012-01-06 17:18:46 0 删除 编辑
新知识点1:10GR2 HASH GROUP BY BUG
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-04-15

  • 博文量
    46
  • 访问量
    91358