need buglist of Oracle 8i

From: Bernd Rosenau <brosenau_at_gss-online.de>
Date: Fri, 13 Oct 2000 13:54:58 +0100
Message-ID: <4g1eusoajk7bjbbu0s3m8vdihiodp5fai4@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 - 07:54:58 CDT