Bug in 8.1.7?

From: <Alexander.Feinstein_at_MitchellRepair.com>
Date: Wed, 27 Dec 2000 14:20:23 -0800
Message-Id: <10723.125375@fatcity.com>

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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>Bug in 8.1.7?</TITLE>
</HEAD>
<BODY>

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,
Received on Wed Dec 27 2000 - 16:20:23 CST