Re: need buglist of Oracle 8i

    On Metalink you can get the readme document for each patch. Those docs list the bugs that have been fixed by the patch. Metalink also has a searchable bug database. Searching on "distinct" does not show any bugs like yours.

    It's hard to imagine you or your client will be happier with 8.0.6 than with 8.1.6. What happens when you select unique instead of select distinct?

Van

"Bernd Rosenau" <brosenau_at_gss-online.de> wrote in message news:4g1eusoajk7bjbbu0s3m8vdihiodp5fai4_at_4ax.com...
> On Thu, 12 Oct 2000 09:28:14 -0400, in comp.databases.oracle.misc you
> wrote:
>
> >Bernd Rosenau wrote:
> >
> >> Hello,
> >>
> >> our application is programmed in VB 6 and connects to an Oracle
> >> database
> >> using ADO. The following statement submitted from the client works ok
> >> if the backend is Oracle 8.0.5 but it is giving non-distinct results
> >> when the backend is Oracle 8i.
> >>
> >> SELECT DISTINCT Bereich FROM GenericTable
> >>
> >> What can i do ?
> >>
> >> Many thanks in advance for your help,
> >>
> >> Regards, Bernd
> >
> >Known bug. Make sure you do an ANALYZE TABLE on the table and that should
> >solve the problem. Otherwise you could alter your session to specifically
> >select the rule-based optimizer.
> >
>
> Thank you very much for your answer. Is there a buglist for
> Oracle 8i ? I am afraid i have to convice our client (who has chosen
> Oracle 8i) to switch to Oracle 8.0.6 and i need arguments to do this.
>
> Many thanks in advanve,
>
> Regards, Bernd
>
>
Received on Fri Oct 13 2000 - 18:19:13 CDT