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

"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 Received on Tue Jan 06 2004 - 12:38:55 CST