Re: NULLS FIRST problem with numeric fields

From: Federico Albesano - Technical Design S.r.l. <federico.albesanoNOSPAM_at_technicaldesign.it>
Date: Mon, 9 Aug 2004 10:38:49 +0200
Message-ID: <cf7d37$m12$1@fata.cs.interbusiness.it>

"Michel Cadot" <micadot{at}altern{dot}org> ha scritto nel messaggio news:4113964d$0$7777$626a14ce_at_news.free.fr...
> >.........
> > ...ordering NULLS FIRST is wrong if the ordering field is numeric and
there
> > is a PRIMARY KEY constraint on it !!
> > It seems descending order is right even with NULLS FIRST/LAST:
> >............
> > It's very strange and I found no information on Oracle documentation, so
I
> > tinked it's a bug.
> > Is there a patch?
> > I don't know where to look for a bug list/resolved on various versions
of
> > Oracle products.
> >
> > Thanks a lot and regards
> > Federico Albesano
> >
> >
>
> I make the same test and get the same result in 8.1.7.4 but the correct
order in 9.2.0.4.
> It seems there's a bug in 8i but i don't have time to further investigate.
> Maybe someone else knows this issue.
>
> --
> Regards
> Michel Cadot
>
>

Thanks for your time!
I'll try to upgrade to 9.2, but we are software developers supporting Oracle and some our customers have 8.1.7.
Hope they will upgrade soon...

But I would like to know if this is a known bug and if there's a patch for it.
Is there someone who knows about this behaviour??

Thanks again
Federico Albesano Received on Mon Aug 09 2004 - 03:38:49 CDT