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

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Tue, 06 Jan 2004 11:00:50 -0600
Message-ID: <1bqlvv0gnbf4qebdjgveukr48shqh2obni@4ax.com>

burgess_at_sympatico.ca (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

Can't reproduce the error ( at least on the 8.1.5 and 9.2 I tested it on)

---

  1* select 'A' x from dual order by 1 desc SQL> / X
-
A

SQL>

---

Does your DUAL table have more than 1 row?

Jg Received on Tue Jan 06 2004 - 11:00:50 CST