*** ./expected/foreign_key.out Thu Oct 11 17:07:15 2001 --- ./results/foreign_key.out Tue Oct 23 14:45:41 2001 *************** *** 9,14 **** --- 9,16 ---- NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'pktable_pkey' for table 'pktable' CREATE TABLE FKTABLE ( ftest1 int REFERENCES PKTABLE MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE, ftest2 int ); NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) + NOTICE: _outNode: don't know how to print type 725 + NOTICE: _outNode: don't know how to print type 725 -- Insert test data into PKTABLE INSERT INTO PKTABLE VALUES (1, 'Test1'); INSERT INTO PKTABLE VALUES (2, 'Test2'); *************** *** 233,238 **** --- 235,242 ---- NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'pktable_pkey' for table 'pktable' CREATE TABLE FKTABLE ( ftest1 int REFERENCES PKTABLE MATCH FULL, ftest2 int ); NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) + NOTICE: _outNode: don't know how to print type 725 + NOTICE: _outNode: don't know how to print type 725 -- Insert test data into PKTABLE INSERT INTO PKTABLE VALUES (1, 'Test1'); INSERT INTO PKTABLE VALUES (2, 'Test2'); *************** *** 733,744 **** --- 737,752 ---- -- because varchar=int does exist CREATE TABLE FKTABLE (ftest1 varchar REFERENCES pktable); NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) + NOTICE: _outNode: don't know how to print type 725 + NOTICE: _outNode: don't know how to print type 725 DROP TABLE FKTABLE; NOTICE: DROP TABLE implicitly drops referential integrity trigger from table "pktable" NOTICE: DROP TABLE implicitly drops referential integrity trigger from table "pktable" -- As should this CREATE TABLE FKTABLE (ftest1 varchar REFERENCES pktable(ptest1)); NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) + NOTICE: _outNode: don't know how to print type 725 + NOTICE: _outNode: don't know how to print type 725 DROP TABLE FKTABLE; NOTICE: DROP TABLE implicitly drops referential integrity trigger from table "pktable" NOTICE: DROP TABLE implicitly drops referential integrity trigger from table "pktable" *************** *** 827,832 **** --- 835,842 ---- NOTICE: CREATE TABLE/UNIQUE will create implicit index 'pktable_base1_key' for table 'pktable' create table fktable (ftest1 int references pktable(base1)); NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) + NOTICE: _outNode: don't know how to print type 725 + NOTICE: _outNode: don't know how to print type 725 -- now some ins, upd, del insert into pktable(base1) values (1); insert into pktable(base1) values (2); ======================================================================