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

From: <joel-garry_at_home.com>
Date: 4 Nov 2005 17:30:44 -0800
Message-ID: <1131154244.869599.177490@g49g2000cwa.googlegroups.com>

Appears to be NOK on hp-ux 11 9206.

   1/VALUE

---

     -.125


        .1



      NMBR
----------
     -.125


        .1


        (select 1/value from IntNumbers Where Kind='POSITIVE INT' or
                 *

ERROR at line 2:
ORA-01476: divisor is equal to zero

      NMBR

---

.5

SQL> It appears to be taking the number from the set of NOT ('POSITIVE INT' ,'NEGATIVE INT') and dividing that, which happens to be 0, into 1, which would not be correct.

Works fine on XE.

jg

-- 
@home.com is bogus.

Received on Fri Nov 04 2005 - 19:30:44 CST