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

Mladen,

Thank you.

VC

"Mladen Gogala" <mgogala_at_adelphia.net> wrote in message news:pan.2004.01.11.06.32.12.83564_at_adelphia.net...
> On Tue, 06 Jan 2004 17:45:31 +0000, VC wrote:
>
> > Hello Bob,
> >
> > We discovered the bug when we upgraded to 9.2.0.4. Oracle have been
> > notified but there is no fix yet.
>
>
> There is:
>
> 3110923 RDBMS Server: Patch
> CRASH WITH ''ORDER BY DESC'' ON A CONSTANT COLUMN ORA-3113 9.2.0.4
> 11-DEC-2003
>
> >
> >
> > VC
> >
> > "Bob Burgess" <burgess_at_sympatico.ca> wrote in message
> > 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
>
> --
> None of us is as dumb as all of us.
> (http://www.despair.com/meetings.html)
>
Received on Sun Jan 11 2004 - 09:32:14 CST