Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Comparing two rowids

Re: Comparing two rowids

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 29 Nov 2006 08:01:56 +0000
Message-ID: <7765c8970611290001y3e830298u8e5585861ae17058@mail.gmail.com>


I agree with Jared that different results looks like a bug, I also agree however with Arul that the comparison operation seems meaningless. It would seem in the same class as < comparisons for colours

On 11/28/06, Jared Still <jkstill_at_gmail.com> wrote:
> On 11/28/06, Arul Ramachandran <contactarul_at_gmail.com> wrote:
> >
> > Oracle 10.2.0.1:
> >
> >
> To me comparing two rowids does not make sense, I can't see how one rowid
> > be greater than another? But then I see a ML note 2714430.8: "Bug 2714430
> > - Wrong results from ROWID comparison to rowid with slot#>32767" that
> talks
> > about rowid comparison.
> >
> > Any insights on this?
> >
> >
>
> I thought perhaps the data type for a ROWID in a table might
> differ from the data type used for a transient ROWID.
> (this happens with DATE types)
>
> Not so.
>
> 14:32:23 SQL>l
> 1* select dump(rid1), dump(rowid) from dummy
> 14:32:24 SQL>/
>
> DUMP(RID1)
> ----------------------------------------------------------------------------------------------------
> DUMP(ROWID)
> ----------------------------------------------------------------------------------------------------
> Typ=69 Len=10: 0,0,163,228,2,129,27,59,0,2
> Typ=69 Len=10: 0,0,215,37,1,0,1,14,0,0
>
>
> 1 row selected.
>
> Both the same type. Sure looks like a bug.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 29 2006 - 02:01:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US