Re: ORACLE DOESN'T COMPLY TO BASIC STANDARD SQL: SIMPLE QUERIES DOESN'T WORK

Hans Forbrich said
>I don't understand. Are you saying that this returns 1476? I just tried
>it with a supported version of the database (10gR2) and got the following:

>SQL> l
> 1 select nmbr from Numbers where nmbr not in
> 2 (select 1/value from IntNumbers Where Kind='POSITIVE INT' or
> 3* Kind='NEGATIVE INT')
>SQL> /
> NMBR
>----------
> .5

Hi,

thank you for your test, this is a right result, so this flaw does not appear in 10gR2.
The query should not return 1476 error but it does on some Oracle versions , including 9.2.0.5.0 :

So far :

V6 SUN                  NOK
V6 Dos standalone  NOK
V7 Netware             NOK
8.0.5.0.0 unix server NOK
7.3.2.3.0                 NOK
8.1.7                       Should be OK (I will try again tomorrow)
9.2.0.5.0                 NOK
10gR2                     OK

at least it should be fixed in further version of Oracle 9 Received on Fri Nov 04 2005 - 04:29:08 CST