Bug in 9.2.0.4 when order by constant desc

Got the info' below from www.dba-village.com and thought of sharing it with u guys.

If you try "select 'Hello' from dual order by 1 desc;" you may run into the bug.
It creates a dump in udump and could disconnect your session. Oracle is creating a one-off patch to fix.
The bug is for any order by x, where x is a number, desc and the column is a constant.

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 22 2003 - 00:34:36 CDT