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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 06 Jan 2004 10:26:05 -0800
Message-ID: <1073413482.113650@yasure>

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

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jan 6 10:17:43 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production

SQL> SELECT 'A' x FROM dual ORDER BY 1 DESC; SELECT 'A' x FROM dual ORDER BY 1 DESC
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL> What causes it is the ORDER BY DESC. with a single literal value. ORDER BY and ORDER BY ASC do not cause the problem. I created a test table with two records and it did the same thing.

SQL> select testcol from test order by 1 desc;

TESTCOL

---

Y
Y
Y

SQL> select 'Y' from test order by 1 desc; select 'Y' from test order by 1 desc
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue Jan 06 2004 - 12:26:05 CST