Re: Comparing two rowids

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 28 Nov 2006 14:32:57 -0800
Message-ID: <bf46380611281432o7b76f220y78ffc0126deefb05@mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 28 2006 - 16:32:57 CST