Re: Bug? ORA-03113 on ORDER BY DESC (9iR2)

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<3ffb0064$0$19284$626a54ce_at_news.free.fr>...
> "Bob Burgess" <burgess_at_sympatico.ca> a écrit dans le message de
> news:df35b276.0401060842.468de0c6_at_posting.google.com...
> > We're running 9iR2 on Win2k and it seems to have a strange bug which I
> > can't find reference to in Metalink or Google.
> >
> > When I execute this:
> > SELECT 'A' x FROM dual ORDER BY 1 DESC
> > or this:
> > SELECT 'A' FROM dual ORDER BY 1 DESC
> > ...I get an immediate crash of the server thread: ORA-03113
> > End-of-file on communication channel.
> >
> > But this works:
> > SELECT dummy FROM dual ORDER BY 1 DESC
> > and this works also:
> > SELECT 'A' x FROM dual ORDER BY x DESC
> >
> >
> > Does this happen to everyone? The crash seems to happen when sorting,
> > descending, by column position, for an un-named column, whether or not
> > it has an alias.
> >
> > Thanks for any ideas.
> >
> > Bob Burgess
> > Montreal
>
> That's a known bug on 9.2.0.4: n°3110923
> Workaround: try with hint NOPARALLEL (or do not use a constant column in order by).
>
> Regards
> Michel Cadot

Thanks for posting the bug number, 3110923. The metalink report is visible to the public, is dated Dec 2003, and there is no fix as of yet.

HTH -- Mark D Powell -- Received on Mon Jan 12 2004 - 08:25:32 CST