Re: select distinct does not work on Oracle 8i

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Thu, 12 Oct 2000 09:28:14 -0400
Message-ID: <39E5BC6E.DB3D2DB5@Unforgetable.com>

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. Received on Thu Oct 12 2000 - 08:28:14 CDT