on delete cascade doesn't work...
I am working with Dynamic Server 7.3. When I use 'on delete cascade' the
cascade deleting don't take place. It migth...
CREATE TABLE E1 (
p1 char(18) NOT NULL
);
ALTER TABLE E1
ADD CONSTRAINT PRIMARY KEY (p1);
CREATE TABLE E12 (
p1 char(18) NOT NULL,
p2 char(18) NOT NULL
);
ALTER TABLE E12
ADD CONSTRAINT PRIMARY KEY (p1, p2);
CREATE TABLE E2 (
p2 char(18) NOT NULL
);
ALTER TABLE E2
ADD CONSTRAINT PRIMARY KEY (p2);
ALTER TABLE E12
ADD CONSTRAINT FOREIGN KEY (p2)
REFERENCES E2
ON DELETE CASCADE;
ALTER TABLE E12
ADD CONSTRAINT FOREIGN KEY (p1)
REFERENCES E1
ON DELETE CASCADE;
insert into e1 values('a');
insert into e2 values('b');
insert into e12 values('a','b');
delete from e1 where p1='a';
[Informix][Dynamic Server][test] SQL Error (-692) : Key value for constraint
(admin.u103_11) is still being referenced.
I am lost...
Thanks in advance.