Message-Id: <10723.125375@fatcity.com> From: Alexander.Feinstein@MitchellRepair.com Date: Wed, 27 Dec 2000 14:20:23 -0800 Subject: Bug in 8.1.7? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07053.366C3DD6 Content-Type: text/plain; charset="ISO-8859-1" Hi All, Oracle EE 8.1.7.0.0 64-bit for HP-UX 11.0 Can anybody reproduce this? Oracle Support cannot :). How about 8.1.6? alter session set cursor_sharing=force; select value from v$parameter where name = 'cursor_sharing'; drop table test12704; create table test12704 (f1 varchar2(3), f2 varchar2(3)); insert into test12704 values ('A', 'B'); insert into test12704 values ('C', 'D'); commit; select * from test12704; select * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 = 'D'); select /*+ ORDERED */ * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 = 'D'); analyze table test12704 compute statistics; select * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 = 'D'); select /*+ RULE */ * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 = 'D'); select * from test12704 where (f1 = 'A' and f2 = 'B'); select * from test12704 where (f1 = 'C' and f2 = 'D'); alter session set cursor_sharing=exact; select * from test12704 where (f1 = 'A' and f2 = 'B') or (f1 = 'C' and f2 = 'D'); drop table test12704; TIA, Alex. ------_=_NextPart_001_01C07053.366C3DD6 Content-Type: text/html; charset="ISO-8859-1" Bug in 8.1.7?

Hi All,

Oracle EE 8.1.7.0.0 64-bit for HP-UX 11.0

Can anybody reproduce this? Oracle Support cannot :).
How about 8.1.6?

alter session set cursor_sharing=force;
select value from v$parameter where name = 'cursor_sharing';
drop table test12704;
create table test12704 (f1 varchar2(3), f2 varchar2(3));
insert into test12704 values ('A', 'B');
insert into test12704 values ('C', 'D');
commit;
select * from test12704;
select * from test12704
where (f1 = 'A' and f2 = 'B')
   or (f1 = 'C' and f2 = 'D');
select /*+ ORDERED */ * from test12704
where (f1 = 'A' and f2 = 'B')
   or (f1 = 'C' and f2 = 'D');
analyze table test12704 compute statistics;
select * from test12704
where (f1 = 'A' and f2 = 'B')
   or (f1 = 'C' and f2 = 'D');
select /*+ RULE */ * from test12704
where (f1 = 'A' and f2 = 'B')
   or (f1 = 'C' and f2 = 'D');
select * from test12704
where (f1 = 'A' and f2 = 'B');
select * from test12704
where (f1 = 'C' and f2 = 'D');
alter session set cursor_sharing=exact;
select * from test12704
where (f1 = 'A' and f2 = 'B')
   or (f1 = 'C' and f2 = 'D');
drop table test12704;

TIA,