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 - 00:30:47 CST
