Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i (Version 8.1.5) bug

Re: Oracle 8i (Version 8.1.5) bug

From: Vipul Lakhani <vipul_at_dircon.co.uk>
Date: 2000/05/22
Message-ID: <rogW4.619$6T1.97126@news.dircon.co.uk>#1/1

Could you please post the four scripts ... i would be most interested

vipul

"ShenHN" <hwa.n.shenNOhwSPAM_at_jci.com.invalid> wrote in message news:0801e142.1f353f95_at_usw-ex0102-084.remarq.com...
> I like to report an extremely serious and dangerous bug in
> Oracle8i (Version 8.1.5). This bug has been reported in TAR
> 1093520.999 and has been verified by Oracle support.
>
> The error, simply stated, is that two equivalent SQL SELECT
> queries can return different results. I have submitted a test
> case consisting of four SQL scripts: (1) create schema of 5
> tables, (2) populate tables (app. 20 rows of data) and the two
> SQL SELECT statements that return correct and incorrect result
> sets. Oracle support has run the test case against both 32 bit &
> 64 bit Oracle8i version 8.1.5 for both the Solaris and HP
> platforms. In all these cases, the results are consistent, i.e.,
> the two SQL SELECT statements return different answers. For
> Johnson Controls Inc., a leader in the building automation
> industry, the consequence of such a bug can be disastrous. Oracle
> has found the source of the bug and has issued a patch that at
> least works against the test case I submitted on the HP 64 bit
> platform.
>
> I have suggested that Oracle issue an advisory, warning Oracle
> customers of the potential problem. Oracle has steadfastly
> refused to issue such warning, claiming the condition under which
> this error can occur is rare. IMHO, I believe it's more common
> than Oracle thinks.
>
> I can post the 4 SQL scripts if there is enough interest in the
> newsgroup.
>
> Hwa N. Shen
> Johnson Controls, Inc.
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Mon May 22 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US