Got unexpected result with query partition table
From: xbin999 <xbin999_at_sina.com>
Date: 24 Mar 2003 00:52:14 -0800
Message-ID: <b34a96f2.0303240052.307ce44a_at_posting.google.com>
Date: 24 Mar 2003 00:52:14 -0800
Message-ID: <b34a96f2.0303240052.307ce44a_at_posting.google.com>
I wrote the following sql sentence in sqlplus:
select id from mytable where and id=id1
/
I got the result: id1.
But while I used another sentence:
select id from mytable where partition_key='key1' and id=id1
/
I got the result: id2 (another id not id1)
The table is partitioned by the partition_key. The partition type is
list, and the id is a global index.
The environment is HP-UX/Oracle 9i.
What's the matter? Have relation with partition? Is it a bug of
oracle?
Received on Mon Mar 24 2003 - 09:52:14 CET