-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 5:58 PM
To: Multiple recipients of list ORACLE-L
Subject: wrong result from selectHi,
Can anybody try this on 9i?
set echo on
alter session set optimizer_mode=choose;
alter session set cursor_sharing=force;
create table tb1 (f1 number(4));
insert into tb1 values (1999);
insert into tb1 values (2000);
insert into tb1 values (2001);
insert into tb1 values (2002);
commit;
select * from tb1;
analyze table tb1 compute statistics;
select f1 from tb1 where f1 between 2000 and 2000;
select f1 from tb1 where f1 between 2000 and 2001;
select f1 from tb1 where f1 between 2001 and 2000;
drop table tb1;Here is what I got on 8.1.7.2.1 64bit on HP-UX 11.0:
SQL> select * from tb1;
F1
----------
1999
2000
2001
2002
SQL> select f1 from tb1 where f1 between 2000 and 2000;
F1
----------
2000
SQL> select f1 from tb1 where f1 between 2000 and 2001;
F1
----------
2000
SQL> select f1 from tb1 where f1 between 2001 and 2000;
F1
----------
2001TIA
Alex.
PS. What about cursor_sharing=similar ?
Title: wrong result from select
it
works correctly on 9i but gave me the same erroneous results in 8.1.7.3
Solaris.
- wrong result from select Alexander . Feinstein
- Re: wrong result from select Joe Testa
- RE: wrong result from select Khedr, Waleed
- RE: wrong result from select Enrique Orbegozo
- RE: wrong result from select Ron Thomas
- RE: wrong result from select Alexander . Feinstein
- Re: wrong result from select Scott Canaan
- RE: wrong result from select Jesse, Rich
- Re: wrong result from select Brian McGraw
- RE: wrong result from select Alexander . Feinstein