Re: New 8.1.6 bug of the day

buckeye714_at_my-deja.com wrote:
>
> This is a known Oracle Bug and a patch is available. We ran into the
> problem a couple of months ago. We immediately called Oracle Support
> and sent them the tables, some data and the query that returned the bad
> results. They were able to reproduce it in their labs. Turns out it is
> an old Bug with the Rule Based Optimizer that was once fixed but has
> been re-introduced in 8.1 Following is a snippit from the TAR we filed:
>
> <Bug:1176886>
> This bug is effectively a duplicate of <Bug:385681> re-introduced in
> 8.1 If an SMJ and unique index scan and the index scan is known
> to return only a single row then a query may either dump or return
> incorrect results.
> Workaround: Use CBO

Does anyone know how to look up the patch for this? Is it a problem on all platforms or is it specific to Solaris? I've only tested it on Solaris and the bug exists there but some of my colleagues are working with 8.1.5 on NT platforms and if this bug exists on that platform I need to let them know that there is a fix. Received on Mon May 15 2000 - 00:00:00 CDT