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

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Sun, 11 Jan 2004 06:29:52 GMT
Message-Id: <pan.2004.01.11.06.31.18.495438@adelphia.net>

On Tue, 06 Jan 2004 08:42:59 -0800, Bob Burgess wrote:

> 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.

This is from the metalink:

3110923 	RDBMS Server: Patch
CRASH WITH ''ORDER BY DESC'' ON A CONSTANT COLUMN ORA-3113 	9.2.0.4 

11-DEC-2003 It looks exactly like your problem.

-- 
None of us is as dumb as all of us.
(http://www.despair.com/meetings.html)

Received on Sun Jan 11 2004 - 00:29:52 CST