Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: here's a good one from dizwell on the recent product launch

Re: here's a good one from dizwell on the recent product launch

From: Mark Townsend <markbtownsend_at_sbcglobal.net>
Date: Thu, 19 Jul 2007 02:35:21 GMT
Message-ID: <469ECDE9.9060302@sbcglobal.net>


Jonathan Lewis wrote:

>
> In reply to a comment on a recent blog entry
> http://dbasrus.blogspot.com/2007/07/vs-b-grand-final.html
>
> Nuno gave me bug 5092688.8
>
> The detail on Metalink is as follows:
>
> This bug is marked as an important issue.
> Versions confirmed as being affected 10.1.0.5, 10.2.0.2
> Description: Wrong results are possible if a function based index exists on
> a table used in a query.
> Workaround: Set "_disable_function_based_index"=TRUE
> Fixed in: 10.2.0.3 (Server Patch Set)
>
> Note the description - this means that if you are on 10.2.0.2
> you MUST upgrade to 10.2.0.3 or you MUST disable
> all function based indexes. (There is currently no separate
> patch reported for the problem).

I looked this one up. Bug was found internally by the Peoplesoft regression testing, it was a regression introduced in 10.1.0.5 and also found in 10.2.0.2. Reported on 13th April, workaround in place on the 21st of April, patches provided and also fixed via the patchset mentioned. Basic problem is if a query is driving to a predicate based on a column, and a filter on the same column uses an FBI, and the query drives to a FFS, then there is a possibility of wrong results (too few rows), in these two releases only. I will check why you can't see the patches in Metalink.

I don't think this is what Nuno is talking about Received on Wed Jul 18 2007 - 21:35:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US