Is this a bug?

From: Doug Bast <dbast_at_envistatech.com>
Date: Tue, 04 Jan 2000 19:57:36 GMT
Message-ID: <Qgsc4.13$5k.196686@tomcat.sk.sympatico.ca>

Relational database, this should work, and it does, for every version of oracle up to 8.1.5 (8i). Could anyone please verify this for me by running the following script on an 8.1.5, 8.1.6 oracle database?

Thanks.
dbast_at_envistatech.com

---

DROP TABLE T2;
DROP TABLE T1; CREATE TABLE T1 (
       t1_id NUMBER(12) NOT NULL );
CREATE TABLE T2 (
       t1_id NUMBER(12) NOT NULL );

ALTER TABLE T1
ADD ( CONSTRAINT XPKT1 PRIMARY KEY (t1_id) ) ;

ALTER TABLE T2
ADD ( CONSTRAINT t2_foreign

       FOREIGN KEY (t1_id)
       REFERENCES T1
       ON DELETE CASCADE ) ;

CREATE OR REPLACE TRIGGER T1_BEFORE_TABLE BEFORE UPDATE OR DELETE OR INSERT ON T1 FOR EACH ROW
BEGIN
    null;
END;
/

CREATE OR REPLACE TRIGGER T1_AFTER_TABLE AFTER UPDATE OR DELETE OR INSERT ON T1
BEGIN
    null;
END;
/

CREATE OR REPLACE TRIGGER T1_BEFORE_ROW BEFORE UPDATE OR DELETE OR INSERT ON T1 FOR EACH ROW
BEGIN
    null;
END;
/

CREATE OR REPLACE TRIGGER T2_BEFORE_TABLE BEFORE UPDATE OR DELETE OR INSERT ON T2 FOR EACH ROW
BEGIN
    null;
END;
/

CREATE OR REPLACE TRIGGER T2_AFTER_TABLE AFTER UPDATE OR DELETE OR INSERT ON T2
BEGIN
    null;
END;
/

CREATE OR REPLACE TRIGGER T2_BEFORE_ROW BEFORE UPDATE OR DELETE OR INSERT ON T2 FOR EACH ROW
BEGIN
    null;
END;
/

delete from t1;

---

Received on Tue Jan 04 2000 - 13:57:36 CST