Thursday, May 04, 2006

HASH GROUP BY can give wrong result in Oracle 10.2

Hit bug 4604970 in our DW environment. This is really bad one and you might not notice that your query returns wrong result until you get negative number on your payslip end of month.
Some one-offs are available and workaround is _GBY_HASH_AGGREGATION_ENABLED=FALSE. Good luck with 10.2!

0 Comments:

Post a Comment

<< Home