Foreign Key test case

[Steffen Goeldner]

Attached is a small test case (SQL script) that defines some
PRIMARY and FOREIGN KEY CONSTRAINTs.
I'll send some driver specific results soon ...


Steffen

create table tst.p1
(
  k1 integer
, k2 integer
, CONSTRAINT pk_p1 PRIMARY KEY ( k1, k2 )
)
/

create table tst.c1
(
  k1 integer
, k2 integer
, CONSTRAINT fk_c1 FOREIGN KEY ( k1, k2 ) REFERENCES tst.p1
)
/

create table tst.c2
(
  k1 integer
, k2 integer
, CONSTRAINT fk_c2 FOREIGN KEY ( k1, k2 ) REFERENCES tst.p1
)
/

create table tst.u1
(
  k1 integer
, k2 integer
, CONSTRAINT uk_u1 UNIQUE ( k1, k2 )
)
/

create table tst.c3
(
  k1 integer
, k2 integer
, CONSTRAINT fk_c3 FOREIGN KEY ( k1, k2 ) REFERENCES tst.u1 ( k1, k2 )
)
/