create table t1
(
 c1 integer,
 constraint pk_t1 primary key (c1)
);

create table t2
(
 c1 integer,
 c2 integer,
 constraint pk_t2 primary key (c1),
 constraint fk_t2_c2 foreign key (c2) references t1 (c1)
);

insert into t2 values (100,null);

The insert statement fails with a foreign key constraint violation error.
This is incorrect, the constraint should not be checked with null values in
the referencing column.

Ole Willy Tuv

Ole,

<< The insert statement fails with a foreign key constraint violation error.
This is incorrect, the constraint should not be checked with null values in
the referencing column. >>

Noted.

--
Tim Young
Elevate Software
www.elevatesoft.com

Ole,

This is fixed.

--
Tim Young
Elevate Software
www.elevatesoft.com