Re: FW: Informix versus Oracle Spatial

my knowledge about Oracle is minimal.

Could it be because Oracle does not index null values.

"Superboer" <superboer7_at_planet.nl> wrote in message news:1133422691.225324.315430_at_o13g2000cwo.googlegroups.com...
> Is SQL*Plus: Release 9.2.0.1.0 a Cretaceous or Jurassic version ????
>
> create table nullix( a int, b char(10));
> create unique index ixienull on nullix (a);
>
> insert into nullix (b) values ('One ');
> insert into nullix (b) values ('One Dupl');
> insert into nullix (b) values ('Two Dupl');
>
> select count(*) , a from nullix
> group by a
>
> gives back 3 so i get 3 nulls in my table where the index is
> unique.....
> informix (V 9.30) pukes at the second insert ... duplicate....
>
> if obstacle can't even keep their pants up with normal indices i will
> not trust
> them at all with exotic things.
>
> you will probably tell me that the above is how it should work...
> right??
> having multiple null values in a unique index....
>
> Superboer.
>
>
>
> DA Morgan schreef:
>
>> Simon wrote:
>>
>> > You can rebuild them online, but I don't think this is supported by
>> > Oracle as it can put a lot of stress on the shared pool which in turn
>> > can cause core dumps
>>
>> Nonsense.
>>
>> and possibe unforseen/unrequired downtime. The
>> > official work around of which is to do the rebuilds offline. I think it
>> > is quite a 'buggy' problem, and apparently fixed in later versions of
>> > 9i and in 10g.
>>
>> Also known as the currently supported versions of the product.
>>
>> Referring back, with any product, to Cretaceous or Jurassic versions
>> will always let you criticize. The thigs I could tell you about
>> Informix 1.0 ....
>> --
>> Daniel A. Morgan
>> http://www.psoug.org
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>
Received on Thu Dec 01 2005 - 05:11:53 CST