RE: wrong result from select

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Tue, 12 Feb 2002 07:52:55 -0800
Message-ID: <F001.0040CAE1.20020212071325@fatcity.com>

Hmmm...I've been executing this a script in TOAD, which seems to account for some differences. The really wierd thing in TOAD is that the SELECT acually WORKS CORRECTLY if I insert a COMMENT immediately after the ANALYZE statement! Of course, comments don't make a lick of difference in this for SQL*Plus.

Wierd, wierd, wierd.

Let us know what you get from your TAR! Thx! :)

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

-----Original Message-----

[mailto:Alexander.Feinstein_at_mitchell1.com] Sent: Monday, February 11, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L

Thanks Rich,
But it does not work.
One should execute with exactly same order. I you do "where f1 >= 2000 and f1 <= 2001" first, everything works fine (as expected).
Here is the last part of the output
SQL> select f1 from tb1 where f1 >= 2000 and f1 <= 2000;

2000
SQL> select f1 from tb1 where f1 >= 2000 and f1 <= 2001;

2000
SQL> select f1 from tb1 where f1 >= 2001 and f1 <= 2000;

2001
SQL> drop table tb1;
Table dropped.
SQL>
So far,
works properly on

8.1.6.0.0 NT 
8.1.6.0.0 32bit Solaris 
9.0.1.2 Linux 
9.0.1.2 AIX 
9.0.1 Solaris

does not work on

8.1.7.2.0 64bit HP-UX 
8.1.7.2.0 32bit HP-UX 
8.1.7.3 Solaris

Alex.
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Feb 12 2002 - 09:52:55 CST