Re: select distinct does not work on Oracle 8i

From: Van Messner <vmessner_at_bestweb.net>
Date: Fri, 13 Oct 2000 23:10:54 GMT
Message-ID: <2EMF5.6422$mC.449064@monger.newsread.com>

Using distinct on 8.1.6 seems to work. At least I can't make it fail. Where have you seen errors or a listing for a known bug?

Van

"Walter T Rejuney" <BlueSax_at_Unforgetable.com> wrote in message news:39E5BC6E.DB3D2DB5_at_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 Fri Oct 13 2000 - 18:10:54 CDT