Re: ORDER BY changes number of rows returned ??

Albert H. Behnke (70272.3105_at_compuserve.com) writes:
> 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?

   Definitely this is a bug. My guess is the 7.0.16 cost based optimizer is the culprit. Slap in a /*+ RULE +*/ hint and see if life improves.

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##