Re: Comparing two rowids
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: contactarul@xxxxxxxxx
- Date: Tue, 28 Nov 2006 14:32:57 -0800
On 11/28/06, Arul Ramachandran <contactarul@xxxxxxxxx> 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
Other related posts:
