![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Wed, Jan 10 2007 11:44 AM | Permanent Link |
"Ole Willy Tuv" | 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 |
Wed, Jan 10 2007 5:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Thu, Jan 11 2007 6:34 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |