Re: Index question

From: Mladen Gogala <gogala.mladen_at_bogus.email.invalid>
Date: Wed, 26 Aug 2009 07:27:07 +0000 (UTC)
Message-ID: <h72o4b$oig$12_at_solani.org>

Na Tue, 25 Aug 2009 09:12:14 -0700, Steve Howard napisao:

> MIN(JRN_SEQ)
> ------------
> 1019514075
>
> SQL> select jrn_seq from xwc.xwc_change_history where jrn_seq between
> 1019514060 and 1019514080 order by 1;
>
> JRN_SEQ
> ----------
> 1019514072
> 1019514073
> 1019514074
> 1019514075
> 1019514076
> 1019514077
> 1019514078
> 1019514079
> 1019514080
>
> 9 rows selected.
>
> SQL>
>
> Thanks,
>
> Steve

This must be a bug. One of the queries is returning wrong results. You should open a service request with Oracle Support. Can you please post the version and the platform?

-- 
http://mgogala.freehostia.com

Received on Wed Aug 26 2009 - 02:27:07 CDT