ORDER BY changes number of rows returned ??

From: Albert H. Behnke <abehnke_at_clark.net>
Date: 1995/08/31
Message-ID: <42346i$j5h_at_clarknet.clark.net>#1/1

I have an SQL statement that returns a good result set when I have ORDER BY 5 ASC, but returns NO (0, zero) rows when I change ASC to DESC ??!!

Does anyone know if this is a known bug?

Example statement follows:

 SELECT

  CTCP.Crt_Comp_Rule_Dt


, CTCP.Crt_Comp

, CTCP.Venue

, CTCP.Jurisdiction

, CTCP.Case_Num

, CASZ.Lead_Staff

, CASZ.Status

, CTCP.Rule_Grp

, CTCP.Sq_Num
, CTCP.Case_Off_Code

FROM

   COURT_COMP           CTCP


,  CASZ                 CASZ

WHERE
CTCP.Case_Num = CASZ.Case_Num
AND
CTCP.Case_Off_Code = CASZ.Case_Off_Code
AND
CTCP.Case_Num LIKE
'95AA%'
ORDER BY
   5 DESC I can also get a good result set returned if I add another sort item, e.g. ORDER BY 5 DESC, 1 ASC

I am using:

Oracle 7.0.16.4.0
AIX 3.2
RS/6000 Received on Thu Aug 31 1995 - 00:00:00 CEST