Re: TDE issues
- From: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
- To: "William Wagman" <wjwagman@xxxxxxxxxxx>
- Date: Thu, 24 May 2007 15:52:15 +0200
Bill, I did some tests with 2 dbs, and I do not get any wrong results.
Are you sure you're on 10.2.0.3 on both dbs?
There's this bug 6057069 that looks a bit like your case, but they cannot
reproduce on 10.2.0.3 (as I did not reproduce myself).
rgds
On 5/24/07, William Wagman <wjwagman@xxxxxxxxxxx> wrote:
Ghassen, yes, I had a typo, here is the corrected problem...
testx=SQL>select * from t1;
C1
--
1
2
2 rows selected.
testx=SQL>select * from t1 where exists
2 (select 'x' from oracle.t2@devx a
3 where a.c1 = t1.c1);
C1
--
1
1 row selected.
testx=SQL>select * from t1 where not exists
2 (select 'x' from oracle.t2@devx a
3 where a.c1 = t1.c1);
C1
--
2
1 row selected.
testx=SQL>exit
In devx...
devx=SQL>select * from t2;
C1
--
1
3
2 rows selected.
devx=SQL>select * from t2 where exists
2 (select 'x' from oracle.t1@testx a
3 where a.c1 = t2.c1);
C1
--
1
1 row selected.
devx=SQL>select * from t2 where not exists
2 (select 'x' from oracle.t1@testx a
3 where a.c1 = t2.c1);
C1
--
1
3
2 rows selected.
devx=SQL>exit
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
------------------------------
*From:* Ghassan Salem [mailto:salem.ghassan@xxxxxxxxx]
*Sent:* Wednesday, May 23, 2007 1:31 AM
*To:* William Wagman
*Cc:* oracle-l
*Subject:* Re: TDE issues
Bill,
are you sure of your test case?
the second query on testx
select * from t1 where not exists (select 'x' from oracle.t2@devx a where
a.c1 = t1.c1);
cannot return the result that you mention
1
as there is no such data in t1 in testx (otherwise, this is a 'wrong
result' case).
rgds
Other related posts: