Bug in 10.2.0.5 for query using index on trunc(date)
Hi,
I already posted this on the OTN forums. I repost this as a FYI for dba's using 10.2.0.5.
Although we already have a work-around in place, comments welcome!
Regards,
Henk Enting
(post on otn: http://forums.oracle.com/forums/thread.jspa?forumID=61&threadID=1113651)
Original post (on OTN):
Hi,
We recently upgraded from 10.2.0.3 to 10.2.0.5 (enterprise edition, 64bit linux). This resulted in some strange behaviour, which I think could be the result of a bug.
In 10.2.0.5, after running the script below the final select statement will give different results for TRUNC(b) and TRUNC (b + 0). Running the same script in 10.2.0.3 the select statement returns correct results.
I already posted this on the OTN forums. I repost this as a FYI for dba's using 10.2.0.5.
Although we already have a work-around in place, comments welcome!
Regards,
Henk Enting
(post on otn: http://forums.oracle.com/forums/thread.jspa?forumID=61&threadID=1113651)
Original post (on OTN):
Hi,
We recently upgraded from 10.2.0.3 to 10.2.0.5 (enterprise edition, 64bit linux). This resulted in some strange behaviour, which I think could be the result of a bug.
In 10.2.0.5, after running the script below the final select statement will give different results for TRUNC(b) and TRUNC (b + 0). Running the same script in 10.2.0.3 the select statement returns correct results.
0